Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Screwed up banner manager


Recommended Posts

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.

Link to comment
Share on other sites


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

  • Create New...