1064 You have an error in your SQL syntax;

[alwaysanirudh]

I'm working on a eCommerce website. The Theme used is Bluewide.
From the backend I'm creating categories it is going fine.

When I'm adding a subcategory to the the category. It gives an error in the front-end even though the Subcategories are listed correct on the right hand sidebar.
This is the link to the page http://teleskyshopping.com/index.php...index&cPath=69

The error being:
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 'order by p.products_date_added DESC, pd.products_name LIMIT 120' at line 1
in:
[ order by p.products_date_added DESC, pd.products_name LIMIT 120]

[kobra]

Try scrolling down and checking the similar threads

[alwaysanirudh]

Try scrolling down and checking the similar threads

Thanks Kobra. I have done my research. But noting seems to solve the problem. 3 out of 6 categories are working fine. Now if any new category is added I face the same problem. If It had to happen it would have been the same for all categories.

[alwaysanirudh]

As far as my investigations the "pd.products_name LIMIT 120" is invalid but i'm not sure from where the query is being called. Please help.

[kobra]

Try your developers tool kit in your admin and search for

p.products_date_added or pd.products_name