Multi Cross Sell Module

[Lazar]

Hi,

I installed Multi Cross Sell Module and it works fine. I've got recommended products but the title of the box "We recommend" is not shown. I haven't got a clue why. Here are how my files look like:

tpl_product_info_display.php
<!-- BEG: Multi Cross-Sell mod -->
<?php
// THIS CODE WOULD BE ADDED INTO YOUR TPL_PRODUCT_INFO_DISPLAY.PHP WHEREVER YOU WANT TO DISPLAY ALL THE CROSS_SELL BOXES:
if(defined('MXSELL_ENABLED') && MXSELL_ENABLED == 'true') {
for ( $mxsell = 1; $mxsell <= MXSELL_NUM_OF_TABLES; $mxsell++ ) { // show all cross sells
require($template->get_template_dir('tpl_modules_multi_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_multi_xsell_products.php');
}
}
?>
<!-- END: Multi Cross-Sell mod -->

2. product_info.php

define('TEXT_MULTI_XSELL_PRODUCTS', 'We Also Recommend:');

Here is the link: http://demo-shop.infocom.co.me/

Thnx.

[Lazar]

I got the error mistake displayed at the every product page:

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 zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '2' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '3' and p.products_status = 1 order by xp.sort_order asc limit ]

Any idea about this?

[gilby]

2. product_info.php

define('TEXT_MULTI_XSELL_PRODUCTS', 'We Also Recommend:');

Here is the link: http://demo-shop.infocom.co.me/

Thnx.

You must be "mixing" your mods"
This mod doesn't use the file "product_info.php" at all?

Also it doesn't use this define either
define('TEXT_MULTI_XSELL_PRODUCTS', 'We Also Recommend:');
Thats from another mod.

The language defines required are in
\includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defi nes.php
and have a "number" in them
Such as:
define('TEXT_MXSELL1_PRODUCTS', 'Suggested Matching Items...');
define('TEXT_MXSELL2_PRODUCTS', 'We also Suggest...');
define('TEXT_MXSELL3_PRODUCTS', 'Suggested Cross Sell 3...');

If you want this mod to work correctly
You need to "uninstall" any previous cross sell mods
and remove all of their files first.

[gilby]

I got the error mistake displayed at the every product page:

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 zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '2' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '3' and p.products_status = 1 order by xp.sort_order asc limit ]

Any idea about this?

Hi Lazar
The key problem is at the very end.
There is a limit statement with nothing after it.
You need to have a number here. eg: limit 6

The support thread is here:
http://www.zen-cart.com/forum/showthread.php?t=158571
Your problem is the same or similar to post #3 and the answer is in post #31

[Lazar]

I am assuming you had a previous cross sell installed??
Almost certainly some of the previous mods configuration values are still there.

Search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And delete this entry.

While you at it see if "MIN_DISPLAY_XSELL" is also there and delete it as well

Can you explain me how to delete this entry in admin?

[gilby]

Can you explain me how to delete this entry in admin?

Can't do it in admin

You need to use a system tool on your website account.
Something like phpmyadmin

[Lazar]

Do I need to have a look at Structure tab in phpmyadmine? I can't find MAX_DISPLAY_XSELL key there. I've found the next two entries:
products_xsell and products_xsell1.

[gilby]

Do I need to have a look at Structure tab in phpmyadmine? I can't find MAX_DISPLAY_XSELL key there. I've found the next two entries:
products_xsell and products_xsell1.

"products_xsell" and "products_xsell1" are database tables
They are not keys.

You need to look in the "configuration" table
to find the "keys" that need to be removed

Click on the "configuration" table
go to the end of the table
Check for the key MAX_DISPLAY_XSELL and MIN_DISPLAY_XSELL
Stepping backwards thru this table
When found delete them

[Lazar]

Done!
Thank you mate. You're great!

Lazar