Visual Confirmation Help

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by 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.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer
User avatar
Lumpy Burgertushie
Registered User
Posts: 68476
Joined: Mon May 02, 2005 3:11 am
Contact:

Post by 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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
hubmonkey
Registered User
Posts: 30
Joined: Mon Jul 12, 2004 2:55 pm

Post by 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
Registered User
Posts: 30
Joined: Mon Jul 12, 2004 2:55 pm

Post by 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
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by 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...
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer
hubmonkey
Registered User
Posts: 30
Joined: Mon Jul 12, 2004 2:55 pm

Post by hubmonkey »

espicom wrote: 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
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by 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?
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer
hubmonkey
Registered User
Posts: 30
Joined: Mon Jul 12, 2004 2:55 pm

Post by 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
Registered User
Posts: 30
Joined: Mon Jul 12, 2004 2:55 pm

Post by 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
Registered User
Posts: 16242
Joined: Fri Jan 09, 2004 11:56 pm
Location: On dry land
Contact:

Post by geocator »

hubmonkey wrote: 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
Registered User
Posts: 30
Joined: Mon Jul 12, 2004 2:55 pm

Post by 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
Registered User
Posts: 16242
Joined: Fri Jan 09, 2004 11:56 pm
Location: On dry land
Contact:

Post by geocator »

geocator wrote: check the name in config,php and make sure that is the db you are accessing in phpmyadmin.
hubmonkey
Registered User
Posts: 30
Joined: Mon Jul 12, 2004 2:55 pm

Post by 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
Registered User
Posts: 16242
Joined: Fri Jan 09, 2004 11:56 pm
Location: On dry land
Contact:

Post by 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
Registered User
Posts: 30
Joined: Mon Jul 12, 2004 2:55 pm

Post by hubmonkey »

geocator wrote: 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
Locked

Return to “2.0.x Support Forum”