Multi Cross Sell mod [Support thread]

[gilby]

any idea what files i should be looking at to figure this out??

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

[sgflowers]

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

Thanks that fixed it - it was driving me nuts!

[anworks]

Hello,

I also had a previous version of cross sell installed and I am getting the 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 '' 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 = '66' 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 ]

I have gone through all the posts and sugestions but have not been able to find any files from previous versions or anything in the database. Anyone have any ideas?

[gilby]

Hello,

I also had a previous version of cross sell installed and I am getting the 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 '' 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 = '66' 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 ]

I have gone through all the posts and sugestions but have not been able to find any files from previous versions or anything in the database. Anyone have any ideas?

Same problem as in Post# 29
Answer is in Post# 31

You will need something like phpmyadmin to search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And then delete it.

[gaffettape]

Hi gilby,

First of all great mod - I really like the new customisable features you have added

Just wondering if it is possible to make this compatible with the Tabbed Products Pro module ??

Cheers.

[gilby]

Hi gilby,

First of all great mod - I really like the new customisable features you have added

Just wondering if it is possible to make this compatible with the Tabbed Products Pro module ??

Cheers.

Earlier in this thread someone else tried a hard coded hack to display the first cross sell.
It probably works but makes using this mod pointless as it only uses features of the previous mod.

I am sure TPP can be altered to incorporate this mod.
But as I have never used that mod, it is not on my "to do" list at this time, Sorry

[Briann]

I'd just like to say:

THANK YOU!

for this awesome mod. After a problem with Just Another Cross Sell Mod (again) I tried this one, it's much better!

[Berserker]

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks

[gilby]

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks

Not an available option in the default mod
A quick search of zen functions found this function
zen_get_categories_name_from_product($product_id)
It looks useful
Give it the product id and back comes the name of the category

I haven't tried this but this could work

Edit
\includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
Around line 69 near the end of the line find this code segment

zen_products_lookup($xsell_query->fields['products_id'], 'products_model') 

and replace with

zen_get_categories_name_from_product($xsell_query->fields['products_id']) 

See if that works for you?

[gilby]

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks

I just tested the code in the previous post and it does work