Jump to content

ERROR 1064 in oscommerce shopping cart


novelty

Recommended Posts

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

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 8 months later...

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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.