Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    28
    Plugin Contributions
    0

    help question Cross Sell Install Trouble - SQL Error - help would be great!

    I'm running ZenCart 1.3.7 on godaddy.com hosting platform. Everything was going great until I tried installing Cross Sell.

    I've tried following the instructions in the readme file and when I go to upload the sql files attached with the install...I get 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."

    Any ideas?

    Do I need to install all files first before uploading/patching the sql file?

    Any help would be greatly appreciated...

    Thanks,
    Steve

  2. #2
    Join Date
    Nov 2007
    Location
    Canada
    Posts
    50
    Plugin Contributions
    0

    Default Re: Cross Sell Install Trouble - SQL Error - help would be great!

    I get the same message as well,

    Steve did you find a solution?

    when i looked, the products_xsell table has been added to the database and when i tested the cross sell it works and associates the products, displays ok.

    however what is missing is the show price with cross sell in the admin (configuration) panel. (and therefore the prices in the front end display)

    I did follow the instructions to the letter, and this is a near virgin installation of Zen Cart. Only the French language pack was added prior to the cross sell installation.

    I'm not rabid for the prices showing up.. but would appreciate if someone has a solution, just in case this is a bigger problem then it seems like at the moment. and it somehow interferes with the running of the additional mods that depend on this one.

    thanks
    nev

  3. #3

    Default Re: Cross Sell Install Trouble - SQL Error - help would be great!

    I've had the same problem. Has anyone found a solution?

  4. #4
    Join Date
    Aug 2007
    Posts
    114
    Plugin Contributions
    0

    Default Re: Cross Sell Install Trouble - SQL Error - help would be great!

    Ahh man this is frustrating I have the same problem and have been looking on and off for months to fix this.

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

    CAN ANYONE HELP US!

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

    Default Re: Cross Sell Install Trouble - SQL Error - help would be great!

    Where do you download the mod?

    Try: https://svn.rubikintegration.com/zen...sell_advanced/
    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. Cross Sell SQL error
    By garwak in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 18 Jan 2013, 03:06 AM
  2. Fatal Error After installing Cross Sell - Just Another Cross Sell Mod
    By kconklin in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 9 Jul 2010, 02:38 PM
  3. Cross Sell SQL Error
    By TurtleDove in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 12 Mar 2008, 04:42 AM
  4. Cross Sell My Sql Syntax Error
    By squid in forum All Other Contributions/Addons
    Replies: 16
    Last Post: 22 Sep 2007, 11:04 PM
  5. Cross sell sql error
    By bean_2k1 in forum Contribution-Writing Guidelines
    Replies: 7
    Last Post: 10 Apr 2007, 03:19 PM

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