Fatal error: Uncaught 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 ') 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 != '132' 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', 132, false) #3 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/loader.php(178): ModelExtensionModuleUniReviews->getLatestReviews('10', 132) #4 /home/n/navysote/navysote.beget.tech/public_html/system/engine/proxy.php(25): Loader->{closure}(Array, Array) #5 /home/n/navysote/navysote.beget.tech/public_html/catalog/controller/extension/module/uni_reviews.php(28): Proxy->__call('getLatestReview...', Array) #6 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/action.php(51): ControllerExtensionModuleUniReviews->index(Array) #7 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/loader.php(24): Action->execute(Object(Registry), Array) #8 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/catalog/controller/common/content_bottom.php(72): Loader->controller('extension/modul...', Array) #9 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/action.php(51): ControllerCommonContentBottom->index(Array) #10 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/loader.php(24): Action->execute(Object(Registry), Array) #11 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/catalog/controller/product/product.php(755): Loader->controller('common/content_...') #12 /home/n/navysote/navysote.beget.tech/public_html/system/storage/modification/system/engine/action.php(51): ControllerProductProduct->index() #13 /home/n/navysote/navysote.beget.tech/public_html/system/engine/front.php(34): Action->execute(Object(Registry)) #14 /home/n/navysote/navysote.beget.tech/public_html/system/engine/front.php(29): Front->execute(Object(Action)) #15 /home/n/navysote/navysote.beget.tech/public_html/system/framework.php(103): Front->dispatch(Object(Action), Object(Action)) #16 /home/n/navysote/navysote.beget.tech/public_html/system/startup.php(126): require_once('/home/n/navysot...') #17 /home/n/navysote/navysote.beget.tech/public_html/index.php(19): start('catalog') #18 {main} thrown in /home/n/navysote/navysote.beget.tech/public_html/system/library/db/mysqli.php on line 40