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 '-12, 12'

[jameelbaaz]

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 '-12, 12' 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 -12, 12

[Avec]

Search Here

 

Here was the first result

 

1064 Error

[user99999999]

This error is from MySQL not allowing negative numbers in the limit. (limit -1)

 

http://www.oscommerce.com/ext/update-20051...l#_Toc119693704

 

You should apply all the fixes in this update at the above link.