Multi Cross Sell mod [Support thread]

[rufusclc]

Hi -
using Zen-1.5.0 and the latest version of this program, installed -in catalog I see Multi Cross Sell Admin v1.03;
and in configuration I see the Cross Sell Settings on my site in2paper.com
However, when I add the merged codes into my products_info_display.php in my custom templates, the product page does not show and I get the following error:
[17-Nov-2012 18:48:57] PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/in2paper/public_html/i2padmin/includes/functions/extra_functions/reg_multi_xsell.php:41) in /home/in2paper/public_html/includes/functions/sessions.php on line 113
[17-Nov-2012 18:48:57] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/in2paper/public_html/i2padmin/includes/functions/extra_functions/reg_multi_xsell.php:41) in /home/in2paper/public_html/i2padmin/includes/init_includes/init_templates.php on line 28
BUT
when I use the sample product_info_display.php it works!! But I would like to use mine as I have made several changes to the display etc.
Any help interpreting the error code - I have NOT a clue what it means, to be honest.....
Kindest regards
Rufus

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