| ( ! ) Fatal error: Uncaught Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1<br />Error No: 1064<br />SELECT COUNT(DISTINCT ps.product_id) AS total FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((s.date_start < NOW() AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) ) in /var/www/html/resto/jp_v_1_6/indochine78_com/system/library/db/mysqli.php on line 40 |
|---|
| ( ! ) Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1<br />Error No: 1064<br />SELECT COUNT(DISTINCT ps.product_id) AS total FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((s.date_start < NOW() AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) ) in /var/www/html/resto/jp_v_1_6/indochine78_com/system/library/db/mysqli.php on line 40 |
|---|
| Call Stack |
|---|
| # | Time | Memory | Function | Location |
|---|
| 1 | 0.0000 | 393776 | {main}( ) | .../index.php:0 |
| 2 | 0.0004 | 406128 | require_once( '/var/www/html/resto/jp_v_1_6/indochine78_com/system/framework.php' ) | .../index.php:22 |
| 3 | 0.0027 | 460584 | Front->dispatch( ) | .../framework.php:99 |
| 4 | 0.0105 | 762552 | Front->execute( ) | .../front.php:29 |
| 5 | 0.0105 | 762552 | Action->execute( ) | .../front.php:34 |
| 6 | 0.0106 | 768688 | ControllerStartupRouter->index( ) | .../action.php:44 |
| 7 | 0.0107 | 768864 | Action->execute( ) | .../router.php:25 |
| 8 | 0.0111 | 844400 | ControllerProductSpecial->index( ) | .../action.php:44 |
| 9 | 0.0116 | 889152 | Proxy->getTotalProductSpecials( ) | .../special.php:97 |
| 10 | 0.0116 | 889208 | Proxy->__call( ) | .../special.php:97 |
| 11 | 0.0116 | 889208 | Loader->{closure:/var/www/html/resto/jp_v_1_6/indochine78_com/system/engine/loader.php:131-166}( ) | .../proxy.php:13 |
| 12 | 0.0117 | 889496 | ModelCatalogProduct->getTotalProductSpecials( ) | .../loader.php:153 |
| 13 | 0.0117 | 889944 | DB->query( ) | .../product.php:549 |
| 14 | 0.0117 | 889944 | DB\MySQLi->query( ) | .../db.php:16 |