( ! ) 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/hokkaidoneuilly_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/hokkaidoneuilly_fr/system/library/db/mysqli.php on line 40 |
Call Stack |
# | Time | Memory | Function | Location |
1 | 0.0002 | 397256 | {main}( ) | .../index.php:0 |
2 | 0.0032 | 630464 | require_once( '/var/www/html/resto/jp_v_1_6/hokkaidoneuilly_fr/system/framework.php' ) | .../index.php:22 |
3 | 0.0080 | 893200 | Front->dispatch( ) | .../framework.php:99 |
4 | 0.0189 | 1483904 | Front->execute( ) | .../front.php:29 |
5 | 0.0189 | 1483904 | Action->execute( ) | .../front.php:34 |
6 | 0.0189 | 1490040 | ControllerStartupRouter->index( ) | .../action.php:44 |
7 | 0.0191 | 1490216 | Action->execute( ) | .../router.php:25 |
8 | 0.0196 | 1565752 | ControllerProductSpecial->index( ) | .../action.php:44 |
9 | 0.0218 | 1871512 | Proxy->getTotalProductSpecials( ) | .../special.php:97 |
10 | 0.0218 | 1871568 | Proxy->__call( ) | .../special.php:97 |
11 | 0.0218 | 1871568 | Loader->{closure:/var/www/html/resto/jp_v_1_6/hokkaidoneuilly_fr/system/engine/loader.php:131-166}( ) | .../proxy.php:13 |
12 | 0.0219 | 1871872 | ModelCatalogProduct->getTotalProductSpecials( ) | .../loader.php:153 |
13 | 0.0219 | 1872320 | DB->query( ) | .../product.php:549 |
14 | 0.0219 | 1872320 | DB\MySQLi->query( ) | .../db.php:16 |