1064 - You have an error in your SQL syntax

I am getting the following error in my OS Commerce program when I try to view a customers order in the admin/orders ares:

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, [url removed, login to view], o.currency_value, s.orders_status_name, [url removed, login to view] 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 = '9' and o.orders_status = s.orders_status_id and s.language_id = '1' and [url removed, login to view] = 'ot_total' order by orders_id DESC limit -20, 20

I received payment confirmation from this person, but did not receive the order confirmation from my OS Commerce install, so I know the amount of their order but not what they ordered. What would it cost to fix this problem?

Færdigheder: PHP

Se mere: line problem, cost problem, amount received, sql server admin, on sql, error 0, you, syntax, sql mysql, sql c, mysql error, error, error php, desc, php sql syntax error, 1064 php, admin error, payment error, sql syntax error, php mysql 1064, sql select order, sql select, text sql, mysql sql syntax, sql problem

Om arbejdsgiveren:
( 8 bedømmelser ) Clearwater Beach, United States

Projekt-ID: #79745