Quote Originally Posted by DrByte View Post
I've no idea where the sudden interest in installing this mod came from, but in the last 3 days I've seen at least 3 people post the same issue about "an xsell mod" in various places around the forum ... and the mod has been available and actively installed since February.

Anyway, there's a small "bug" in the plugin code insomuch that one of the SQL statements is designed for MySQL4, and most servers are using MySQL5.

Make the following change to the code:
/YOUR_RENAMED_ADMIN/includes/functions/extra_functions/multi_xsell.php
Code:
    KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM");
becomes
Code:
    KEY `idx_products_id_xsell` (`products_id`) ) ENGINE=MyISAM");
You may need to "uninstall" and then re-"install" the module to get a properly usable installation.

I've never used this mod, so I can't comment on more than what I've found here by investigating a fix for this specific issue.
Thanks DrByte for replying. I installed this mod successfully following your instruction now but another issue has appeared.
When I choose the products that Cross sell applies to, I got the warning "No Product was Found with the id:..." These products definitely exist in the products catalog so I can't find out what is going on.

Many thanks.