Guest Posted July 1, 2005 Share Posted July 1, 2005 When I click on the "Specials" tab inside the Admin area, I receive this error message: 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 I found information on the 1064 error in the Contributions area, and I tried it--but the contribution did not seem to help in this particular event. Can anyone help? Link to comment Share on other sites More sharing options...
Wendy James Posted July 1, 2005 Share Posted July 1, 2005 http://www.oscommerce.com/forums/index.php?sho...=144095&hl=1064 Wendy James Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep. Link to comment Share on other sites More sharing options...
Guest Posted July 1, 2005 Share Posted July 1, 2005 Thank you, Wendy! That fix-it worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.