Just another Cross-Sell mod (support thread)

[eyal8r]

ok, it's also giving me THIS error when I go to my store homepage.

Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

Clearly, there's a database error. Any suggestions here? This is just crazy...

[eyal8r]

ok, I got it. My db login got changed when I created a new one... man, I'm losing my mind with all this! Looks like I got my shop back now- I think... one thing's for sure, I'm not TOUCHING this Cross-Sell Mod again!

[Pink]

Install Module Manager Rev. 1.6 That has the yclass that everyone is looking for.

Ok, I deleted the new "module_manager" and installed the old one "module_manager_rev16zip".

Then I installed "cross_sell__just_another_cross_sell_mod_rev186".

Now the admin comes up without error (yclass).

Going to "admin->tools->module manager->list all modules" I get: "1 ri_jaxs 0 Revision 185 update"

Going to "admin->tools->module manager->install new modules" I get: "Found and attempted to install 0 new modules".

Going to "admin->catalog->advanced cross sell" I get the "Advanced Cross-Sell (X-Sell) Admin". But I still didn't manage to edit some cross-sells. I guess, the problem is here:

Going to "admin->configuration" I do not get any "Cross-Sell" to configure.

Any hints what's wrong?

[Pink]

Hi all,

im using Zen Cart Ver. 1.3.8.

after installing the module the Cross-Sell config link is missin in Admin->configuration->cross sell

I also get this error if I try tu run sql patch in admin:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_configuration_group VALUES ('', 'Cross Sell', 'Set Cross Sell Options', '1', '1');] 

Could anybody please help me?

Hm, I think I got it. You have the same problem I had. We both use a multilingual zen-cart. The SQL gets error because of the lack of the language_id in the statement.

As I do use german (in my case id 43) in my shop, I had to adjust the sql. So, this is the whole statement, that I had to run in admin to get the admin->configuration->cross sell:

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;

INSERT INTO configuration_group VALUES ('', '43','Cross Sell', 'Set Cross Sell Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

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


UPDATE configuration SET configuration_group_id = @t4 WHERE configuration_key IN ('MIN_DISPLAY_XSELL','MAX_DISPLAY_XSELL','SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS','XSELL_DISPLAY_PRICE');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Input type to be used in form', 'XSELL_FORM_INPUT_TYPE', 'model', 'Choose to use product ID or MODEL as your input type. Check readme file for more info', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'XSell Product Input Separator', 'XSELL_PRODUCT_INPUT_SEPARATOR', ',', 'You will need to insert all product id/model you want to cross-sell in 1 field, so each product id/model needs to be separated by a separator. The default is comma, choose another if you want to', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'XSell Sort Order', 'XSELL_SORT_ORDER', 'sort_order', 'Sometimes you may want to display the xsell products randomly, especially if each product xsells with lots of others', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'sort_order\', \'random\'),');

Pay attention to this line:
INSERT INTO configuration_group VALUES ('', '43',...
Look for the language_id on your system to adjust. Perhaps you don't use 43...

[parisbubbler]

I have installed the MOD, and added some Cross Sell items.

The MOD appeared fine in the "Module Manager."

"Cross Sell" configuration settings work fine in the Configuration menu; and

The "Advanced Cross Sell" module seemed to work fine in the "Catalog" menu. I entered items, and received positive confirmation of the entries. I can even return to the Module and edit the cross sell items.

My problem is that the items are not showing up on the product pages.

I have followed the instructions by step, using the 'book product info'. Where am I going wrong?

Here is the a link to one of the products. http://www.etondiffusion.fr/librairi..._with_audio_cd

[DVDTitan]

Have you entered this line of code in your template tpl_product_info_display.php file:

<?php
      require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');
?>

Best entered near the bottom of the file.

[parisbubbler]

Yes, all of the instructions were followed. I've checked and rechecked, but can't seem to find the problem

[Shane78]

Yes, all of the instructions were followed. I've checked and rechecked, but can't seem to find the problem

Is there a conflict with another add-on/mod?
the first time i used this mod i had a problem because i had not followed the instructions for module manager to the letter, then something else i installed after rewrote the product info page where you insert that code.

[parisbubbler]

Posted via Mobile Device

[parisbubbler]

Posted via Mobile Device

I'm using the books info page, have rewritten any thing but keep coming up with the same problem. I'm using module manager version 1.16 updated last year.
Posted via Mobile Device