After installing this mod, when I go to view my products I receive 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 'ASC limit 0, 99' at line 1
select p.products_sort_order, p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_sort_order, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c 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 = '8' order by p.products_sort_order asc ASC limit 0, 99
[TEP STOP]
I've searched through this forum and can't seem to find an answer for where things went wrong. Initially I had some trouble getting the product_sort.sql to run properly, but managed to get it to work thanks to daveboyce's suggestion. I'm no programmer by any means, but I'm usually able to work my way through most problems I've caused for myself. Any ideas as to why I'm receiving this error and what to do about it?
Thanks!