I am relatively new to ZenCart (v. 1.3.9b), but that hasn't stopped me from customizing and making changes to code here and there. However, I wanted to fix the fact that disabled products were showing up in the New Products boxes, and I did something horribly wrong.
Instead of New Products, Featured products, etc.. I get this error message:
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 ')' at line 7
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p.products_date_added, p.products_price, p.products_type, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 and p.products_id in ()]
See it here: http://spartanpools.com/
I've tried replacing both New_Products.php and Featured_Products.php with original files, but I may have done something elsewhere in a fugue state of coding. Shame on me. Please help!
Bookmarks