Cross sell sql error

[bean_2k1]

i cant seem to install the sql patch i have tryed uploading in via the admin control panel and i can the following error

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



in the admin section it says to run the sql update via the zc_install folder but i havent got a clue how to do that,

Any ideas on how to fix this problem ?

[dbrewster]

This is from the cross-sell SQL for ZC version 1.3.x, which I use on my website.

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());

What version of cross sell are you using? Check the downloads section and get the most recent one.

If you are apply SQL patches from inside ZC admin, you do NOT want the table prefix "zen_"! That gets applied automatically, it's a global setting for your database.

You cannot use the ZC installer to install add-on modules, AFAIK.

---Diana

[Scarlet]

I get the same error - have the latest version. Anyone ever get this resolved?

[trudesign]

Me too, don't know what to do. I have done the research on the forums etc, and can't seem to find the answer.

[arcdigital]

Just add the file, and ignore that sql error. The addon will work fine. (it worked for me) and I got that error

[Scarlet]

I copied and pasted each SQL statement/group of statements separately into the box on top of the file upload in the admin and it worked fine.

[godspeed27]

The part of the sql statement that is doing this is:

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());

Trying to get the fix now. Anyone else know the fix yet?

[godspeed27]

As this says for upgraders...if you are not upgrading do we need this, b/c this is the only part that fails

## For upgraders, you may want to add the additional index for marginal speed improvements:
# ALTER TABLE products_xsell ADD INDEX idx_products_id_xsell (products_id);
# 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());