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