Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Error in Newsletter Manager


marcirb

Recommended Posts

Posted

I have received the following error in the newsletter manager.

 

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]

 

 

Please help - sql & php are all still new to me and I am not sure where to start to look or edit whats wrong.

If you have any clue what this means can you give me step by step directions to fix it

THanks - I do feel like a real dummy sometimes

Posted

If you are getting that error then you are using an outdated version of osCommerce. Go to downloads at www.oscommerce.com and download the latest version of osCommerce 2.2 MS2.

 

Vger

Posted
If you are getting that error then you are using an outdated version of osCommerce. Go to downloads at www.oscommerce.com and download the latest version of osCommerce 2.2 MS2.

 

Vger

 

 

This is the version I installed: osCommerce 2.2 Milestone 2 Update 060817

which appears to be the latest one.

 

Can anyone help me with this - I did do a backup of mysql and imported - could this have something to do with it

Archived

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

×
×
  • Create New...