( ! ) 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/sakura69_fr/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/sakura69_fr/system/library/db/mysqli.php on line 40 |
Call Stack |
# | Time | Memory | Function | Location |
1 | 0.0001 | 393600 | {main}( ) | .../index.php:0 |
2 | 0.0006 | 405904 | require_once( '/var/www/html/resto/jp_v_1_6/sakura69_fr/system/framework.php' ) | .../index.php:22 |
3 | 0.0029 | 460144 | Front->dispatch( ) | .../framework.php:99 |
4 | 0.0106 | 662208 | Front->execute( ) | .../front.php:29 |
5 | 0.0106 | 662208 | Action->execute( ) | .../front.php:34 |
6 | 0.0106 | 663216 | ControllerStartupRouter->index( ) | .../action.php:44 |
7 | 0.0107 | 663392 | Action->execute( ) | .../router.php:25 |
8 | 0.0898 | 739952 | ControllerProductSpecial->index( ) | .../action.php:44 |
9 | 0.1509 | 784400 | Proxy->getTotalProductSpecials( ) | .../special.php:97 |
10 | 0.1509 | 784456 | Proxy->__call( ) | .../special.php:97 |
11 | 0.1509 | 784456 | Loader->{closure:/var/www/html/resto/jp_v_1_6/sakura69_fr/system/engine/loader.php:131-166}( ) | .../proxy.php:13 |
12 | 0.1509 | 784744 | ModelCatalogProduct->getTotalProductSpecials( ) | .../loader.php:153 |
13 | 0.1509 | 785192 | DB->query( ) | .../product.php:542 |
14 | 0.1509 | 785192 | DB\MySQLi->query( ) | .../db.php:16 |