Syntax Error

[Guest]

Good Day

 

I have installed both OS Commerce standard and the modded verision CRE i think it is and on both i get an error in many parts of the admin section as follows :

 

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 o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -10, 10

 

If anyone can help me sort this problem it will be much appreiciated.

 

NOTE The error message starts the same but the secound paragraph is slightly diffrent depending on what part of the admin section you go to/

 

Regards,

Jason C

[Guest]

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