mysticaleast Posted April 9, 2005 Posted April 9, 2005 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.
mysticaleast Posted April 9, 2005 Author Posted April 9, 2005 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.