SQL Error in Admin :(

[garyeqm]

Hi all,

 

In my admin panel, when I click on reports I get

 

Best Viewed Products

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, pd.products_name, pd.products_viewed, l.name from products p, products_description pd, languages l where p.products_id = pd.products_id and l.languages_id = pd.language_id order by pd.products_viewed DESC limit -20, 20

 

[TEP STOP]

 

I probably wont use reports in this case, BUT, any error in SQL needs to be accounted for!

 

I hope you can help!

 

Thanks

 

Gary

[♥stubbsy]

the answer to your problem is here (hopefully) :)

 

http://www.oscommerce.com/forums/index.php?showtopic=144095