( ! ) 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.0000234304{main}( ).../index.php:0
20.0006370344start( ).../index.php:24
30.0006372464require_once( '/var/www/vhosts/forherandforhim.com/www/httpdocs/system/framework.php' ).../startup.php:104
40.0072496024Router->dispatch( ).../framework.php:168
50.0758813328Router->execute( ).../router.php:56
60.0758813328Action->execute( ).../router.php:67
70.0759817592call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/action.php:79} ( ).../action.php:79
80.0759817976ControllerStartupRouter->index( ).../action.php:79
90.0762829144Action->execute( ).../router.php:25
100.0763834856call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/action.php:79} ( ).../action.php:79
110.0763838800ControllerProductCategory->index( ).../action.php:79
120.09271195216ControllerProductCategory->getProducts( ).../category.php:233
130.10451237688getTotalReviewsByProductId ( ).../category.php:940
140.10451238040Proxy->__call( ).../category.php:940
150.10451239176call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/proxy.php:47} ( ).../proxy.php:47
160.10451240336Loader->{closure:/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/loader.php:220-262}( ).../proxy.php:47
170.10471242104call_user_func_array:{/var/www/vhosts/forherandforhim.com/www/httpdocs/system/engine/loader.php:248} ( ).../loader.php:248
180.10471242592ModelCatalogReview->getTotalReviewsByProductId( ).../loader.php:248
190.10501243656DB->query( ).../review.php:116
200.10501243656DB\MySQLi->query( ).../db.php:45