admin/newsletters error

[iessence]

"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 newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

[TEP STOP]"

 

 

Please, how do I fix it??

[spiritalan]

"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 newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

[TEP STOP]"

Please, how do I fix it??

 

This seems to be a very common problem which probably stems from MySQL updates which you or a hostserver may upgrade. I have had this particular problem and fixed it today.

 

This is the place I went to find a fix:

http://www.oscommerce.com/community/bugs,1605

 

Scroll down to: 29 Sep 2005 19:21:49

This is called "the official fix." I used this one.

 

Good Luck,

Alan