error message on Product Purchased

[aryo1]

Best Products Purchased

 

No. Products Purchased

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 '-20, 20' at line 1

 

select p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20

 

--------------------------------------

There is another error message or Review:

 

Reviews

 

Products Rating Date Added Action

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 '-20, 20' at line 1

 

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20

 

 

Does anybody know what is going on?

[milauskas]

I too am getting the same error in one of my osCommerce stores. Oddly, this just started happening. Previously, orders were received okay.

 

Now when someone submits an order, I get no notification email (only a paypal email is received--nothing from osC).