"1064 - You have an error in your SQL syntax;

[Guest]

When I go to my account information as a customer and click on Overview (show all orders) a error occurs,

 

"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.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by orders_id DESC limit -10, 10

 

[TEP STOP]

 

Any ideas? My provider think its a bug in OsCommerce

[Jack_mcs]

Download the latest oscommerce version and find the fix in the update file for spit_page_results. The error will go away with that fix applied.

 

Jack