special categories contribution

[sinryder]

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

[sinryder]

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 ??