Guest Posted January 4, 2007 Share Posted January 4, 2007 hi i installed oscommerce , and everything is going very well but.... in admin when i click on banner manager i recived this error: 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 the same in newsletter manager.... 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 all other modules and the shopping works fine.. i had MySQL 4.1.21-standard what have i to do? thanks Link to comment Share on other sites More sharing options...
jtp03 Posted January 5, 2007 Share Posted January 5, 2007 I get the exact same error when I click any of the following from the admin section: Manufacturers Reviews Specials Products Expected I have no clue why! I've checked the database and everything looks fine. Don't know what else to do. ALSO, in the database, I see several tables related to coupons but I don't have that as an option in my admin section. Is there a way to turn on the coupons feature?? Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2007 Share Posted January 7, 2007 no one can help me? :( Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.