MySQL error 1064 deleting last record

[Guest]

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.

 

TIA

[241]

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