( ! ) 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 ') AND r.`status` = 1' at line 1<br />Error No: 1064<br />SELECT r.review_id, rr.id_value AS product_id FROM oc_review r, oc_review_relevance rr WHERE r.review_id = rr.review_id AND rr.id_name = 'product_id' AND rr.id_value IN () AND r.`status` = 1' in /var/www/vhosts/forherandforhim.com/www/httpdocs/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 ') AND r.`status` = 1' at line 1<br />Error No: 1064<br />SELECT r.review_id, rr.id_value AS product_id FROM oc_review r, oc_review_relevance rr WHERE r.review_id = rr.review_id AND rr.id_name = 'product_id' AND rr.id_value IN () AND r.`status` = 1 in /var/www/vhosts/forherandforhim.com/www/httpdocs/system/library/db/mysqli.php on line 40
Call Stack
#TimeMemoryFunctionLocation
10.0000234320{main}( ).../index.php:0
20.0007370344start( ).../index.php:24
30.0007372464require_once( '/var/www/vhosts/forherandforhim.com/www/httpdocs/system/framework.php' ).../startup.php:104
40.0065496040Router->dispatch( ).../framework.php:168
50.1227813296Router->execute( ).../router.php:56
60.1227813296Action->execute( ).../router.php:67
70.1228817560call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/action.php:79} ( ).../action.php:79
80.1228817944ControllerStartupRouter->index( ).../action.php:79
90.1231829104Action->execute( ).../router.php:25
100.1231834816call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/action.php:79} ( ).../action.php:79
110.1231838760ControllerProductCategory->index( ).../action.php:79
120.13971195136ControllerProductCategory->getProducts( ).../category.php:233
130.15031237608getTotalReviewsByProductId ( ).../category.php:940
140.15031237960Proxy->__call( ).../category.php:940
150.15031239096call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/proxy.php:47} ( ).../proxy.php:47
160.15031240256Loader->{closure:/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/loader.php:220-262}( ).../proxy.php:47
170.15051242024call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/loader.php:248} ( ).../loader.php:248
180.15051242512ModelCatalogReview->getTotalReviewsByProductId( ).../loader.php:248
190.15081243576DB->query( ).../review.php:116
200.15081243576DB\MySQLi->query( ).../db.php:45