Just another Cross-Sell mod (support thread)

[yellow1912]

SQL patch should have nothing to do with template. Can you paste here the error you get?

Hi,

The new version is looking real good. Nice work. I tried to upgrade my version on my live server, but got some errors on the sql update. I believe this is because I orginally installed the mod inside of a template I no longer use. Is the best course of action to do a fresh install using my current template folders?

Thank you,

[TheMusician]

1366 Incorrect integer value: '' for column 'configuration_id' at row 1
in:
[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);]
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.




SQL alpha2_rev64.sql...

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

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

Thank you

[yellow1912]

It looks like:
1. You have not installed the original XSell.
2. Or you have the Original XSell installed using a different name.

PM me your site info and I'll look into it for you.

[yellow1912]

If you use free download tool such as FlashGet you can choose to download a whole "folder". Zip file is a good idea and will come later.

[R-Lo]

Hi there, I have just installed the latest version of this from your site.
Admin works fine, but nothing shows up on my site.
I am running 1.3.8 with installed modules 'slimbox', 'column grid', and using cherry_zen template
any idea's?

[yellow1912]

Did you xsell any product on admin side?
Did you make the changes in the template file as instructed?

[R-Lo]

thanks, I forgot to add the code into tpl_product_info_display.php

all sorted, again great mod!

[phil99]

Ok i have installed cross sell and get the following error message when i upload the sql patch in admin:

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 'true','false'), ', now())' at line 1
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell - Display prices?', 'XSELL_DISPLAY_PRICE', 'false', 'Cross-Sell -- Do you want to display the product prices too?
Default: false', 18, 72, 'zen_cfg_select_option(array('true','false'), ', now());]
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.

I have searched this thread and tried someones fix further back but it didnt work for me.

Everything works fine I just dont get the option in admin to dispay the prices.

Any ideas?

[yellow1912]

Where did you download this mod?

[phil99]

here :

http://www.zen-cart.com/index.php?ma...products_id=76