( ! ) 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.0001234368{main}( ).../index.php:0
20.0014370392start( ).../index.php:24
30.0014372512require_once( '/var/www/vhosts/forherandforhim.com/www/httpdocs/system/framework.php' ).../startup.php:104
40.0111496088Router->dispatch( ).../framework.php:168
50.2447813352Router->execute( ).../router.php:56
60.2447813352Action->execute( ).../router.php:67
70.2448817616call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/action.php:79} ( ).../action.php:79
80.2448818000ControllerStartupRouter->index( ).../action.php:79
90.2452829168Action->execute( ).../router.php:25
100.2453834880call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/action.php:79} ( ).../action.php:79
110.2453838824ControllerProductCategory->index( ).../action.php:79
120.26321195272ControllerProductCategory->getProducts( ).../category.php:233
130.27541237752getTotalReviewsByProductId ( ).../category.php:940
140.27541238104Proxy->__call( ).../category.php:940
150.27541239240call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/proxy.php:47} ( ).../proxy.php:47
160.27541240400Loader->{closure:/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/loader.php:220-262}( ).../proxy.php:47
170.27561242168call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/loader.php:248} ( ).../loader.php:248
180.27561242656ModelCatalogReview->getTotalReviewsByProductId( ).../loader.php:248
190.27591243720DB->query( ).../review.php:116
200.27591243720DB\MySQLi->query( ).../db.php:45