I've just installed this on a 1.3.9h store. It replaced the Advanced Cross-Sell mod in the old 1.3.8a store which I am upgrading. I renamed the products_xsell table to products_xsell1. In the admin, everything looks great, I can see all the cross-sells. However, on the product page that the customer sees, I get this error:
Any ideas on what could be causing this?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 products_xsell1 xp, products p, products_description pd where xp.products_id = '474' 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 ]
Thanks!


Reply With Quote
