| ( ! ) Fatal error: Uncaught Exception: Error: Column 'name' in order clause is ambiguous<br />Error No: 1052<br />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 = '1' AND md.language_id = '1' ORDER BY name in /var/www/html/system/library/db/mysqli.php on line 41 |
| ( ! ) Exception: Error: Column 'name' in order clause is ambiguous<br />Error No: 1052<br />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 = '1' AND md.language_id = '1' ORDER BY name in /var/www/html/system/library/db/mysqli.php on line 41 |
| Call Stack |
| # | Time | Memory | Function | Location |
| 1 | 0.0003 | 398088 | {main}( ) | .../index.php:0 |
| 2 | 0.0050 | 722464 | start( $application_config = 'catalog' ) | .../index.php:20 |
| 3 | 0.0053 | 752616 | require_once( '/var/www/html/system/framework.php ) | .../startup.php:104 |
| 4 | 0.0263 | 1006424 | Router->dispatch( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' }, $error = class Action { private $id = 'error/not_found'; private $route = 'error/not_found'; private $method = 'index' } ) | .../framework.php:169 |
| 5 | 0.0656 | 1643616 | Router->execute( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' } ) | .../router.php:56 |
| 6 | 0.0656 | 1643616 | Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'log' => class Log { ... }, 'event' => class Event { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'model_design_translation' => class Proxy { ... }, 'url' => class Url { ... }, 'model_localisation_language' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'model_localisation_currency' => class Proxy { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Cart\Tax { ... }, 'weight' => class Cart\Weight { ... }, 'length' => class Cart\Length { ... }, 'cart' => class Cart\Cart { ... }, 'encryption' => class Encryption { ... }, 'model_setting_event' => class Proxy { ... }, 'model_catalog_manufacturer' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }] }, $args = ??? ) | .../router.php:67 |
| 7 | 0.0657 | 1649064 | ControllerStartupRouter->index( ) | .../action.php:79 |
| 8 | 0.0662 | 1655736 | Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'log' => class Log { ... }, 'event' => class Event { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'model_design_translation' => class Proxy { ... }, 'url' => class Url { ... }, 'model_localisation_language' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'model_localisation_currency' => class Proxy { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Cart\Tax { ... }, 'weight' => class Cart\Weight { ... }, 'length' => class Cart\Length { ... }, 'cart' => class Cart\Cart { ... }, 'encryption' => class Encryption { ... }, 'model_setting_event' => class Proxy { ... }, 'model_catalog_manufacturer' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }] }, $args = ??? ) | .../router.php:25 |
| 9 | 0.0676 | 1740640 | ControllerProductManufacturer->index( ) | .../action.php:79 |
| 10 | 0.0705 | 1784000 | Proxy->getManufacturers( ) | .../manufacturer.php:26 |
| 11 | 0.0705 | 1784000 | Proxy->__call( $key = 'getManufacturers', $args = [] ) | .../manufacturer.php:26 |
| 12 | 0.0705 | 1784784 | Loader->{closure:/var/www/html/system/engine/loader.php:220-262}( $args = [], [] ) | .../proxy.php:47 |
| 13 | 0.0707 | 1785864 | ModelCatalogManufacturer->getManufacturers( $data = ??? ) | .../loader.php:248 |
| 14 | 0.0708 | 1786184 | DB->query( $sql = '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 = \'1\' AND md.language_id = \'1\' ORDER BY name' ) | .../manufacturer.php:63 |
| 15 | 0.0708 | 1786184 | DB\MySQLi->query( $sql = '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 = \'1\' AND md.language_id = \'1\' ORDER BY name' ) | .../db.php:45 |