| ( ! ) Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT ucd.title FROM oc_unit_description ucd WHERE p.unit_id = ucd.unit_id AND ' at line 1<br />Error No: 1064<br />SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.produ in /var/www/web-z20911/data/www/stroiclick.ru/system/library/db/mysqli.php on line 49 |
|---|
| Call Stack |
|---|
| # | Time | Memory | Function | Location |
|---|
| 1 | 0.0236 | 1674888 | newrelic_exception_handler( $exception = class Exception { protected $message = 'Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'SELECT ucd.title FROM oc_unit_description ucd WHERE p.unit_id = ucd.unit_id AND \' at line 1<br />Error No: 1064<br />SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = \'1\' AND pd2.quantity = \'1\' AND ((pd2.date_start = \'0000-00-00\' OR pd2.date_'...; private $string = 'Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'SELECT ucd.title FROM oc_unit_description ucd WHERE p.unit_id = ucd.unit_id AND \' at line 1<br />Error No: 1064<br />SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = \'1\' AND pd2.quantity = \'1\' AND ((pd2.date_start = \'0000-00-00\' O'...; protected $code = 0; protected $file = '/var/www/web-z20911/data/www/stroiclick.ru/system/library/db/mysqli.php'; protected $line = 49; private $trace = [0 => [...], 1 => [...], 2 => [...], 3 => [...], 4 => [...], 5 => [...], 6 => [...], 7 => [...], 8 => [...], 9 => [...], 10 => [...]]; private $previous = NULL; public $xdebug_message = '<tr><th align=\'left\' bgcolor=\'#f57900\' colspan="5"><span style=\'background-color: #cc0000; color: #fce94f; font-size: x-large;\'>( ! )</span> Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'SELECT ucd.title FROM oc_unit_description ucd WHERE p.unit_id = ucd.unit_id AND \' at line 1<br />Error No: 1064<br />SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM'... } ) | .../Unknown:0 |
| ( ! ) Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT ucd.title FROM oc_unit_description ucd WHERE p.unit_id = ucd.unit_id AND ' at line 1<br />Error No: 1064<br />SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT ucd.unit FROM oc_unit_description ucd WHERE p.unit_id = ucd.unit_id AND ucd.language_id = '1') AS unit, SELECT ucd.title FROM oc_unit_description ucd WHERE p.unit_id = ucd.unit_id AND ucd.language_id = '1') AS unit_title, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '168' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /var/www/web-z20911/data/www/stroiclick.ru/system/library/db/mysqli.php on line 49 |
|---|
| Call Stack |
|---|
| # | Time | Memory | Function | Location |
|---|
| 1 | 0.0001 | 367344 | {main}( ) | .../index.php:0 |
| 2 | 0.0014 | 379056 | start( $application_config = 'catalog' ) | .../index.php:30 |
| 3 | 0.0014 | 380880 | require_once( '/var/www/web-z20911/data/www/stroiclick.ru/system/framework.php ) | .../startup.php:104 |
| 4 | 0.0040 | 425576 | 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.0199 | 1582040 | Router->execute( $action = class Action { private $id = 'product/product'; private $route = 'product/product'; private $method = 'index' } ) | .../router.php:56 |
| 6 | 0.0199 | 1582040 | 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 { ... }, 'progroman_city_manager' => class progroman\CityManager\CityManager { ... }, 'progroman_citymanager' => class progroman\CityManager\CityManager { ... }, 'model_extension_module_progroman_citymanager' => class Proxy { ... }, '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_design_theme' => class Proxy { ... }, 'prmn_cmngr' => '<div class="prmn-cmngr__content">\n <div class="prmn-cmngr__title">\n <span class="prmn-cmngr__title-text"></span>\n <a class="prmn-cmngr__city">\n <span class="fa fa-map-marker"></span> <span class="prmn-cmngr__city-name">Константиновск</span>\n </a>\n </div>\n <div class="prmn-cmngr__confirm">\n Ваш город — <span class="prmn-cmngr__confirm-city">Константиновск</span>?\n <div class="prmn-cmngr__confirm-btns">\n <input class="prmn-cmngr__confirm-'..., 'model_catalog_category' => class Proxy { ... }, 'model_catalog_manufacturer' => class Proxy { ... }, 'model_catalog_product' => class Proxy { ... }] }, $args = ??? ) | .../router.php:67 |
| 7 | 0.0199 | 1583424 | ControllerProductProduct->index( ) | .../action.php:79 |
| 8 | 0.0230 | 1648728 | Proxy->getProduct( 168 ) | .../product.php:186 |
| 9 | 0.0230 | 1649104 | Proxy->__call( $key = 'getProduct', $args = [0 => 168] ) | .../product.php:186 |
| 10 | 0.0230 | 1649888 | Loader->{closure:/var/www/web-z20911/data/www/stroiclick.ru/system/storage-r24/modification/system/engine/loader.php:223-265}( $args = [0 => 168], [0 => 168] ) | .../proxy.php:47 |
| 11 | 0.0231 | 1650944 | ModelCatalogProduct->getProduct( $product_id = 168 ) | .../loader.php:251 |
| 12 | 0.0231 | 1653504 | DB->query( $sql = 'SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = \'1\' AND pd2.quantity = \'1\' AND ((pd2.date_start = \'0000-00-00\' OR pd2.date_start < NOW()) AND (pd2.date_end = \'0000-00-00\' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = \'1\' AND ((ps.date_sta'... ) | .../product.php:55 |
| 13 | 0.0231 | 1653504 | DB\MySQLi->query( $sql = 'SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = \'1\' AND pd2.quantity = \'1\' AND ((pd2.date_start = \'0000-00-00\' OR pd2.date_start < NOW()) AND (pd2.date_end = \'0000-00-00\' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = \'1\' AND ((ps.date_sta'... ) | .../db.php:45 |