Customer Orders Error

[Guest]

My site and shopping cart went live on the 1st March 2006, all tests worked fine up to the 1st March 2006.

 

The error I get is within the customer orders page in the osCommerce control panel.

 

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 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.customers_id = '2' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20

 

[\QUOTE]

 

When a customer places an order it goes through the process perfectly, but when the merchant looks at the order through osCommerce they see the above error message.

 

Because of the way PayPal processes the order there isn't any way, other than the order in osCommerce, of knowing what was ordered.

 

The merchant currently has three orders in this state and needs this error fixed quickly as they my lose orders because of it.

 

Thanks in advance

[kgt]

A search will do wonders:

 

http://www.google.com/search?hl=en&lr=&q=1...com&btnG=Search

 

Also see the last comment:

 

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

[Guest]

Thanks, problem solved