SQL patch should have nothing to do with template. Can you paste here the error you get?
Quote:
Originally Posted by TheMusician
Printable View
SQL patch should have nothing to do with template. Can you paste here the error you get?
Quote:
Originally Posted by 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...
Thank youCode: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\'),');
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.
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.
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?
Did you xsell any product on admin side?
Did you make the changes in the template file as instructed?
thanks, I forgot to add the code into tpl_product_info_display.php
all sorted, again great mod!
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?
Where did you download this mod?