sinryder Posted September 30, 2006 Share Posted September 30, 2006 hey guys i just installed this contribution "Category special" http://www.oscommerce.com/community/contri...als+by+Category and getting this error on admin side Special Categories Category Product(s) Category Discount Status 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 '-30, 30' at line 3 select A.special_id, A.categ_id, A.discount, A.discount_type, A.status, B.categories_name, A.special_date_added, A.special_last_modified, A.expire_date, A.date_status_change from special_category A, categories_description B where A.categ_id = B.categories_id and B.language_id = '1' order by B.categories_name limit -30, 30 [TEP STOP] can any one please help me fix this thankx Quote Link to comment Share on other sites More sharing options...
sinryder Posted October 2, 2006 Author Share Posted October 2, 2006 hey guys i just installed this contribution "Category special" http://www.oscommerce.com/community/contri...als+by+Category and getting this error on admin side Special Categories Category Product(s) Category Discount Status 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 '-30, 30' at line 3 select A.special_id, A.categ_id, A.discount, A.discount_type, A.status, B.categories_name, A.special_date_added, A.special_last_modified, A.expire_date, A.date_status_change from special_category A, categories_description B where A.categ_id = B.categories_id and B.language_id = '1' order by B.categories_name limit -30, 30 [TEP STOP] can any one please help me fix this thankx any one ?? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.