alex188 Posted December 22, 2005 Share Posted December 22, 2005 Hello After installation , when i try to add some product to "Specials" , is show me some 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 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] Is the sime error thet i see in "Products Expected" but when i mark some product as "Out of Stock" , the error disappear. What can i do with the "Specials" ? Link to comment Share on other sites More sharing options...
kgt Posted December 22, 2005 Share Posted December 22, 2005 Read the last comment: http://www.oscommerce.com/community/bugs,1605 Contributions Discount Coupon Codes Donations 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.