Just another Cross-Sell mod (support thread)

[yellow1912]

New version:

https://svn.rubikintegration.com/zen...sell_advanced/

[phil99]

Thanks but it doesnt fix it... its a problem with the SQL file and my version on sql on the server?

Still get :

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.

when i try to run the sql patch in admin?

Rather frustrating!

[yellow1912]

Are you sure you get the new sql file?

It should look like this:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Cross-Sell Products', 'MIN_DISPLAY_XSELL', 1, 'This is the minimum number of configured Cross-Sell products required in order to cause the Cross Sell information to be displayed.<br />Default: 1', 2, 17, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Cross-Sell Products', 'MAX_DISPLAY_XSELL', 6, 'This is the maximum number of configured Cross-Sell products to be displayed.<br />Default: 6', 3, 66, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell Products Columns per Row', 'SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS', '3', 'Cross-Sell Products Columns to display per Row<br />0= off or set the sort order.<br />Default: 3', 18, 72, 'zen_cfg_select_option(array(0, 1, 2, 3, 4), ', now());
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?<br />Default: false', 18, 72, 'zen_cfg_select_option(array(\'true\',\'false\'), ', now());

[phil99]

Im running :

MySQL 4.1.22-standard if that helps?

[phil99]

Yes I have that exact code in the sql patch and it throws that error...

thanks for your help by the way.

[yellow1912]

Interesting, try to replace:

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?<br />Default: false', 18, 72, 'zen_cfg_select_option(array(\'true\',\'false\'), ', now());

by

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?<br />Default: false', 18, 72, 'zen_cfg_select_option(array(''true'',''false''), ', now());

[phil99]

Bingo! that fixed it many thanks.... now then what upgrades over what i have does your new version have?

Thanks so much for the help

[yellow1912]

Please read the readme file for more info:

https://svn.rubikintegration.com/zen...ced/readme.txt

[yellow1912]

Sorry, I dont support adding products using the original xsell. It's NOT my mod, and I dont use it as well.

[marksu]

Hi
I just added the mode and I can add the cross links in admin pages.
My problem is that I don't see any cross product products on product pages.

My settings are:

Input type to be used in form model
Display Cross-Sell Products 1
Display Cross-Sell Products 6
Cross-Sell Products Columns per Row 1
Cross-Sell - Display prices? false

I could not eather find any reference to cross products in Layout Boxes Controller.

marksu