Quote Originally Posted by Lazar View Post
I got the error mistake displayed at the every product page:

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 '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '2' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '3' and p.products_status = 1 order by xp.sort_order asc limit ]

Any idea about this?
Hi Lazar
The key problem is at the very end.
There is a limit statement with nothing after it.
You need to have a number here. eg: limit 6

The support thread is here:
http://www.zen-cart.com/forum/showthread.php?t=158571
Your problem is the same or similar to post #3 and the answer is in post #31