ZC 1.5 new install
MySQL 5.0.45
PHP 5.2.12
www.bestdealcaraudio.com


Hi I am getting an error and the product info page doesn't display and it looks like it has something to do with the Multi Cross Sell Mod! Any idea what this may be I looked at the subject file and I don't see anything changed it was working fine before!
Any help or advice will be greatly appreciated
Thanks in advance



[31-Mar-2012 09:33:37] PHP Fatal error: 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 :: select distinct p.products_id, p.products_image, pd.products_name
from TABLE_PRODUCTS_XSELL xp, products p, products_description pd
where xp.products_id = '137'
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 in bestdealcaraudio/includes/classes/db/mysql/query_factory.php on line 101