Printable View
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.
You can go to Tools in admin, then Developers Toolkit and type those words in "Look Up...." (or similar in 1.3.9)Quote:
Originally Posted by deziner76hd
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 questionsQuote:
Originally Posted by mcpisik
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 291Quote:
Originally Posted by michaelchu
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:
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:Code:WARNING: An Error occurred, please refresh the page and try again.
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:Code:[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
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.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-->
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 291Quote:
Originally Posted by 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.Quote:
Originally Posted by sports guy
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 :(