validate_phpbb_v22.php -> lots of problems!

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
Locked
skynetslo
Registered User
Posts: 9
Joined: Sun Sep 28, 2008 9:55 pm

validate_phpbb_v22.php -> lots of problems!

Post by skynetslo » Sun Sep 28, 2008 10:00 pm

Hi!

I searched through the forums and I found a php file to validate my phpbb forum. It didn't work, I allways get "Could not locate valid language pack" error. So I ran the validation php and i got this:

Checking list of tables for required fields...

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

Required configuration keys config_id, board_disable, sitename, site_desc, cookie_name, cookie_path, cookie_domain, cookie_secure, session_length, allow_html, allow_html_tags, allow_bbcode, allow_smilies, allow_sig, allow_namechange, allow_theme_create, allow_avatar_local, allow_avatar_remote, allow_avatar_upload, enable_confirm, override_user_style, posts_per_page, topics_per_page, hot_threshold, max_poll_options, max_sig_chars, max_inbox_privmsgs, max_sentbox_privmsgs, max_savebox_privmsgs, board_email_sig, board_email, smtp_delivery, smtp_host, smtp_username, smtp_password, sendmail_fix, require_activation, flood_interval, board_email_form, avatar_filesize, avatar_max_width, avatar_max_height, avatar_path, avatar_gallery_path, smilies_path, default_style, default_dateformat, board_timezone, prune_enable, privmsg_disable, gzip_compress, coppa_fax, coppa_mail, record_online_users, record_online_date, server_name, server_port, script_path, version, search_min_chars, board_startdate are missing!

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.
Extension Multibyte String is installed.


Seems like a lot of configuration keys are missing, but how do I fix this?

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: validate_phpbb_v22.php -> lots of problems!

Post by ric323 » Mon Sep 29, 2008 3:44 am

First, please fill in the Support Request Template to tell us about your board so we can help you effectively.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

skynetslo
Registered User
Posts: 9
Joined: Sun Sep 28, 2008 9:55 pm

Re: validate_phpbb_v22.php -> lots of problems!

Post by skynetslo » Mon Sep 29, 2008 10:06 am

My appologies, here's the info:

Your board's URL:
www.toptorrents.org/forum
Version of phpBB2:
I don't know the subversion, but it's 2.0.x for sure
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)?
It's like this. I bought the site and the forum wasn't working. The previous owner said he has no idea why
it isn't working, and neither do I.

Did you use an automated wizard provided by your host to install phpBB?
I think not.
MODs you have installed: don't know
When the problem started: it was like this when i got the site
Your level of expertise (be honest): on a scale from 1 to 10, it's probably 4 :)

Additionally, you may wish to provide the following (where applicable)
Template(s) used: folders I found in the forum dir are: AndGrey, brgr_black, FSClean, subSilver
Language(s) used: english
Version of PHP used: 5.2.5
Database and version used: MySQL 5.0.51a

skynetslo
Registered User
Posts: 9
Joined: Sun Sep 28, 2008 9:55 pm

Re: validate_phpbb_v22.php -> lots of problems!

Post by skynetslo » Mon Sep 29, 2008 10:08 am

Btw, I should mention I found a thread here with a code for fix.php. I uploaded that code to my site, ran it and since then my errors in validate_phpbb_v22.php dropped. Before that I got a few more errors.
So i guess there's something more to be fixed.

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: validate_phpbb_v22.php -> lots of problems!

Post by ric323 » Mon Sep 29, 2008 10:23 am

I'm seeing:
Could not get theme data for themes_id []
That means your board is trying to load a theme which is not present (or vital bits are missing).

This article should force all users back to the default subSilver template:
Knowledge Base - Set subSilver as the default template
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

skynetslo
Registered User
Posts: 9
Joined: Sun Sep 28, 2008 9:55 pm

Re: validate_phpbb_v22.php -> lots of problems!

Post by skynetslo » Mon Sep 29, 2008 10:28 am

Thanks, I ran this, but I still get the same error!

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: validate_phpbb_v22.php -> lots of problems!

Post by ric323 » Mon Sep 29, 2008 10:45 am

Did you check if your "table_prefix" is the default value of "phpbb_"?
If not, you need to adjust the edits to use your actual prefix.
(You can see the value your boards is using by looking inside your config.php file)
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

skynetslo
Registered User
Posts: 9
Joined: Sun Sep 28, 2008 9:55 pm

Re: validate_phpbb_v22.php -> lots of problems!

Post by skynetslo » Mon Sep 29, 2008 11:04 am

Yes it is

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: validate_phpbb_v22.php -> lots of problems!

Post by ric323 » Mon Sep 29, 2008 11:13 am

Have a look at Steve's suggestion in this post:
http://www.phpbb.com/community/viewtopi ... 5#p6148505
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

skynetslo
Registered User
Posts: 9
Joined: Sun Sep 28, 2008 9:55 pm

Re: validate_phpbb_v22.php -> lots of problems!

Post by skynetslo » Mon Sep 29, 2008 11:51 am

Tried, unfortunately it didn't help.

Ok now the forum isn't working, but can I update it to PHPBB 3.x and use the same database? So the data from the current forum would stay?

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: validate_phpbb_v22.php -> lots of problems!

Post by ric323 » Mon Sep 29, 2008 12:04 pm

Yes. The update does NOT modify your existing board in any way, it creates a new board in a different folder, so there is no risk in trying it.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Re: validate_phpbb_v22.php -> lots of problems!

Post by espicom » Wed Oct 01, 2008 4:44 am

Required configuration keys config_id, board_disable, sitename, site_desc, cookie_name, cookie_path, cookie_domain, cookie_secure, session_length, allow_html, allow_html_tags, allow_bbcode, allow_smilies, allow_sig, allow_namechange, allow_theme_create, allow_avatar_local, allow_avatar_remote, allow_avatar_upload, enable_confirm, override_user_style, posts_per_page, topics_per_page, hot_threshold, max_poll_options, max_sig_chars, max_inbox_privmsgs, max_sentbox_privmsgs, max_savebox_privmsgs, board_email_sig, board_email, smtp_delivery, smtp_host, smtp_username, smtp_password, sendmail_fix, require_activation, flood_interval, board_email_form, avatar_filesize, avatar_max_width, avatar_max_height, avatar_path, avatar_gallery_path, smilies_path, default_style, default_dateformat, board_timezone, prune_enable, privmsg_disable, gzip_compress, coppa_fax, coppa_mail, record_online_users, record_online_date, server_name, server_port, script_path, version, search_min_chars, board_startdate are missing!
This would indicate that something emptied the configuration table. It's still there, because it has all the required fields, but it is empty.

This is the "installation" version of that data:

Code: Select all

#
# Basic DB data for phpBB2 devel
#
# $Id: mysql_basic.sql,v 1.29.2.29 2006/12/16 13:11:27 acydburn Exp $

# -- Config
INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sendmail_fix','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_flood_interval','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_min_chars','3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.tld');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.22');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rand_seed', '0');
You could run those queries, and get your board to the point where other tools (like the Admin Tool Kit) can get you back in operation, OR restore that one table from whatever backup you have.
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

Locked

Return to “2.0.x Support Forum”