SQL Error Please help!

[manu_sag]

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

Hello everybody, I hope I can find some directions and help...
This is a new ZC 1.5 install. and I have installed the Multi Cross sell Module last month. everything was working properly until this morning the product info page does not display and give me an error! I checked the debug log and this is what I got:



[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



Nothing was changed on this file or the tables! Any help with this will be greatly appreciated!
The last thing I did before this problem was a backup yesterday for the site and the database. for the database I used the Database backup manager tool
Thanks in advance

[RodG]

Check
/includes/modules/CUSTOM/xsell_products.php

Line #15 (or thereabouts) should read:
if (!defined('MAX_DISPLAY_XSELL')) define('MAX_DISPLAY_XSELL',6);

I suspect this entire file isn't in the /CUSTOM/ folder (or it is in the folder, but the installation is using the /classic/ folder instead.

Also check that /includes/extra_datafiles/xsell_definitions.php is OK too.

Cheers
Rod