SCC-Solutions Posted September 13, 2005 Share Posted September 13, 2005 Hello, I have recently installed OSCommerce and I am just doing some modifications to it. I have just deleted all the test products in the Specials section and now its has come up with: 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 Has anyone experienced this before and how do I fix it? Any help would be great Thanks Aaron Link to comment Share on other sites More sharing options...
Guest Posted September 13, 2005 Share Posted September 13, 2005 see this bug report http://www.oscommerce.com/community/bugs,1605 Link to comment Share on other sites More sharing options...
SCC-Solutions Posted September 13, 2005 Author Share Posted September 13, 2005 see this bug report http://www.oscommerce.com/community/bugs,1605 <{POST_SNAPBACK}> Great it fixed it perfectly. Thanks. I will also pass on my thanks to the chap who provided the solution. So helpful you all are and so quick at replying !!! :P 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.