Multi Cross Sell mod [Support thread]

[deziner76hd]

Hello,
I am using ZenCart 1.3.9h and version 1.00 cross sell I had to use an older version of cross sell as the newer version for 1.3.9 (Version: v1.02) just gave a blank screen with no tables in the admin. My question is Where can I change the wording in the header "Suggested Matching Items..."
By the way Thank you for this great mod. It does exactly what I needed it to do.

[mcpisik]

Hello,
Where can I change the wording in the header "Suggested Matching Items..."

You can go to Tools in admin, then Developers Toolkit and type those words in "Look Up...." (or similar in 1.3.9)
That will give you the location of that text.
It is here though: /includes/languages/english/extra_definitions/YOUR THEME/multi_xsell_box_defines.php

[deziner76hd]

You can go to Tools in admin, then Developers Toolkit and type those words in "Look Up...." (or similar in 1.3.9)
That will give you the location of that text.
It is here though: /includes/languages/english/extra_definitions/YOUR THEME/multi_xsell_box_defines.php

Thank you for your quick response. I need to start using the tools more before asking questions

[michaelchu]

ZC v1.3.9.h

I must be an idiot, I downloaded the Multi Xsell v1.02 for ZC 1.3.9h and followed the install instructions line by line. There were no other versions installed before. When I click install from Admin>Catalog>Multi Cross Sell here is what I got.

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 'TYPE=MyISAM' at line 7
in:
[CREATE TABLE IF NOT EXISTS products_xsell1 ( `ID` int(10) NOT NULL auto_increment, `products_id` int(10) unsigned NOT NULL default '1', `xsell_id` int(10) unsigned NOT NULL default '1', `sort_order` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`ID`), KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

After searching through this thread I do see similar type of errors but not the same syntax, any help is greatly appreciated.

Mike

[gilby]

ZC v1.3.9.h

I must be an idiot, I downloaded the Multi Xsell v1.02 for ZC 1.3.9h and followed the install instructions line by line. There were no other versions installed before. When I click install from Admin>Catalog>Multi Cross Sell here is what I got.

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 'TYPE=MyISAM' at line 7
in:
[CREATE TABLE IF NOT EXISTS products_xsell1 ( `ID` int(10) NOT NULL auto_increment, `products_id` int(10) unsigned NOT NULL default '1', `xsell_id` int(10) unsigned NOT NULL default '1', `sort_order` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`ID`), KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

After searching through this thread I do see similar type of errors but not the same syntax, any help is greatly appreciated.

Mike

Bug.. You need to apply a bug fix shown in post 291

[sports guy]

I am not able to install the Multi Cross Sell module properly. After I have uploaded all the files, and go to: Admin> Catalog> Multi Cross Sell> I see the install button. When I click install my admin page goes blank (no template) and this message shows:

WARNING: An Error occurred, please refresh the page and try again.

Also the Admin->Configuration->Cross Sell Settings tables have not been created. It's obvious to me that it is not installing the tables. When I went to my error logs I have this message:

[04-Dec-2012 08:07:49] PHP Fatal 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 'TYPE=MyISAM' at line 7 :: CREATE TABLE IF NOT EXISTS products_xsell1 (
    `ID` int(10) NOT NULL auto_increment,
    `products_id` int(10) unsigned NOT NULL default '1',
    `xsell_id` int(10) unsigned NOT NULL default '1',
    `sort_order` int(10) unsigned NOT NULL default '1',
    PRIMARY KEY  (`ID`), 
    KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM in /MyRoot/store/includes/classes/db/mysql/query_factory.php on line 120

I do not believe I have installed any other cross sell module, but this store installation is the third migration. So it's possible I have some very old definitions in my database (if I had installed a cross sell many years back). And in my template file (tpl_product_info_display.php) I see this code:

<!--bof also purchased products module-->
<?php require($template->get_template_dir('tpl_modules_also_purchased_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_also_purchased_products.php');?>
<!--eof also purchased products module-->

so it's possible my template came with this (although I never installed it myself). I believe this template code should not affect installation to begin with. At least that is my best guess.

Last I have re-uploaded multiple times to make sure I have all the files in the correct place. I am fairly sure I did not miss any files being uploaded.

Suggestions?

[gilby]

I am not able to install the Multi Cross Sell module properly. After I have uploaded all the files, and go to: Admin> Catalog> Multi Cross Sell> I see the install button. When I click install my admin page goes blank (no template) and this message shows:

WARNING: An Error occurred, please refresh the page and try again.

Also the Admin->Configuration->Cross Sell Settings tables have not been created. It's obvious to me that it is not installing the tables. When I went to my error logs I have this message:

[04-Dec-2012 08:07:49] PHP Fatal 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 'TYPE=MyISAM' at line 7 :: CREATE TABLE IF NOT EXISTS products_xsell1 (
    `ID` int(10) NOT NULL auto_increment,
    `products_id` int(10) unsigned NOT NULL default '1',
    `xsell_id` int(10) unsigned NOT NULL default '1',
    `sort_order` int(10) unsigned NOT NULL default '1',
    PRIMARY KEY  (`ID`), 
    KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM in /MyRoot/store/includes/classes/db/mysql/query_factory.php on line 120

I do not believe I have installed any other cross sell module, but this store installation is the third migration. So it's possible I have some very old definitions in my database (if I had installed a cross sell many years back). And in my template file (tpl_product_info_display.php) I see this code:

<!--bof also purchased products module-->
<?php require($template->get_template_dir('tpl_modules_also_purchased_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_also_purchased_products.php');?>
<!--eof also purchased products module-->

so it's possible my template came with this (although I never installed it myself). I believe this template code should not affect installation to begin with. At least that is my best guess.

Last I have re-uploaded multiple times to make sure I have all the files in the correct place. I am fairly sure I did not miss any files being uploaded.

Suggestions?

Bug.. You need to apply a bug fix shown in post 291

[sports guy]

Gilby, perfect! That was the issue and it installed properly now. FYI, I did search this thread but did not look at every page (after around page 10 and a few searches I glaze over). Also, I just downloaded and installed this version directly from the Plugins area, so I am guessing this plugin needs updated to include this change. Thank you for your help!

[gilby]

Gilby, perfect! That was the issue and it installed properly now. FYI, I did search this thread but did not look at every page (after around page 10 and a few searches I glaze over). Also, I just downloaded and installed this version directly from the Plugins area, so I am guessing this plugin needs updated to include this change. Thank you for your help!

No Problems, glad its working.
Yes it does need updating to change this, and a couple of other small bugs that can appear with newer versions of mysql.
When I get some free time!

btw: It was also answered on the post directly before your original post.

[nesum18]

I go to the Catalog > Multi Cross Sell
When I click on 'Install' I get the following message: WARNING: An Error occurred, please refresh the page and try again.

Can anyone help me please