Visual Confirmation Help

[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

[pcs800]

make sure the proper permission are given for the directory the info is stored in.

[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

[hubmonkey]

Anyone?


Hub

[stevemaury]

What template? Not all support VC.

[hubmonkey]

subSilver

Hub

[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

[hubmonkey]

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

[hubmonkey]

Anyone else?

Hub

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

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

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

[hubmonkey]

Sorry for the ignorance here but I am still a newb.

What do I need to do and where?

Thanks a million.

Hub

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

[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