SQL error when trying to install the captcha_verification_antirobot_registration_1.4
When trying to run an sql patch in the admina rea, I got 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 'Version 1.3, which was the base code used for v1.4. SELECT @sortorder:=max(sort_' at line 1 in: [Version 1.3, which was the base code used for v1.4. SELECT @sortorder:=max(sort_order) FROM zen_configuration_group;] 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 do I address this?
Re: SQL error help please
is this resolved? I am having this kind of problem too, how did you get it?
Re: SQL error help please
apologies, here is the exact 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 'Version 1.3, which was the base code used for v1.4. SELECT @sortorder:=max(sort_' at line 1
in:
[Version 1.3, which was the base code used for v1.4. SELECT @sortorder:=max(sort_order) FROM zen_configuration_group;]
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.
I was trying to install the captcha_verification_antirobot_registration_1.4_for_zc_v1.5.0 in zencart 1.3.9h. I am currently working it on my local computer and soon to upload so cant provide the url. Is it possible for me to test the captcha even if my site is not live yet? Sorry for that noob question, just want to know.
Thanks
Re: SQL error when trying to install the captcha_verification_antirobot_registration_
I know just enough to get myself in trouble but when I pasted the code, one of the first "Comment" lines didn't have the # symbol as the first character on the line.
I inserted a # symbol on that line, no longer received the error and CAPTCHA is functioning as described.
# 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)
Version 1.3, which was the base code used for v1.4.
mySQL 5.3.8
V1.5 clean install
andover_modern template
uploaded via FTP
1st addon to be installed.
This part of the install is Greek to me:
--IMPORTANT!!! REGARDING the Installation SQL--
# In the admin_pages table line, 4th section down in the SQL:
# 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 as set in the SQL. However, if you have added additional
# Add-Ons already or, made changes to this table, you will need to set those numbers to what the next setting would be for them, in Sequential Order.