Admin Report syntax Error

[judoka]

Hi Everyone,
I am redesigning my website on my local machine using OSCMax 1.7. I am almost ready to uploaded it my live site and while setting up my admin. I notice the follow error message when I click on numerous sections in the admin. such as in the Report or tools section:

"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 '-10, 10' 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 -10, 10"

I try to figure this one out on my own but have had no success. Does any one know what this message means and how to fix it? As always any and all help would be appreciated.

Thanks,
Jose

[michael_s]

see http://oscdox.com/index.php?name=PNp...064+sql+syntax

[judoka]

Originally Posted by msasek

see http://oscdox.com/index.php?name=PNp...064+sql+syntax

Thanks Mike I believe that fix the problem.