Quote Originally Posted by sgflowers View Post
Hi i am working on add ing this contrib (0.5 beta)

to a zencart 1.3.7 site and i receive this error on product_info

[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 'MAX_DISPLAY_XSELL' at line 8
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '3782' 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 MAX_DISPLAY_XSELL]

i allready had cross sell running before i added the

tpl_product_info_display.php file but it seems to be erroring out
looks like the advanced cross sell addon removed some of the cross sell configuration that this looks at - all is good as far as this now