Printable View
Thanks Clyde.
Do you know of an easy way to rid myself of the tables and such that the captcha mod installed in my database? It didn't come with an uninstall SQL, and that actually concerned me when I installed it....Not knowing how to create an uninstall SQL may actually be a good thing for me...LOL.
OR
Do you think it will be fine to just install the new captcha? It is a live shop.
Run this sql statement using the Zen-Cart Sql Patches toolQuote:
Originally Posted by daneh
(admin -> tools -> install sql patches)
For best results, copy-and-paste the code into the query field and press 'Send'.
Code:#CAPTCHA Validation SQL Uninstall
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'CAPTCHA Validation'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
INSERT INTO `configuration` VALUES (NULL, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');
DROP TABLE IF EXISTS `anti_robotreg`;
You are the man Clyde.:smartalec:
I did receive errors when I used the SQL, but I think everything is working ok. I will keep looking for issues I may have caused, but so far so good.
errors were:Thanks for the help!:hug:Code:Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Error ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
There is no problem with the error message, it is just telling you that the configuration key is already in the data base and that that particular sql statement was ignored.Quote:
Originally Posted by daneh
Thanks Clyde for a great mod I only have on issue, The sidebox looks good in IE7 but in FF the break line is in the same line as the Read More. Is there something I can do to fix that Issue.
The link is www.coolcarpartsonline.com
Try thisQuote:
Originally Posted by Glamorousshoe
just unzip the file and upload to includes/templates/YOUR_TEMPLATE/sideboxes/
Attachment 4895
You might also want to correct the 100+ validation errors on your main page.
I didn't build the site I had a company build it.
What does these error and warning affect. The site look the same in FF and IE is there affect of these validation errors on something that I am not aware of?
I rarely find sites that don't have validation errors with the amount of modification done to the original template it will create errors most of which are characters error of content and not core files.
A lot of these errors can effect the display and/or accessibility of a page/site.Quote:
Originally Posted by Glamorousshoe
line 4 column 100 - Warning: unescaped & which should be written as &
line 6 column 38 - Warning: unescaped & which should be written as &
line 6 column 73 - Warning: unescaped & which should be written as &
line 116 column 59 - Warning: <marquee> is not approved by W3C
line 116 column 251 - Warning: inserting implicit <marquee>
line 116 column 265 - Warning: inserting implicit <marquee>
line 116 column 265 - Warning: missing </a> before <center>
line 116 column 399 - Warning: unescaped & or unknown entity "&R"
line 116 column 412 - Warning: unescaped & or unknown entity "&R"
line 116 column 412 - Warning: inserting implicit <marquee>
line 116 column 442 - Warning: discarding unexpected </a>
line 116 column 257 - Warning: missing </center>
line 116 column 458 - Warning: inserting implicit <marquee>
line 116 column 472 - Warning: inserting implicit <marquee>
line 116 column 472 - Warning: missing </a> before <center>
line 116 column 575 - Warning: inserting implicit <marquee>
line 116 column 659 - Warning: discarding unexpected </a>
line 116 column 464 - Warning: missing </center>
line 116 column 675 - Warning: inserting implicit <marquee>
line 116 column 689 - Warning: inserting implicit <marquee>
line 116 column 689 - Warning: missing </a> before <center>
line 116 column 792 - Warning: inserting implicit <marquee>
line 116 column 884 - Warning: discarding unexpected </a>
line 116 column 681 - Warning: missing </center>
line 116 column 900 - Warning: inserting implicit <marquee>
line 116 column 914 - Warning: inserting implicit <marquee>
line 116 column 914 - Warning: missing </a> before <center>
line 116 column 1017 - Warning: inserting implicit <marquee>
line 116 column 1115 - Warning: discarding unexpected </a>
line 116 column 906 - Warning: missing </center>
line 116 column 1131 - Warning: inserting implicit <marquee>
line 116 column 1145 - Warning: inserting implicit <marquee>
line 116 column 1145 - Warning: missing </a> before <center>
line 116 column 1248 - Warning: inserting implicit <marquee>
line 116 column 1328 - Warning: discarding unexpected </a>
line 116 column 1137 - Warning: missing </center>
line 116 column 1344 - Warning: inserting implicit <marquee>
line 116 column 1358 - Warning: inserting implicit <marquee>
line 116 column 1358 - Warning: missing </a> before <center>
line 116 column 1461 - Warning: inserting implicit <marquee>
line 116 column 1563 - Warning: discarding unexpected </a>
line 116 column 1350 - Warning: missing </center>
line 116 column 1579 - Warning: inserting implicit <marquee>
line 116 column 1593 - Warning: inserting implicit <marquee>
line 116 column 1593 - Warning: missing </a> before <center>
line 116 column 1696 - Warning: inserting implicit <marquee>
line 116 column 1786 - Warning: discarding unexpected </a>
line 116 column 1585 - Warning: missing </center>
line 116 column 1796 - Warning: discarding unexpected </marquee>
line 125 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 126 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 127 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 128 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 129 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 130 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 142 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 143 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 144 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 145 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 146 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 147 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 148 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 149 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 158 column 65 - Warning: unescaped & which should be written as &
line 161 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 162 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 163 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 164 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 165 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 209 column 486 - Warning: inserting implicit <p>
line 232 column 94 - Warning: <br> element not empty or not closed
line 326 column 1 - Warning: discarding unexpected <head>
line 327 column 1 - Warning: <meta> isn't allowed in <div> elements
line 325 column 1 - Info: <div> previously mentioned
line 327 column 1 - Warning: <meta> element not empty or not closed
line 335 column 28 - Warning: unescaped & which should be written as &
line 336 column 32 - Warning: unescaped & which should be written as &
line 331 column 102 - Warning: missing </form>
line 339 column 382 - Error: discarding unexpected </form>
line 342 column 60 - Warning: unescaped & which should be written as &
line 345 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 346 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 347 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 348 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 349 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 350 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 351 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 352 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 353 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 354 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 355 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 356 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 357 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 358 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 359 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 360 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 372 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 373 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 374 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 375 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 376 column 39 - Warning: unescaped & or unknown entity "&cPath"
line 395 column 134 - Warning: <img> element not empty or not closed
line 400 column 132 - Warning: unescaped & which should be written as &
line 401 column 251 - Warning: unescaped & or unknown entity "&article_id"
line 401 column 394 - Warning: unescaped & or unknown entity "&article_id"
line 116 column 1248 - Warning: <img> escaping malformed URI reference
line 116 column 1461 - Warning: <img> escaping malformed URI reference
line 116 column 1696 - Warning: <img> escaping malformed URI reference
line 140 column 1 - Warning: <div> anchor "brand_sidebox" already defined
line 159 column 1 - Warning: <div> anchor "brand_sidebox" already defined
line 203 column 67 - Warning: <form> anchor "subscribe" already defined
line 343 column 1 - Warning: <div> anchor "brand_sidebox" already defined
line 370 column 1 - Warning: <div> anchor "brand_sidebox" already defined
line 116 column 59 - Warning: trimming empty <marquee>
line 116 column 359 - Warning: trimming empty <center>
line 116 column 566 - Warning: trimming empty <center>
line 116 column 783 - Warning: trimming empty <center>
line 116 column 1008 - Warning: trimming empty <center>
line 116 column 1239 - Warning: trimming empty <center>
line 116 column 1452 - Warning: trimming empty <center>
line 116 column 1687 - Warning: trimming empty <center>
line 209 column 218 - Warning: trimming empty <p>
line 209 column 486 - Warning: trimming empty <p>
Clyde,
Unfortunately the captcha using TFF breaks my cart. I tried it on two separate carts, and I get the same results...when trying to log in or create an account, white blank pages. I tried to win merge them, but some of the pages are SO different, I didn't really know what should be changed.
I had to go back to the other captcha in the downloads section: captcha anti robot registration.
I did install the zip files you included for the other captcha (tff one) in a previous post to see if they would add a captcha to my testimonials page, but all I get is aBut no picture shows up.Code:Verification code: Enable this picture
Redraw Capture Image
Verification code: * (case insensitive)
I know my captcha doesn't have the redraw button (a HUGE drawback in my opinion), you have to refresh the page to get it to redraw, so I am assuming the zips you supplied won't work.
Any suggestions? (beside learning to use winmerge :smile:)?
That is correct the captcha fixes I've provided will not work with the anti robot registration contribution.Quote:
Originally Posted by daneh