Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 - Error in your SQL syntax


burtoni

Recommended Posts

Posted

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.

  • 4 weeks later...

Archived

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

×
×
  • Create New...