Quote Originally Posted by anworks View Post
Hello,

I also had a previous version of cross sell installed and I am getting the error.

Code:
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 = '66' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit ]
I have gone through all the posts and sugestions but have not been able to find any files from previous versions or anything in the database. Anyone have any ideas?

Same problem as in Post# 29
Answer is in Post# 31

You will need something like phpmyadmin to search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And then delete it.