ERROR 1064 in oscommerce shopping cart
Posted 02 October 2005 - 04:42 AM
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
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
*** This particular error code came when I pressed the 'ORDERS' link under
Posted 02 October 2005 - 04:45 AM
This query is trying to get 20 records, starting at the -20th record. That isn't going to work. The first number has to be >= 0.
what is the purpose of this query?
Posted 04 October 2005 - 05:23 AM
Posted 22 June 2006 - 03:06 PM
The error you have (a limit -x,x problem) is a bug in oscommerce store. Please find out that oscommerce
have released a new update in later 2005, so download it or read what have been updated. About this bug - you eventually will find a lot of information on how to fix this bug in official oscommerce forums.
Official site http://www.advancewebsoft.com
Oscommerce Solutions: http://www.advancewe...oscommerce.html
Posted 23 June 2006 - 07:33 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users