novelty Posted October 2, 2005 Share Posted October 2, 2005 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 Quote Link to comment Share on other sites More sharing options...
neylitalo Posted October 2, 2005 Share Posted October 2, 2005 the LIMIT clause is messed up... 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? Quote Link to comment Share on other sites More sharing options...
novelty Posted October 4, 2005 Author Share Posted October 4, 2005 The purpose of the query is in a shopping cart environment called oscommerce. It is in the admin area to allow input of "Specials" for products that are listed on our website (to discount items). our website: http://ngnovelties.com . I am getting the same error for the function "Manufacturers" and "Reports" which are queries to list any manufacturers of the products and to see "customer orders", etc.... I will try to change the query string to a '0' (zero) instead of -20. This is in the php script page right?.. Not the MySQL database. (I am new to using MySQL). Thanks for the input.. I will report the outcome here. Quote Link to comment Share on other sites More sharing options...
Advancewebsoft Posted June 22, 2006 Share Posted June 22, 2006 Hello, 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 23, 2006 Share Posted June 23, 2006 Yeah, support for negative limits was dropped a while back... the refman has more details, but you should definitely get your hands on newer code, especially if you're paying for it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.