Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    6
    Plugin Contributions
    0

    Default 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?ma...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!

  2. #2
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default 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());
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

 

 

Similar Threads

  1. Trouble Installing
    By KevinN in forum Installing on a Windows Server
    Replies: 1
    Last Post: 24 Feb 2011, 06:16 PM
  2. Trouble installing 1.3.9h
    By black68gtx in forum General Questions
    Replies: 1
    Last Post: 21 Jan 2011, 07:20 PM
  3. trouble installing 2checkout
    By pamcake in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 3 Aug 2007, 10:43 PM
  4. Trouble installing
    By Scrapp & lapp in forum Installing on a Windows Server
    Replies: 3
    Last Post: 11 Sep 2006, 07:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg