Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Newsletter Manager Error Msg


Guest

Recommended Posts

I get this error message when going to newsletter manager.

 

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

 

[TEP STOP]

 

 

I also get same for banner manager:

 

Banner Manager

 

Banners Groups Displays / Clicks 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 banners_id, banners_title, banners_image, banners_group, status, expires_date, expires_impressions, date_status_change, date_scheduled, date_added from banners order by banners_title, banners_group limit -20, 20

 

[TEP STOP]

 

 

 

 

Does anyone know how i can fix it.

 

Thanks,

 

Kirsten

Link to comment
Share on other sites

Hi,

 

I had the same problem (although I detected it when installing the discount coupon contribution). The formal solution is documented here: http://www.oscommerce.com/community/bugs,1605/. See the final entry dated 29 Sep 2005 19:21:49.

 

I applied the solution (caused by a newer version of MySQL) and I'm now back up and running.

 

I get this error message when going to newsletter manager.

 

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

 

[TEP STOP]

I also get same for banner manager:

 

Banner Manager

 

Banners Groups Displays / Clicks 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 banners_id, banners_title, banners_image, banners_group, status, expires_date, expires_impressions, date_status_change, date_scheduled, date_added from banners order by banners_title, banners_group limit -20, 20

 

[TEP STOP]

 

 

 

 

Does anyone know how i can fix it.

 

Thanks,

 

Kirsten

Link to comment
Share on other sites

Hi,

 

I had the same problem (although I detected it when installing the discount coupon contribution). The formal solution is documented here: http://www.oscommerce.com/community/bugs,1605/. See the final entry dated 29 Sep 2005 19:21:49.

 

I applied the solution (caused by a newer version of MySQL) and I'm now back up and running.

 

 

Thanks so much it worked yay! :P

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...