Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

MySQL error 1064 deleting last record


Recommended Posts

I have just finished installing osCommerce v2.2MS2 on a Windows XP machine running IIS 5.1. The version of PHP is 4.4.0 for Win32, MySQL version (from mysql.exe) is 4.1.14.


As soon as I delete the last record in a set I get:

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


The SQL query that follows differs depending on where I get the error, but the one common factor has been deleting the final order/customer/manufacturer/whatever else, that I get the error. The -20.20 refers to the 'DESC limit '-20,20' at the end of the query.


I am not 100% sure where to log this, and being completely useless at php I cannot determine what I need to change for this to work.



Link to comment
Share on other sites

this is a known and fixed bug due to newer versions of mysql.


The -20,20 is part of the split page result and it is to this that the fix needs to be applied.


The bug report can be viewed here http://www.oscommerce.com/community/bugs,1605


further reading is this http://www.oscommerce.com/forums/index.php?aut...ogid=42&eid=362

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...