Newsletter!?, ERROR: 1064 - You have an error in your SQL...

[calle]

In Admin I get this error message everytime I enter something I have not entered anything. When clicking on Newsletter:


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]


For example if I have no delivered orders I get the errror message. Then after "delivering" one order everything works fine. The mysql doesn't seem to be able to handle the fact that there are no info, i.e. no delivered orders.

How do I change this? Now I can't send any newsletters...

[michael_s]

see this:

http://oscdox.com/modules.php?op=mod...ename=SQLError

[calle]

Thanks!!