ikhan42 Posted July 18, 2005 Share Posted July 18, 2005 Hello all, I am running OSC on a Linux ES4 server and seem to have most of it working but am getting some errors in parts of the admin section. For example is I try and go into the catalog manufacturers section I get the following error 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 manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -20, 20 [TEP STOP] Similar error in review section Reviews Products Rating Date Added Action 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] The specials section and the product expected section. I am able to add new categories and products though everything in the configuration section works and all other sections seem to fuction okay as well juts the SQL errors that I have mentioned in the above sections any one got any suggestions as I have tried everthing and have now also rebuilt the server a few times deleted and recreated the DB etc. Thanks for your help in advance ikhan42 Link to comment Share on other sites More sharing options...
ikhan42 Posted July 18, 2005 Author Share Posted July 18, 2005 Dont worry I worked it out guys Hello all, I am running OSC on a Linux ES4 server and seem to have most of it working but am getting some errors in parts of the admin section. For example is I try and go into the catalog manufacturers section I get the following error 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 manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -20, 20 [TEP STOP] Similar error in review section Reviews Products Rating Date Added Action 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] The specials section and the product expected section. I am able to add new categories and products though everything in the configuration section works and all other sections seem to fuction okay as well juts the SQL errors that I have mentioned in the above sections any one got any suggestions as I have tried everthing and have now also rebuilt the server a few times deleted and recreated the DB etc. Thanks for your help in advance ikhan42 <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
♥yesudo Posted July 18, 2005 Share Posted July 18, 2005 Always good to post the solution for others. http://blogs.oscommerce.com/yesudo/index.p...owentry&eid=306 Your online success is Paramount. 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.