PartsTrader Posted June 6, 2013 Share Posted June 6, 2013 Hello, When I tried to add a $10 discount on a few items, it added the discount to all of my items and I'm not able to remove the discount. When I select the "Catalog Price Rules" tab is says: Bad SQL query 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 'from desc LIMIT 0,50' at line 14. I am currently using version 1.5.4.0. If anyone has any input on this I would appreciate it. Thank you. Link to comment Share on other sites More sharing options...
PartsTrader Posted June 6, 2013 Author Share Posted June 6, 2013 I managed to delete the $10 price decrease to every product entered, I changed this information in the database. The catalog price rule tab is still showing the Bad SQL query error but I'll probably never use it again so I am not too worried about it. Current products are being added without any additional discounts. On a side note, this option should be under Products > Prices or at lease have a separate tab for specials. Link to comment Share on other sites More sharing options...
chess king Posted June 14, 2013 Share Posted June 14, 2013 Hi All You Prestashop Experts I am getting this message: Catalog Price Rules > Bad SQL query 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 'to asc LIMIT 0,50' at line 14. I am using Prestashop V 1.5.4.1, and offering a 10% Discount on my products. Please help me fix this problem permanently. Thanks Chess Princess Link to comment Share on other sites More sharing options...
Recommended Posts