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 ') a LIMIT 10' at line 1
Error No: 1064
SELECT DISTINCT * FROM ( ( SELECT DISTINCT r.*, pd.name, p.price, p.image FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p2s.store_id = '0' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' AND p2c.category_id != '110' ORDER BY date_added DESC LIMIT 10 ) UNION ALL ) a LIMIT 10' in /home/n/navysote/navysote.beget.tech/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/n/navysote/navysote.beget.tech/public_html/system/library/db.php(16): DB\MySQLi->query(' SELECT DISTINC...', Array) #1 /home/n/navysote/navysote.beget.tech/public_html/catalog/model/extension/module/uni_reviews.php(79): DB->query(' SELECT DISTINC...') #2 /home/n/navysote/navysote.beget.tech/public_html/catalog/model/extension/module/uni_reviews.php(32): ModelExtensionModuleUniReviews->getReviews('10', 110, false) #3 [internal function]: ModelExtensionModuleUniReviews->getLatestReviews('10', 110) #4 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/loader.php(178): call_user_func_array(Array, Array) #5 [internal function]: Loader->{closure}(Array, Array) #6 /home/n/navysote/navysote.beget.tech/public_html/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array) #7 /home/n/navysote/navysote.beget.tech/public_html/catalog/controller/extension/module/uni_reviews.php(28): Proxy->__call('getLatestReview...', Array) #8 /home/n/navysote/navysote.beget.tech/public_html/catalog/controller/extension/module/uni_reviews.php(28): Proxy->getLatestReviews('10', 110) #9 [internal function]: ControllerExtensionModuleUniReviews->index(Array) #10 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/action.php(51): call_user_func_array(Array, Array) #11 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/loader.php(24): Action->execute(Object(Registry), Array) #12 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/catalog/controller/common/content_bottom.php(72): Loader->controller('extension/modul...', Array) #13 [internal function]: ControllerCommonContentBottom->index(Array) #14 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/action.php(51): call_user_func_array(Array, Array) #15 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/loader.php(24): Action->execute(Object(Registry), Array) #16 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/catalog/controller/product/category.php(640): Loader->controller('common/content_...') #17 [internal function]: ControllerProductCategory->index() #18 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/action.php(51): call_user_func_array(Array, Array) #19 /home/n/navysote/navysote.beget.tech/public_html/system/engine/front.php(34): Action->execute(Object(Registry)) #20 /home/n/navysote/navysote.beget.tech/public_html/system/engine/front.php(29): Front->execute(Object(Action)) #21 /home/n/navysote/navysote.beget.tech/public_html/system/framework.php(103): Front->dispatch(Object(Action), Object(Action)) #22 /home/n/navysote/navysote.beget.tech/public_html/system/startup.php(126): require_once('/home/n/navysot...') #23 /home/n/navysote/navysote.beget.tech/public_html/index.php(19): start('catalog') #24 {main} thrown in /home/n/navysote/navysote.beget.tech/public_html/system/library/db/mysqli.php on line 40