error message in admin

[carpenoctem]

when i click on specials, reviews, etc....

 

i get an error in all three similar to

 

 

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 pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20

 

 

i have no idea where to begin..... maybe somebody else has experienced it???

[Guest]

check if you have this fix installed

 

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

 

(entry 12 May 2005 13:01:05)