Just another Cross-Sell mod (support thread)

By the way this is the query Im trying to run. We use 1.3.7 and Mysql 5.0.45. The query is straight from the read me file.

Thanks again.


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 ('', '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_PRODUC TS','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''),');

I think i may have found the answer in post #53 of this thread:
I need to run the patch through the admin. Ill try that now.


Thanks

It worked... my bad. Had to use the admin > tools > install patch tool

Thanks for letting me talk my way through this. Hope it helps someone else.

makenoiz

Quote:

---

Originally Posted by makenoiz

It worked... my bad. Had to use the admin > tools > install patch tool

Thanks for letting me talk my way through this. Hope it helps someone else.

makenoiz

---

I believe that the readme stated clearly that you have to use Zencart admin sql patch tool to run the script ^^.

Hi all,

I have installed the Cross Sell mod with no problem. When I tried to upgrade to Just another Cross-Sell mod I get this error when submitting the SQL statements via zen-cart.

Code:

---

1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'Cross Sell', 'Set Cross Sell Options', '1', '1');]
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.

---

Any idea of where to track this one down? Thank you.

I am getting this message after installing the mod, does anyone recommend this error or possibly know what I am doing wrong.

Warning: main(includes/modules/FILENAME_CART_UPSELL.php) [function.main]: failed to open stream: No such file or directory in /homepages/2/d208592347/htdocs/shop/includes/templates/template_default/templates/tpl_shopping_cart_default.php on line 232

Fatal error: main() [function.require]: Failed opening required 'includes/modules/FILENAME_CART_UPSELL.php' (include_path='.:/usr/local/lib/php') in /homepages/2/d208592347/htdocs/shop/includes/templates/template_default/templates/tpl_shopping_cart_default.php on line 232

It appears that you did not upload all the files to the correct folders. If you are using a custom template. there are several folders in the zip file that you need to rename before uploading.

Hi again,

When I am in the advanced X-Sell admin page and I click edit next to a product under Current Cross-Sells, I get the following error.

Code:

---

1054 Unknown column 'SSC' in 'where clause'
in:
[select p.products_id from products p where p.products_id = 01-SSC-5381 LIMIT 1]
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.

---

Did a table not get created properly when installing the "just another X-Sell mod"

Thank you for any help or guidance.

In configuration->Cross sell choose:
Input type to be used in form -> model

See if that fixes the problem.

Ok, well I think I may have a bigger issue.

I do not have a Cross Sell option under configuration.

Under Catalog I have two options, Cross Sell Products and Advanced Cross-Sell. Perhaps I will start over at square one with the Cross Sell mod again.

Thank you