Multi Cross Sell mod [Support thread]

[HeathenMagic]

I was just wondering if it is my setup, but I see this displayed on the product info 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 = '16025' 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 rand() limit ]

It all installed nicely in the admin and I followed the instructions. Thanks for developing this module also.

[gilby]

I was just wondering if it is my setup, but I see this displayed on the product info page:-

Quote:
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 = '16025' 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 rand() limit ]


It all installed nicely in the admin and I followed the instructions. Thanks for developing this module also.

Check:
admin->configuration->Cross Sell Settings
make sure that..
Cross Sell 1 - Display Products - Max
has a numeric value (not empty)

[HeathenMagic]

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.

[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.

[bovo_cn]

After several unsuccessful installation, I want to ask: there must be installed before installing multi_cross_sell_v1.00 module_manager not ah?
Since I installed multi_cross_sell_v1.00 including previously installed module_manager still can not display the Admin-> Catalog-> Advanced Cross-Sell
Dear brothers and sisters would help. I am using a host of bluehost.com: MySQL version 5.1.47. PHP Version 5.2.13

[gilby]

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.

I suspect you still have some of the previous mods files or configuration settings.

You can run this in the tools->sql patches to remove the previous mods configuration settings
after BACKING UP AND TESTING FIRST of course

  
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
  FROM configuration_group
  WHERE configuration_group_title= 'Cross Sell';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

Check that all the previous mods files have been removed

[sgflowers]

I suspect you still have some of the previous mods files or configuration settings.

You can run this in the tools->sql patches to remove the previous mods configuration settings
after BACKING UP AND TESTING FIRST of course

  
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
  FROM configuration_group
  WHERE configuration_group_title= 'Cross Sell';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

Check that all the previous mods files have been removed

hi i am having this issue

i updated from 1.3.7 to 1.3.9d with a fresh install on the files
i ran the above sql to remove the old cross sell but i still get an error

any ideas?

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 = '1852' 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 ]