Interesting error - can anyone help

[Guest]

Recently I started getting this error when accessing the Newsletter Manager, can anyone point me in the right direction?

 

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]

 

 

Thanks,

 

Shaun

[AlanR]

It's a well known bug, see this post:

 

http://www.oscommerce.com/forums/index.php?sho...53entry654653