Multi Cross Sell mod [Support thread]

[gilby]

Hello there,

It has 6 as default. I tried to change it and the other settings and it still has the error. I have 2 cross sells defined so far. Is there anything else I could try? Should I drop the sql tables and star from scratch maybe? Maybe something got scrambled on our setup during install.

Did you have any previous cross sells installed?
or is this a new installation?

You could uninstall from the admin and install again.
It won't remove the tables

What php version are you using?

[HeathenMagic]

I had cross sell installed from before and I tried uninstalling and reinstalling this module and the same happened. Had the normal cross sell and cross sell advanced. I am on PHP 5 too.

[jetx]

Great mod, thanks.

[Nineve]

I have installed the files and got it to work in the admin panel, but items I have set to cross sell do not display the other product on the product pages. I am assuming when you go to the "A Bug's Life" page after the additional images there should be a photo of the "Microsoft IntelliMouse", but there is nothing. So not sure what I did wrong.

Here is the screen shot in the admin panel showing I have a bugs life and a mouse linked to cross sell;



Here is where I put the code for templates/premium2a/templates/tpl_product_info_display.php


I'm on v1.3.9d, PHP 5.3.2, no other version of a cross sell mod.

[Nineve]

I figured it out, I'm sorry.
This file had not transfered over.
includes/modules/premium2a/multi_xsell_products.php


works great now!!!!
Thank you so much for the hard work.

[andreitero]

Hello, I'm looking to install this mod on one of my websites. Before i do, i would like to know if it is compatible with Tabbed products pro last version. Has anyone tried this combination so far?
Thanks!

[gilby]

Hello, I'm looking to install this mod on one of my websites. Before i do, i would like to know if it is compatible with Tabbed products pro last version. Has anyone tried this combination so far?
Thanks!

I don't use "Tabbed products pro" so I don't know
You would need to compare both mods directory structure to find any duplicate files.
These duplicate files would then need to be "merged"

[HeathenMagic]

Hello Gilby,

Thanks so much for your assistance, it worked a treat. I cleared the files from the last version and ran the sql statement you quoted and it did it. Where can people send a donation to you?

[andreitero]

I don't use "Tabbed products pro" so I don't know
You would need to compare both mods directory structure to find any duplicate files.
These duplicate files would then need to be "merged"

Thanks for that, i did install this contribution, but got an error:
1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL' doesn't exist in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL xp, zen_products p, zen_products_description pd where xp.products_id = '90' 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 6]

Double checked the Cross Sell 1 - Display Products - Max, it has value '6' . What else should i look at to fix it?

Also, in order to get it to work with Tabbed products pro, i would need to change this bit to match multi_cross_sell database table instead of xsell table. I am unsure about the changes i should make, can you please give me some advice?

				$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
									 from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
									 where xp.products_id = '" . $_GET['products_id'] . "'
									  and xp.xsell_id = p.products_id
									  and p.products_id = pd.products_id
									  and pd.language_id = '" . $_SESSION['languages_id'] . "'
									  and p.products_status = 1
									 order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL);

[nolsowski]

I am looking through my error log in my Cpanel and I came across this error.

Tue Jan 18 11:17:09 2011] [error] [client 188.165.234.114] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant 11 in /home/fromprop/public_html/includes/modules/alysa_rounded/multi_xsell_products.php on line 43

I re downloaded the module and opened that multi_xsell_products.php and the one I have in Winmerge and I got a message saying that it's identical.

I don't understand what this error message is telling me.

Thanks!