Multi Cross Sell mod [Support thread]

Ajeh:

Are you running Zen Cart v1.5.0? :lookaroun

Yes, I am.

Go to your Zen Cart Admin to the Tools ... Developers Tool Kit ... and do a search in the bottom input box on:

and select Admin from the dropdown and click SEARCH ...

Does anything come up?

Hi...I installed a fresh install on my Zen cart and I am getting this 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
in:
[CREATE TABLE IF NOT EXISTS zen_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.

I did look for the configuration_key MAX_DISPLAY_SELLX suggested in post 31 but there in nothing in my database.

Any ideas? Thanks for your help!!! :)

amandavz:

Hi...I installed a fresh install on my Zen cart and I am getting this 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
in:
[CREATE TABLE IF NOT EXISTS zen_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.

I did look for the configuration_key MAX_DISPLAY_SELLX suggested in post 31 but there in nothing in my database.

Any ideas? Thanks for your help!!! :)Bug.. You need to apply a bug fix shown in post 291

BEAUTIFUL!!! Works like a dream. Thanks so much!!! :)

Nope...I was wrong...I'm not seeing the tables for the cross sell in the admin panel? Nor do I have an Advanced Cross Sell. Am I missing something?

Okay...I am sorry to be a pain, but I have searched the forum and am not seeing my problem being addressed. The install went well, I have the Admin>Configuration>Cross Sell Settings set, but when I go to Admin>Catalog>Multi Cross Sell it gives me a drop down box with my 1 cross sell a "Go" button and the "Remove" button, but no tables in which to enter data (product id's). This was a fresh install on 1.3.9h with no other previous cross sells installed.

Thanks so much for your help. :)

Got it...I installed an older version and it worked just fine. Thanks for your help. :)

Just read through all 348 posts and hope I didn't miss my problem.
All installed and working for Cross Sell 1, with heading etc.
Have then added 'Number of Cross Sellls' to 2, which worked.
However after choosing products to cross sell (appears to add them ok with confirmation), the "We also Suggest" heading doesn't show and neither do the products from that cross sell group. Though they are listed as cross sells in admin.

I do note that under Cross Sell Settings, the 'Selected Cross Sell to edit' only gives a 1 check box and can't be changed to 2 (missing the 2 box)

Any idea? Thanks and awesome mod. Well done on your hard work :)

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

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.

deziner76hd:

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

mcpisik:

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

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

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.

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

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?

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:

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

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!

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

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 :(