Jump to content

Catalog Price Rules Not Able to Remove Discount Bad SQL query


Recommended Posts

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

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

  • 2 weeks later...

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

×
×
  • Create New...