( ! ) 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.0001 | 394128 | {main}( ) | .../index.php:0 |
2 | 0.0003 | 406536 | require_once( '/var/www/html/resto/jp_v_1_6/hokkaidoneuilly_fr/system/framework.php' ) | .../index.php:22 |
3 | 0.0028 | 461344 | Front->dispatch( ) | .../framework.php:99 |
4 | 0.0100 | 666488 | Front->execute( ) | .../front.php:29 |
5 | 0.0100 | 666488 | Action->execute( ) | .../front.php:34 |
6 | 0.0100 | 667496 | ControllerStartupRouter->index( ) | .../action.php:44 |
7 | 0.0102 | 667672 | Action->execute( ) | .../router.php:25 |
8 | 0.0107 | 744232 | ControllerProductSpecial->index( ) | .../action.php:44 |
9 | 0.0112 | 788728 | Proxy->getTotalProductSpecials( ) | .../special.php:97 |
10 | 0.0112 | 788784 | Proxy->__call( ) | .../special.php:97 |
11 | 0.0112 | 788784 | Loader->{closure:/var/www/html/resto/jp_v_1_6/hokkaidoneuilly_fr/system/engine/loader.php:131-166}( ) | .../proxy.php:13 |
12 | 0.0113 | 789088 | ModelCatalogProduct->getTotalProductSpecials( ) | .../loader.php:153 |
13 | 0.0113 | 789536 | DB->query( ) | .../product.php:549 |
14 | 0.0113 | 789536 | DB\MySQLi->query( ) | .../db.php:16 |