1064 - You have an error in your SQL syntax

[Guest]

Hello,

 

when I login in to admin. it shows below error:

 

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 = '4' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20

 

could anyone help me with this error? thanks!!

 

Rose

[Guest]

http://www.oscommerce.com/community/bugs,1605

fix at the end of the page