I need help. When someone searching for a product that is not available in the online store shows this error:
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 ps.customer_group_id = '1' AND (ps.date_start = '0000-00-00' OR ps.date_st' at line 1<br />Error No: 1064<br />SELECT product_id, date_end FROM oc_product_special ps WHERE () AND ps.customer_group_id = '1' AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end > NOW() ORDER BY ps.priority ASC, ps.price ASC;' in /home/domain/public_html/mywebsite/system/library/db/mysqli.php:40 Stack trace: #0 /home/domain/public_html/mywebsite/system/library/db.php(16): DB\MySQLi->query('SELECT product_...', Array) #1 /home/domain/public_html/mywebsite/catalog/model/extension/module/neat_countdown.php(18): DB->query('SELECT product_...') #2 [internal function]: ModelExtensionModuleNeatCountdown->getSpecials(Array) #3 /home/domain/public_html/mywebsite/vqmod/vqcache/vq2-system_storage_modification_system_engine_l in /home/domain/public_html/mywebsite/system/library/db/mysqli.php on line 40
Тhanks in advance.
/mywebsite/catalog/model/extension/module/neat_countdown.php(18)
you better ask the Contributor of this Neat Countdown Extension about this!
Ernie
you better ask the Contributor of this Neat Countdown Extension about this!
Ernie
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
@IP_CAM
Thank you. Here was the problem.
Thank you. Here was the problem.
https://luxurychess.eu/ | https://awgwatergenerator.com/ | https://wpwebsite.biz/
Who is online
Users browsing this forum: No registered users and 2 guests