Description:
I am using a program called oscommerce (http://oscommerce.com) as a shopping
cart, but am receiving the following error for several areas of the script (in
the admin functions area) such as 'Specials', 'Manufacturers', (under the
heading 'Catalog') and ('orders' under the heading 'Customers'). I cannot find
the problem with the SQL DB. Can anyone assist?
The error code:
=========================================
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.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
-20, 20
[TEP STOP]
=========================================
*** This particular error code came when I pressed the 'ORDERS' link under
'CUSTOMERS'.
Thanks,
Cash Pawley