Cross Sell SQL Error

[TurtleDove]

I'm trying to upload the products_xsell.sql file via Admin->Tools->Install SQL Patch, but keep getting this 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.

How would I fix this?

[ms paperlicious]

Did you happen to figure this out? I'm getting the same error.

Please let me know!

Thanks so much-
Amy

[TurtleDove]

No, unfortunately, I have not. I am going to leave this contribution off of my Zencart until someone can help me out.

[thegroovyfox]

Im getting exactly the same error, can anyone please please help.....

Thanks,

Craig.

[a_berezin]

Don't upload sql-patch. Use copy/paste!!!!

[thegroovyfox]

Andrew....

Thank you very much, working perfectly as far as I can tell !!

[ms paperlicious]

I tried that too and it seems to work! Yee ha!

thanks!

amy

[georgeau88]

Don't upload sql-patch. Use copy/paste!!!!

Hi Andrew,

I have the same error. But as a beginner, I don't know how to copy/paste!

Thanks:george