Printable View
ok, it's also giving me THIS error when I go to my store homepage.
Clearly, there's a database error. Any suggestions here? This is just crazy...Quote:
Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.
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!
Ok, I deleted the new "module_manager" and installed the old one "module_manager_rev16zip".Quote:
Originally Posted by mkonchalski
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?
Quote:
Originally Posted by konsument
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:
Pay attention to this line:Code: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\'),');
INSERT INTO configuration_group VALUES ('', '43',...
Look for the language_id on your system to adjust. Perhaps you don't use 43...
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?:frusty:
Here is the a link to one of the products. http://www.etondiffusion.fr/librairi..._with_audio_cd
Have you entered this line of code in your template tpl_product_info_display.php file:
Best entered near the bottom of the file.Code:<?php
require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');
?>
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?Quote:
Originally Posted by parisbubbler
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.
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.Quote:
Originally Posted by parisbubbler
Posted via Mobile Device