Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Screwed up banner manager


mysticaleast

Recommended Posts

Posted

Hi guys,

 

Ive just started playing with osCommerce, and was following some instructions in the Tips and Tricks section under the thread labelled Basics for design.

 

Well all I did was go to tools->banner manager and removed the item in the list. I got an error saying the images directory wasnt writeable, so I fixed that. Since then this is all I get:

 

Banner 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 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

 

What should I do to fix this? It was working before I deleted that entry, but surely the table hasn't been deleted? Has it?

 

Thanks in advance for your help.

Posted

If anyone's interested, I have this problem in the newsletter manager as well.

 

There is a bug report here that gives a fix.

 

Havent tried it yet but it sounds logical so im confident.

Archived

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

×
×
  • Create New...