Error: Error: Column 'name' in ORDER BY is ambiguous
Error No: 1052
SELECT * FROM `oc_manufacturer` `m` LEFT JOIN `oc_manufacturer_description` `md` ON (`m`.`manufacturer_id` = `md`.`manufacturer_id`) LEFT JOIN `oc_manufacturer_to_store` `m2s` ON (`m`.`manufacturer_id` = `m2s`.`manufacturer_id`) WHERE `m2s`.`store_id` = '0' AND `md`.`language_id` = '1' ORDER BY `name` ASC File: /home/cgcmart/public_html/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/cgcmart/public_html/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/cgcmart/public_html/catalog/model/catalog/manufacturer.php Line: 84 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/cgcmart/public_html/system/engine/loader.php Line: 343 Class: Opencart\Catalog\Model\Catalog\Manufacturer Function: getManufacturers Backtrace: 3 File: /home/cgcmart/public_html/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/cgcmart/public_html/catalog/controller/product/manufacturer.php Line: 35 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/cgcmart/public_html/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Manufacturer Function: index Backtrace: 6 File: /home/cgcmart/public_html/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /home/cgcmart/public_html/index.php Line: 20 Function: require_once