Fatal error: Uncaught Exception: Error: Column 'name' in order clause 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 in /home/m/mxtsuywf/examplemxt.ru/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/m/mxtsuywf/examplemxt.ru/public_html/system/library/db.php(45): DB\MySQLi->query('SELECT * FROM o...') #1 /home/m/mxtsuywf/examplemxt.ru/public_html/catalog/model/catalog/manufacturer.php(63): DB->query('SELECT * FROM o...') #2 [internal function]: ModelCatalogManufacturer->getManufacturers() #3 /home/m/mxtsuywf/examplemxt.ru/public_html/storage/modification/system/engine/loader.php(248): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /home/m/mxtsuywf/examplemxt.ru/public_html/system/engine/proxy.php(47): call_user_func_array(Object(Closure), Array) #6 /home/m/mxtsuywf/examplemxt.ru/public_html/storage/modification/catalog/controller/product/manufacturer.php(39): Proxy->__call('getManufacturer...', Array) #7 [internal function]: ControllerProductManufacturer->index() #8 /home/m/mxtsuywf/examplemxt.ru/public_html/storage/modification/system/engine/action.php(79): call_user_func_array(Array, Array) #9 /home/m/mxtsuywf/examplemxt.ru/public_html/catalog/controller/startup/router.php(25): Action->execute(Object(Registry)) #10 [internal function]: ControllerStartupRouter->index() #11 /home/m/mxtsuywf/examplemxt.ru/public_html/storage/modification/system/engine/action.php(79): call_user_func_array(Array, Array) #12 /home/m/mxtsuywf/examplemxt.ru/public_html/storage/modification/system/engine/router.php(78): Action->execute(Object(Registry)) #13 /home/m/mxtsuywf/examplemxt.ru/public_html/storage/modification/system/engine/router.php(67): Router->execute(Object(Action)) #14 /home/m/mxtsuywf/examplemxt.ru/public_html/system/framework.php(168): Router->dispatch(Object(Action), Object(Action)) #15 /home/m/mxtsuywf/examplemxt.ru/public_html/system/startup.php(106): require_once('/home/m/mxtsuyw...') #16 /home/m/mxtsuywf/examplemxt.ru/public_html/index.php(19): start('catalog') #17 {main} thrown in /home/m/mxtsuywf/examplemxt.ru/public_html/system/library/db/mysqli.php on line 40