zazoentje Posted March 13, 2007 Posted March 13, 2007 Hey guys, recently I installed oscommerce and I got those mistakes, anyone know how to solve this, cause i looks like its there cause there is no information to display. some help would be welcome greets Reviews 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 reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20 [TEP STOP] Specials 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 p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20 [TEP STOP] 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 [TEP STOP]
Tim.Ford Posted March 13, 2007 Posted March 13, 2007 zazoentje, what version of MySql are u running OSC on? Tim. Hey guys, recently I installed oscommerce and I got those mistakes, anyone know how to solve this, cause i looks like its there cause there is no information to display. some help would be welcome greets Reviews 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 reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20 [TEP STOP] Specials 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 p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20 [TEP STOP] 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 [TEP STOP]
djmonkey1 Posted March 13, 2007 Posted March 13, 2007 Hey guys, recently I installed oscommerce and I got those mistakes, anyone know how to solve this, cause i looks like its there cause there is no information to display. some help would be welcome greets Try this post: http://www.oscommerce.com/forums/index.php?sho...mp;#entry697026 Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread.
Guest Posted March 13, 2007 Posted March 13, 2007 you could also use the latest osc that has several fixes including the one mentioned http://www.oscommerce.com/solutions/downloads
zazoentje Posted April 16, 2007 Author Posted April 16, 2007 Thanks anyone, but i already solved the problem myself with some fixes, great
Recommended Posts
Archived
This topic is now archived and is closed to further replies.