Visual Confirmation Help

[espicom]

Cpanel normally has phpmyadmin as one of the programs installed. Find it, click on the "SQL" button, and it will present you with an SQL text box, to enter the queries into. Then, you click GO.

[Lumpy Burgertushie]

from your cpanel,
click on mysql
scroll down to the botton and click on phpmyadmin, then on the left side, find your database and click on it.

then on the right side, click on the sql tab and copy and paste the query into that box and click the go button


robert

[hubmonkey]

Okay so I did the query and it comes back with a blank white screen. I re-ran the Validate PHP script and get this...

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

[hubmonkey]

Okay I did the Query and this is what I got....

Error
SQL query:

#
# Table structure for table 'phpbb_confirm'
#
CREATE TABLE phpbb_confirm(

confirm_idchar( 32 ) DEFAULT '' NOT NULL ,
session_idchar( 32 ) DEFAULT '' NOT NULL ,
codechar( 6 ) DEFAULT '' NOT NULL ,
PRIMARY KEY ( session_id, confirm_id )
);



MySQL said:

#1050 - Table 'phpbb_confirm' already exists

[espicom]

Now that it says the table already exists, do you get the same results when you run the test script? There are several other things missing from your tables, and it would appear that the update_to_latest.php script has been skipped more than once in the past history of your board...

[hubmonkey]

Now that it says the table already exists, do you get the same results when you run the test script? There are several other things missing from your tables, and it would appear that the update_to_latest.php script has been skipped more than once in the past history of your board...

The results are the same. My Hosting company has updated it a couple of times due to security concerns and I know that they have in fact skipped a couple of revisions. since the board was created.

Hub

[espicom]

OK, phpmyadmin says phpbb_confirm already exists, but the test script can't find it... This is truly weird!

Code: Select all

ALTER TABLE phpbb_search_results ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES
('enable_confirm','1'),
('sendmail_fix','1'),
('search_flood_interval', '15'),
('rand_seed', '0'),
('search_min_chars', '3');

Run that set of queries with phpmyadmin, then re-run the test script.

Are you sure phpmyadmin is working on the same database as PHPBB?

[hubmonkey]

Ran that query and this is what I received...

Ran that query and this is what I received...

Error
SQL query:

ALTER TABLE phpbb_search_results ADD COLUMN search_time int( 11 ) DEFAULT '0' NOT NULL ;

MySQL said:

#1060 - Duplicate column name 'search_time'



Ran the test and this is what I received....

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

[hubmonkey]

I think it is really jacked up because I have to login 2 times in order to get logged in, it does not keep me logged in (even though I have it turned on in the configuration) and when I try to find posts people have made by clicking on their profile it errors out.

Hub

[geocator]

I think it is really jacked up because I have to login 2 times in order to get logged in, it does not keep me logged in (even though I have it turned on in the configuration) and when I try to find posts people have made by clicking on their profile it errors out.

Hub

Those are cookie issues and can be resolved easily, but first you have to get the database issues fixed. It apears you are accessing a different database in phpmyadmin than phpbb is accessing, check the name in config,php and make sure that is the db you are accessing in phpmyadmin.

[hubmonkey]

These are the options in myphpadmin....

hubmonke_gallery
hubmonke_imga1
hubmonke_phpb1
hubmonke_poll1
hubmonke_xmb1

The Bold one is the one I have been working off of.


Hub

[geocator]

check the name in config,php and make sure that is the db you are accessing in phpmyadmin.

[hubmonkey]

Okay... Well I feel really stupid now... I was working off the wrong database... it is supposed to be the XMB1 and not the PHPB1... geez...

Here is the results after doing the previous strings....

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 has all required fields
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 has all required fields
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.22.
Required configuration keys 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.

[geocator]

So now you just have the login issues correct?

Knowledge Base - Fixing cookie/domain/script path settings
If you still have a problem after following the instructions in the article, please post back with your new cookie settings. (You can copy it from the box in the MOD).

[hubmonkey]

So now you just have the login issues correct?

Knowledge Base - Fixing cookie/domain/script path settings
If you still have a problem after following the instructions in the article, please post back with your new cookie settings. (You can copy it from the box in the MOD).

Yes the Visual Confirmation issue is corrected, and I REALLY REALLY thank you guys for all your assistance.

I will read the article and try to fix the cookie issues.

Hub