Results 1 to 4 of 4
  1. #1

    Default Captcha Install Error

    Installed all the captcha_verification_antirobot_registration_1.4_for_zc_v1.5.0 files in V1.5 and tried to run the sql i get this error message. The last gID in the table is 30 and the last sort_order is 25 in the admin_pages table.
    I tried to use the install sql patches in zencart and i tried to import directly into the table in php admin neither one will put the values into the table. There are no entries in the configuration table either. Using php 5.4
    Any help would be appreciated.

    " SQL query:
    # CAPTCHA Verification SQL Install
    # For Zen-Cart v1.5.0
    # Last Updated: 09-11-2011 by Joseph Greely (Joseph_Greely) v1.5.0
    # Thanks to JT of GTI_Custom (JTheed)
    Version1.3, which was the base code used FOR v1.4.# IMPORTANT!!! In the admin_pages table line, 4th section down:
    # The page_params 'gID=31', and the sort_order '26' that you see in the 'admin_pages' table settings, are for EXAMPLE PURPOSES ONLY!!
    # If you are doing a fresh Install of Zen-Cart v1.5.0, with no other Add-Ons, added as of yet, you may leave these numbers. However, if you have additional
    # Add-Ons already in place, or, have made changes to this table, you will need to set those numbers to what the next setting would be for them, in Sequential Order.
    #
    # Remember to BACK-UP your database before installing this SQL file!!
    SELECT @sortorder := max( sort_order )
    FROM configuration_group;
    MySQL said:
    #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 'Version 1.3, which was the base code used for v1.4.

    # IMPORTANT!!! In the ad' at line 5 "

  2. #2
    Join Date
    May 2011
    Posts
    24
    Plugin Contributions
    0

    Default Re: Captcha Install Error

    Yup wont install for me neither i have everything uploaded but when i copy and paste the code i get unable to install and same if i was to add the sql file it self.

  3. #3
    Join Date
    Aug 2009
    Location
    North Idaho, USA
    Posts
    2,008
    Plugin Contributions
    1

    Default Re: Captcha Install Error

    Try putting a # symbol at the beginning of the comment line(s) where it seems to be missing. It is either the 4th or 5th line.

    #Version1.3, which was the base code used FOR v1.4.

    That worked for me but mine was a fresh install and this was the first addon.
    Rick
    RixStix (dot) com
    aka: ChainWeavers (dot) com

  4. #4

    Default Re: Captcha Install Error

    I installed this on a local server [xampp] with a fresh 1.5 install and it works fine, control panel in admin etc.
    I then installed it on my remote server and the admin controls for it were not there, only the headings under the capthca config,
    "title,value,action".
    But the capthcha fields seem to work fine on the site.
    To change settings I have to go into phpmyadmin to do it.

    I found the gid31 on the last page of admin_pages.
    I did not paste in the comments, so did not get the # thing.

 

 

Similar Threads

  1. CAPTCHA Error: Session not started. The CAPTCHA cannot be used!
    By betheone in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 17 Jan 2014, 05:39 AM
  2. How to install Captcha?
    By Bris420 in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 18 Nov 2011, 11:46 AM
  3. How to install Captcha
    By roibert in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 27 Jan 2011, 12:26 PM
  4. CAPTCHA FOR ZENCART - SQL error upon install
    By rodent042 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 1 Nov 2010, 01:28 PM
  5. Error w/CAPTCHA
    By ranger_lp in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 4 Jul 2010, 03:12 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