Warning: mysqli::query(): (42000/1064): 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 ') GROUP BY p.product_id ORDER BY p.sort_order ASC, pd.name' at line 1 in /home/customer/www/bsbroadcast.com/public_html/system/library/db/mysqli.php on line 25
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 ') GROUP BY p.product_id ORDER BY p.sort_order ASC, pd.name' at line 1<br />Error No: 1064<br />SELECT p.product_id, p.sort_order FROM oc_product p 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) WHERE TRUE AND p.date_available <= NOW() AND p2s.store_id = 0 AND pd.language_id = 1 AND p.status = 1 AND () GROUP BY p.product_id ORDER BY p.sort_order ASC, pd.name in /home/customer/www/bsbroadcast.com/public_html/system/library/db/mysqli.php:49 Stack trace: #0 /home/customer/www/bsbroadcast.com/bsbstorage/modification/system/library/db.php(55): DB\MySQLi->query('SELECT p.produc...') #1 /home/customer/www/bsbroadcast.com/public_html/catalog/model/extension/module/smartsearch.php(791): DB->query('SELECT p.produc...') #2 /home/customer/www/bsbroadcast.com/public_html/catalog/model/extension/module/smartsearch.php(579): ModelExtensionModuleSmartsearch->runQuery(1, 'SELECT p.produc...') #3 /home/customer/www/bsbroadcast.com/bsbstorage/modification/system/engine/loader.php(256): ModelExtensionModuleSmartsearch->smartsearch(Array) #4 /home/customer/www/bsbroadcast.com/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array) #5 /home/customer/www/bsbroadcast.com/bsbstorage/modification/catalog/controller/product/search.php(291): Proxy->__call('smartsearch', Array) #6 /home/customer/www/bsbroadcast.com/bsbstorage/modification/system/engine/action.php(79): ControllerProductSearch->index() #7 /home/customer/www/bsbroadcast.com/bsbstorage/modification/system/engine/router.php(134): Action->execute(Object(Registry)) #8 /home/customer/www/bsbroadcast.com/bsbstorage/modification/system/engine/router.php(123): Router->execute(Object(Action)) #9 /home/customer/www/bsbroadcast.com/public_html/system/framework.php(169): Router->dispatch(Object(Action), Object(Action)) #10 /home/customer/www/bsbroadcast.com/public_html/system/startup.php(104): require_once('/home/customer/...') #11 /home/customer/www/bsbroadcast.com/public_html/index.php(19): start('catalog') #12 {main} thrown in /home/customer/www/bsbroadcast.com/public_html/system/library/db/mysqli.php on line 49