Zen Cart Logo
Forums / General Questions / Trouble installing cross_sell

Trouble installing cross_sell

Locked

Views: 801

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
5 Sep 2007, 12:58 PM
#1
briancricketrakita avatar

briancricketrakita

New Zenner

Join Date:
Sep 2007
Posts:
6
Plugin Contributions:
0

Trouble installing cross_sell

Okay, I'm new to Zen Cart and I need to install Cross Sell. I'm running 1.3.7 As I read, I first need to install the original cross sell, which I believe is at http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_60&products_id=76 I think, but that is only updated for 1.3.0

So anyhow, when i followed the instructions, I went to Admin->Tools->Install SQL Patch, hit brows, found products_xsell.sql, hit upload, and I got a page that says

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.

Am I skipping something, or doing something wrong? I think I backed everything up properly, so at least I don't think I did anything un-doable. Any help would be appreciated!

5 Sep 2007, 1:18 PM
#2
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Trouble installing cross_sell

Try to run it from phpMyAdmin if you have, just copy the queries there, BUT:
If you use a prefix for zen tables (i.e: zen_) you have to manually insert it like this:

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