( ! ) Fatal error: Uncaught exception 'Exception' with message '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 ' in /home/pancer/sites/pancer.com.ua/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 ') GROUP BY op.product_id ORDER BY total DESC ' at line 12<br />Error No: 1064<br /> SELECT COUNT(total) as total FROM ( SELECT COUNT(DISTINCT op.product_id) AS total FROM oc_order_product op LEFT JOIN `oc_order` o ON (op.order_id = o.order_id) LEFT JOIN `oc_product` p ON (op.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (p.date_added >= NOW() - INTERVAL MONTH AND p.date_added <= NOW()) GROUP BY op.product_id ORDER BY total DESC ) bp in /home/pancer/sites/pancer.com.ua/system/library/db/mysqli.php on line 40
Call Stack
#TimeMemoryFunctionLocation
10.0001236416{main}( ).../index.php:0
20.0012268368start( ).../index.php:24
30.0012270168require_once( '/home/pancer/sites/pancer.com.ua/system/framework.php' ).../startup.php:105
40.01431274464Front->dispatch( ).../framework.php:105
50.141614528880Front->execute( ).../front.php:29
60.141614528880Action->execute( ).../front.php:34
70.155414583032call_user_func_array:{/home/pancer/sites/pancer.com.ua/system/storage/modification/system/engine/action.php:51} ( ).../action.php:51
80.155414583664ControllerProductBestseller->index( ).../action.php:51
90.155714585184getTotalBestSellers ( ).../bestseller.php:17
100.155714585624Proxy->__call( ).../bestseller.php:17
110.155714586848call_user_func_array:{/home/pancer/sites/pancer.com.ua/system/engine/proxy.php:25} ( ).../proxy.php:25
120.155714588208Loader->{closure:/home/pancer/sites/pancer.com.ua/system/storage/modification/system/engine/loader.php:147-191}( ).../proxy.php:25
130.156614590288call_user_func_array:{/home/pancer/sites/pancer.com.ua/system/storage/modification/system/engine/loader.php:178} ( ).../loader.php:178
140.156614590968ModelModuleAdditionalPages->getTotalBestSellers( ).../loader.php:178
150.158214593728DB->query( ).../additional_pages.php:232
160.158214593864DB\MySQLi->query( ).../db.php:16