Just another Cross-Sell mod (support thread)

[makenoiz]

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

[makenoiz]

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

[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

[yellow1912]

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

[TheMusician]

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.

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.

[techy-sult.com]

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

[yellow1912]

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.

[TheMusician]

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.

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.

[yellow1912]

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

See if that fixes the problem.

[TheMusician]

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