( ! ) 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.0000234384{main}( ).../index.php:0
20.0006370432start( ).../index.php:24
30.0006372552require_once( '/var/www/vhosts/forherandforhim.com/www/httpdocs/system/framework.php' ).../startup.php:104
40.0068496152Router->dispatch( ).../framework.php:168
50.1074813456Router->execute( ).../router.php:56
60.1074813456Action->execute( ).../router.php:67
70.1075817720call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/action.php:79} ( ).../action.php:79
80.1075818104ControllerStartupRouter->index( ).../action.php:79
90.1078829264Action->execute( ).../router.php:25
100.1078834976call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/action.php:79} ( ).../action.php:79
110.1078838920ControllerProductCategory->index( ).../action.php:79
120.12231195184ControllerProductCategory->getProducts( ).../category.php:233
130.13571237616getTotalReviewsByProductId ( ).../category.php:940
140.13571237968Proxy->__call( ).../category.php:940
150.13571239104call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/proxy.php:47} ( ).../proxy.php:47
160.13571240264Loader->{closure:/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/loader.php:220-262}( ).../proxy.php:47
170.13601242032call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/loader.php:248} ( ).../loader.php:248
180.13601242520ModelCatalogReview->getTotalReviewsByProductId( ).../loader.php:248
190.13631243584DB->query( ).../review.php:116
200.13631243584DB\MySQLi->query( ).../db.php:45