( ! ) Fatal error: Uncaught exception 'Exception' with message 'Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and p.product_id <> 230 and quantity > 0 and status = 1 and image is not null OR' at line 1<br />Error No: 1064<br />SELECT p.product_id FROM oc_product as p JOIN oc_product_to_category as pc on p.product_id = pc.product_id WHERE category_id = and p.product_id <> 230 and quantity > 0 and status = 1 and image is not null ORDER BY viewed DESC LIMIT 0, 8' in /var/www/www-root/data/www/new/system/library/db/mysqli.php on line 45
( ! ) Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and p.product_id <> 230 and quantity > 0 and status = 1 and image is not null OR' at line 1<br />Error No: 1064<br />SELECT p.product_id FROM oc_product as p JOIN oc_product_to_category as pc on p.product_id = pc.product_id WHERE category_id = and p.product_id <> 230 and quantity > 0 and status = 1 and image is not null ORDER BY viewed DESC LIMIT 0, 8 in /var/www/www-root/data/www/new/system/library/db/mysqli.php on line 45
Call Stack
#TimeMemoryFunctionLocation
10.0001231576{main}( ).../index.php:0
20.0052348768start( ).../index.php:32
30.0052350568require_once( '/var/www/www-root/data/www/new/system/framework.php' ).../startup.php:160
40.0104505192Front->dispatch( ).../framework.php:111
50.04136475024Front->execute( ).../front.php:34
60.04136475024Action->execute( ).../front.php:39
70.04156479376call_user_func_array:{/var/www/www-root/data/www/new/system/storage/modification/system/engine/action.php:56} ( ).../action.php:56
80.04156479760ControllerStartupRouter->index( ).../action.php:56
90.04196480648Action->execute( ).../router.php:30
100.04206486848call_user_func_array:{/var/www/www-root/data/www/new/system/storage/modification/system/engine/action.php:56} ( ).../action.php:56
110.04206493664ControllerProductProduct->index( ).../action.php:56
120.07126658232getPopularProductsForCategory ( ).../product.php:507
130.07126658672Proxy->__call( ).../product.php:507
140.07126659896call_user_func_array:{/var/www/www-root/data/www/new/system/engine/proxy.php:30} ( ).../proxy.php:30
150.07126661280Loader->{closure:/var/www/www-root/data/www/new/system/storage/modification/system/engine/loader.php:152-196}( ).../proxy.php:30
160.07166663016call_user_func_array:{/var/www/www-root/data/www/new/system/storage/modification/system/engine/loader.php:183} ( ).../loader.php:183
170.07166663536ModelCatalogProduct->getPopularProductsForCategory( ).../loader.php:183
180.07166664320DB->query( ).../product.php:663
190.07166664456DB\MySQLi->query( ).../db.php:23