Page 1 of 3

Visual Confirmation Help

Posted: Tue Feb 06, 2007 10:51 pm
by hubmonkey
Whenever I click on the radio dot to turn on visual confirmation it does not save. I have looked and the code is in the two files listed in the FAQ but it just does not work. Any Help?

Hub

re

Posted: Tue Feb 06, 2007 10:57 pm
by pcs800
make sure the proper permission are given for the directory the info is stored in.

Posted: Tue Feb 06, 2007 10:59 pm
by hubmonkey
what directory should I check permissions on?

I looked and I show full permissions... I have USER GROUP and WORLD 7. The two files listed in the FAQ I have added Execute to them and still the same.. Am I missing a file I need to change permissions on?

Hub

Posted: Wed Feb 07, 2007 12:02 am
by hubmonkey
Anyone?


Hub

Posted: Wed Feb 07, 2007 12:20 am
by stevemaury
What template? Not all support VC.

Posted: Wed Feb 07, 2007 12:37 am
by hubmonkey
subSilver

Hub

Posted: Wed Feb 07, 2007 1:21 am
by Lumpy Burgertushie
upload new copies of usercp_confirm.php
and
usercp_register.php

if you have any MODs that affect those files, then rename your existing copies first before you test the new ones.

robert

Posted: Wed Feb 07, 2007 1:33 am
by hubmonkey
Lumpy Burgertushie wrote: upload new copies of usercp_confirm.php
and
usercp_register.php

if you have any MODs that affect those files, then rename your existing copies first before you test the new ones.

robert


Okay downloaded and renamed the old ones and uploaded new ones and still no go.

Hub

Posted: Wed Feb 07, 2007 2:19 pm
by hubmonkey
Anyone else?

Hub

Posted: Wed Feb 07, 2007 3:20 pm
by espicom
At some point, you probably did an update without running update_to_latest.php, and your database is missing support for Visual Confirmation. The Knowledge Base article on Checking for Visual Confirmation support in your database and templates explains this, and has a script for testing just for the VC support items. It can also fix one of the possible problems, if you uncomment three lines within it.

This does a more extensive test:

http://espi.com/text/validate_phpbb_v22.php.txt

RIGHT click on the link above, and select "save as". Save it to your local disk. You then upload it as "validate_phpbb_v22.php" to your PHPBB directory, and run it with your browser. The results will tell you what fields and/or tables are missing.

If anything shows up in red, other than the database version number, copy the "bbcode version" of the report from the text box at the bottom of the page and paste into a reply here, so that we can see what the results were.

Posted: Wed Feb 07, 2007 8:05 pm
by hubmonkey
Thanks for the assistance... here is what I got.

Required table phpbb_auth_access has all required fields
Required table phpbb_user_group has all required fields
Required table phpbb_groups has all required fields
Required table phpbb_banlist has all required fields
Required table phpbb_categories has all required fields
Required table phpbb_config has all required fields
Required table phpbb_confirm is missing!
Required table phpbb_disallow has all required fields
Required table phpbb_forum_prune has all required fields
Required table phpbb_forums has all required fields
Required table phpbb_posts has all required fields
Required table phpbb_posts_text has all required fields
Required table phpbb_privmsgs has all required fields
Required table phpbb_privmsgs_text has all required fields
Required table phpbb_ranks has all required fields
Required table phpbb_search_results is missing search_time
Required table phpbb_search_wordlist has all required fields
Required table phpbb_search_wordmatch has all required fields
Required table phpbb_sessions has all required fields
Required table phpbb_sessions_keys has all required fields
Required table phpbb_smilies has all required fields
Required table phpbb_themes has all required fields
Required table phpbb_themes_name has all required fields
Required table phpbb_topics has all required fields
Required table phpbb_topics_watch has all required fields
Required table phpbb_users has all required fields
Required table phpbb_vote_desc has all required fields
Required table phpbb_vote_results has all required fields
Required table phpbb_vote_voters has all required fields
Required table phpbb_words has all required fields

Database reports it is version 2.0.19.
Required configuration keys enable_confirm, sendmail_fix, search_flood_interval, rand_seed, search_min_chars are missing!

Style 'subSilver' supports Visual Confirmation for registration, supports Visual Confirmation configuration option,
supports Auto Logon configuration option, supports Maximum login count configuration option.

Extension Zlib, which will enhance the security of the standard Visual Confirmation image, is available.
Extension GD, necessary for the FREECAP replacement for the Visual Confirmation image, is available.

Posted: Wed Feb 07, 2007 10:11 pm
by espicom
You need to run these queries:

Code: Select all

#
# Table structure for table 'phpbb_confirm'
#
CREATE TABLE phpbb_confirm (
  confirm_id char(32) DEFAULT '' NOT NULL,
  session_id char(32) DEFAULT '' NOT NULL,
  code char(6) DEFAULT '' NOT NULL, 
  PRIMARY KEY  (session_id,confirm_id)
);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');
The rest of the missing stuff will be added when you update your forum and run the update_to_latest.php script.

Posted: Wed Feb 07, 2007 10:27 pm
by hubmonkey
Sorry for the ignorance here but I am still a newb.

What do I need to do and where?

Thanks a million.

Hub

Posted: Thu Feb 08, 2007 12:05 am
by abusedemailaddress
You need a tool to run SQL commands - like phpmyadmin, or (if you don't have phpmyadmin), your host should have provided some sort of "database console" to handle it.

Posted: Thu Feb 08, 2007 1:12 am
by hubmonkey
Well my host uses Cpanel 10 and in there I have MySQL Databases and it lists them but not sure how to do what is being suggested. I am getting hit HARD by Spam Bots.

Hub