Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1064 - Error in your SQL syntax


Recommended Posts

Upon having two example customers in oscommerce with subscribed Newsletter, the option Newsletter Manager does not show correctly. I receive the following error:

Newsletter Manager 


Newsletters Size Module Sent Status Action 

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

Is there a contribution that can help me out, or do I have to see in my configuration.php if theres anything wrong?


Usually this error comes up when no data is available to handle, but seing as both customers are subsribed I dont understand.

Link to comment
Share on other sites

  • 4 weeks later...


This topic is now archived and is closed to further replies.

  • Create New...