1064 SQL Syntax Error for Column Product Listing.. HELP!!!

[mooki]

Hi I'm having problems after upload the add on to change my product listings layout from rows to columns..

All my product listings other than all products have this 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 '-0, 0' at line 7
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '22' order by p.products_sort_order, pd.products_name limit -0, 0]

I'm using zen cart 1.3.8, tried reinstalling 3 times.. bud it worked on my previous template well.. I tried removing all the folder and did reinstall.. same error came out..

Could someone help me with this?

[swguy]

Please don't double post.

Follow up to http://www.zen-cart.com/forum/showth...427#post921427