Icy Phoenix

Old Support Topics - Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

ancraz [ Wed 25 Nov, 2009 16:03 ]
Post subject: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Please help me fix this issue

Quote:
Server And Version Information

* Installed phpBB version :: 2.0.23 » Latest release :: 2.0.23
* Installed Icy Phoenix version :: 1.3.0.53 » Latest release :: 1.3.0.53
* Database Type :: mysql4
* File Writing :: Your server doesn't support file creation and editing.
* Files & Folders Permissions:
Spoiler: [ Show ]
Spoiler: [ Hide ]
CHMOD 777
o ../backup Ok
o ../cache Ok
o ../cache/forums Ok
o ../cache/posts Ok
o ../cache/sql Ok
o ../cache/topics Ok
o ../cache/users Ok
o ../ctracker/logfiles/logfile_attempt_counter.txt Ok
o ../ctracker/logfiles/logfile_blocklist.txt Ok
o ../ctracker/logfiles/logfile_debug_mode.txt Ok
o ../ctracker/logfiles/logfile_malformed_logins.txt Ok
o ../ctracker/logfiles/logfile_spammer.txt Ok
o ../ctracker/logfiles/logfile_worms.txt Ok
o ../downloads Ok
o ../files Ok
o ../files/album Ok
o ../files/album/cache Ok
o ../files/album/med_cache Ok
o ../files/album/users Ok
o ../files/album/wm_cache Ok
o ../files/posted_images Ok
o ../files/screenshots Ok
o ../files/thumbs Ok
o ../images/avatars Ok
o ../logs Ok

Your Icy Phoenix is version is up-to-date

Now i have made some progress

all the requirements are meet but i am still sit in the

Quote:
database_update.php

with no option or any way to go from there this does not make any sense to me

. does the conversion work or not ,are i am doing some thing wrong here
i am going mad here

ancraz [ Fri 27 Nov, 2009 16:18 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Convert :(

Here is the link to the site http://underarchive.com/phpBB2/
this my 7th conversion attempt i failed at

i want to use this script but now i am not able since i cant upgrade

if any can please help this stupid

followed the steps word by word

spydie [ Fri 27 Nov, 2009 19:41 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

ancraz.

first thing . can you gimme a valid link to your site?

second . whiling to give you a hand.

please PM me for further details, like ftp access etc.

ancraz [ Fri 27 Nov, 2009 23:42 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

spydie wrote: [View Post]
ancraz.

first thing . can you gimme a valid link to your site?

second . whiling to give you a hand.

please PM me for further details, like ftp access etc.

my site url is underarchive.com which is in smf script . i am converting it into phbb 2 and then to ice phoenix

and i failed 7 times
thank u for helping me

spydie [ Fri 27 Nov, 2009 23:48 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

have you already converted to PhpBB2 ?

you could gimme a clou where ecactly your stuck at the moment

ancraz [ Sat 28 Nov, 2009 00:08 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

spydie wrote: [View Post]
have you already converted to PhpBB2 ?

you could gimme a clou where ecactly your stuck at the moment

first i converted from smf to phpbb2 then followed

How To Upgrade From phpBB 2 and i fail after the following step

12. Apply all permissions listed in Fresh Installation.

the script does not work so i can't Start with the 13 step

when i tried for the 8th time finally got some error message atleast

Spoiler: [ Show ]

Code: [Hide] [Select]

Icy Phoenix - Update in progress

The following SQL have not been executed:

    * ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT(8) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`

      +++ Error: Duplicate column name 'cat_parent'

    * ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`

      +++ Error: Duplicate column name 'cat_user_id'

    * ALTER TABLE phpbb_auth_access ADD `auth_mod` tinyint(1) NOT NULL default '0'

      +++ Error: Duplicate column name 'auth_mod'

    * ALTER TABLE `phpbb_sessions` ADD `session_admin` TINYINT(2) DEFAULT '0' NOT NULL

      +++ Error: Duplicate column name 'session_admin'

    * CREATE TABLE `phpbb_sessions_keys` ( `key_id` varchar(32) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `last_ip` varchar(8) NOT NULL default '0', `last_login` int(11) NOT NULL default '0', PRIMARY KEY (`key_id`,`user_id`), KEY `last_login` (`last_login`) )

      +++ Error: Table 'phpbb_sessions_keys' already exists

    * INSERT INTO phpbb_config VALUES ('allow_autologin', '1')

      +++ Error: Duplicate entry 'allow_autologin' for key 1

    * INSERT INTO phpbb_config VALUES ('max_autologin_time', '0')

      +++ Error: Duplicate entry 'max_autologin_time' for key 1

    * INSERT INTO `phpbb_kb_articles` VALUES (1, 1, 'Test Article', 'This is a test article for your KB', '1057708235', 2, '', '93074f48a9', 'This is a test article for your Knowledge Base. This MOD is based on code written by wGEric < eric@egcnetwork.com > (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo < jonohlsson@hotmail.com > (Jon Ohlsson) - http://www.mx-system.com/ Be sure you add categories and article types in the ACP and also change the Configuration to your liking. Have fun and enjoy your new Knowledge Base! :D', 1, 1, 0, 0, '0.0000', 0)

      +++ Error: Column count doesn't match value count at row 1

    * DROP TABLE phpbb_cracktrack

      +++ Error: Unknown table 'phpbb_cracktrack'

    * ALTER TABLE phpbb_users ADD user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL

      +++ Error: Duplicate column name 'user_login_tries'

    * ALTER TABLE phpbb_users ADD user_last_login_try int(11) DEFAULT '0' NOT NULL

      +++ Error: Duplicate column name 'user_last_login_try'

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

      +++ Error: Duplicate column name 'search_time'

    * INSERT INTO phpbb_config VALUES ('search_min_chars', '3')

      +++ Error: Duplicate entry 'search_min_chars' for key 1

    * DROP TABLE phpbb_flags

      +++ Error: Unknown table 'phpbb_flags'

    * DROP TABLE `phpbb_ctrack`

      +++ Error: Unknown table 'phpbb_ctrack'

    * DROP TABLE `phpbb_ct_filter`

      +++ Error: Unknown table 'phpbb_ct_filter'

    * ALTER TABLE `phpbb_users` DROP `ct_postcount`

      +++ Error: Can't DROP 'ct_postcount'; check that column/key exists

    * ALTER TABLE `phpbb_users` DROP `ct_posttime`

      +++ Error: Can't DROP 'ct_posttime'; check that column/key exists

    * ALTER TABLE `phpbb_users` DROP `ct_searchcount`

      +++ Error: Can't DROP 'ct_searchcount'; check that column/key exists

    * ALTER TABLE `phpbb_users` DROP `ct_searchtime`

      +++ Error: Can't DROP 'ct_searchtime'; check that column/key exists

    * DROP TABLE `phpbb_block_position`

      +++ Error: Unknown table 'phpbb_block_position'

    * DROP TABLE `phpbb_block_variable`

      +++ Error: Unknown table 'phpbb_block_variable'

    * DROP TABLE `phpbb_blocks`

      +++ Error: Unknown table 'phpbb_blocks'

    * DROP TABLE `phpbb_layout`

      +++ Error: Unknown table 'phpbb_layout'

    * DROP TABLE `phpbb_portal_config`

      +++ Error: Unknown table 'phpbb_portal_config'

    * DROP TABLE `phpbb_config_mg`

      +++ Error: Unknown table 'phpbb_config_mg'

    * DROP TABLE `phpbb_color_groups`

      +++ Error: Unknown table 'phpbb_color_groups'

    * ALTER TABLE `phpbb_groups` DROP `group_color_group`

      +++ Error: Can't DROP 'group_color_group'; check that column/key exists

    * ALTER TABLE `phpbb_users` DROP `user_session_topic`

      +++ Error: Can't DROP 'user_session_topic'; check that column/key exists

    * ALTER TABLE `phpbb_sessions` DROP `session_topic`

      +++ Error: Can't DROP 'session_topic'; check that column/key exists

    * ALTER TABLE `phpbb_cms_blocks` ADD `layout_special` int(10) NOT NULL default '0' AFTER `layout`

      +++ Error: Duplicate column name 'layout_special'

    * CREATE TABLE `phpbb_dl_notraf` ( user_id MEDIUMINT(8) NOT NULL DEFAULT 0, dl_id INT(11) NOT NULL DEFAULT 0 )

      +++ Error: Table 'phpbb_dl_notraf' already exists

    * ALTER TABLE `phpbb_cms_layout` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'

      +++ Error: Unknown column 'forum_wide' in 'phpbb_cms_layout'

    * ALTER TABLE `phpbb_cms_layout_special` CHANGE `forum_wide` `global_blocks` TINYINT(1) NOT NULL DEFAULT '0'

      +++ Error: Unknown column 'forum_wide' in 'phpbb_cms_layout_special'

    * INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('link_this_topic', '0')

      +++ Error: Duplicate entry 'link_this_topic' for key 1

    * ALTER TABLE `phpbb_ajax_shoutbox` DROP `shout_uid`

      +++ Error: Can't DROP 'shout_uid'; check that column/key exists

    * ALTER TABLE `phpbb_cms_blocks` DROP `block_bbcode_uid`

      +++ Error: Can't DROP 'block_bbcode_uid'; check that column/key exists

    * ALTER TABLE `phpbb_dl_bug_tracker` DROP `report_uid`

      +++ Error: Can't DROP 'report_uid'; check that column/key exists

    * ALTER TABLE `phpbb_dl_comments` DROP `bbcode_uid`

      +++ Error: Can't DROP 'bbcode_uid'; check that column/key exists

    * ALTER TABLE `phpbb_downloads` DROP `bbcode_uid`

      +++ Error: Can't DROP 'bbcode_uid'; check that column/key exists

    * ALTER TABLE `phpbb_downloads_cat` DROP `bbcode_uid`

      +++ Error: Can't DROP 'bbcode_uid'; check that column/key exists

    * ALTER TABLE `phpbb_kb_articles` DROP `bbcode_uid`

      +++ Error: Can't DROP 'bbcode_uid'; check that column/key exists

    * ALTER TABLE `phpbb_pa_comments` DROP INDEX `comments_id`

      +++ Error: Can't DROP 'comments_id'; check that column/key exists

    * ALTER TABLE `phpbb_pa_comments` DROP INDEX `comment_bbcode_uid`

      +++ Error: Can't DROP 'comment_bbcode_uid'; check that column/key exists

    * ALTER TABLE `phpbb_pa_comments` DROP `comment_bbcode_uid`

      +++ Error: Can't DROP 'comment_bbcode_uid'; check that column/key exists

    * ALTER TABLE `phpbb_shout` DROP `shout_bbcode_uid`

      +++ Error: Can't DROP 'shout_bbcode_uid'; check that column/key exists

    * INSERT INTO `___posts___` SELECT p.post_id, p.topic_id, p.forum_id, p.poster_id, p.post_time, p.poster_ip, p.post_username, t.post_subject, t.post_text, t.post_text_compiled, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, t.edit_notes, p.post_edit_time, p.post_edit_count, p.post_edit_id, p.post_attachment, p.post_bluecard, p.enable_autolinks_acronyms FROM `phpbb_posts` p, `phpbb_posts_text` t WHERE p.post_id = t.post_id ORDER BY p.post_id

      +++ Error: Unknown column 't.post_text_compiled' in 'field list'

    * DROP TABLE `phpbb_optimize_db`

      +++ Error: Unknown table 'phpbb_optimize_db'

    * INSERT INTO `___megamail___` SELECT m.mail_id, m.mailsession_id, 0, m.user_id, m.group_id, m.email_subject, m.email_body, 0, m.batch_start, m.batch_size, m.batch_wait, m.status FROM `phpbb_megamail` m ORDER BY m.mail_id

      +++ Error: Table 'underarc_rama.phpbb_megamail' doesn't exist

    * RENAME TABLE `phpbb_megamail` TO `_old_phpbb_megamail`

      +++ Error: Can't find file: './underarc_rama/phpbb_megamail.frm' (errno: 2)

    * ALTER TABLE `phpbb_cms_blocks` ADD `border` TINYINT(1) SET DEFAULT '1' AFTER `border_explain`

      +++ Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET DEFAULT '1' AFTER `border_explain`' at line 1

    * ALTER TABLE `phpbb_cms_blocks` ADD `titlebar` TINYINT(1) SET DEFAULT '1' AFTER `border`

      +++ Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET DEFAULT '1' AFTER `border`' at line 1

    * UPDATE `phpbb_cms_blocks` SET border= '0' WHERE border_explain= '0,0,0,0'

      +++ Error: Unknown column 'border_explain' in 'where clause'

    * UPDATE `phpbb_cms_blocks` SET border= '1' WHERE border_explain= '1,1,1,1'

      +++ Error: Unknown column 'border_explain' in 'where clause'

    * UPDATE `phpbb_cms_blocks` SET titlebar= '0' WHERE titlebar_explain= '0,0'

      +++ Error: Unknown column 'titlebar_explain' in 'where clause'

    * UPDATE `phpbb_cms_blocks` SET titlebar= '1' WHERE titlebar_explain= '1,1'

      +++ Error: Unknown column 'titlebar_explain' in 'where clause'

    * ALTER TABLE phpbb_registration_desc DROP `reg_option1`

      +++ Error: Can't DROP 'reg_option1'; check that column/key exists

    * ALTER TABLE phpbb_registration_desc DROP `reg_option2`

      +++ Error: Can't DROP 'reg_option2'; check that column/key exists

    * ALTER TABLE phpbb_registration_desc DROP `reg_option3`

      +++ Error: Can't DROP 'reg_option3'; check that column/key exists

    * ALTER TABLE `phpbb_cms_layout_special` ADD `page_id` varchar(100) NOT NULL DEFAULT '' AFTER `lsid`

      +++ Error: Duplicate column name 'page_id'

    * ALTER TABLE `phpbb_cms_layout_special` ADD `locked` tinyint(1) NOT NULL DEFAULT '1' AFTER `page_id`

      +++ Error: Duplicate column name 'locked'

The following SQL have been executed successfully:

Spoiler: [ Show ]

Spoiler: [ Hide ]

    * ALTER TABLE phpbb_config CHANGE `config_value` `config_value` TEXT NOT NULL

      +++ Successful

    * CREATE TABLE `phpbb_acronyms` ( `acronym_id` mediumint(9) NOT NULL auto_increment, `acronym` varchar(80) NOT NULL default '', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`acronym_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_adminedit` ( `edit_id` mediumint(8) unsigned NOT NULL auto_increment, `edituser` char(100) NOT NULL default '', `editok` char(100) NOT NULL default '', PRIMARY KEY (`edit_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_album` ( `pic_id` int(11) unsigned NOT NULL auto_increment, `pic_filename` varchar(255) NOT NULL default '', `pic_thumbnail` varchar(255) NULL default '', `pic_title` varchar(255) NOT NULL default '', `pic_desc` text, `pic_user_id` mediumint(8) NOT NULL default '0', `pic_username` varchar(32) NULL default '', `pic_user_ip` varchar(8) NOT NULL default '0', `pic_time` int(11) unsigned NOT NULL default '0', `pic_cat_id` mediumint(8) unsigned NOT NULL default '1', `pic_view_count` int(11) unsigned NOT NULL default '0', `pic_lock` tinyint(3) NOT NULL default '0', `pic_approval` tinyint(3) NOT NULL default '1', PRIMARY KEY (`pic_id`), KEY `pic_cat_id` (`pic_cat_id`), KEY `pic_user_id` (`pic_user_id`), KEY `pic_time` (`pic_time`) )

      +++ Successful

    * CREATE TABLE `phpbb_album_cat` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(255) NOT NULL default '', `cat_desc` text, `cat_order` mediumint(8) NOT NULL default '0', `cat_view_level` tinyint(3) NOT NULL default '-1', `cat_upload_level` tinyint(3) NOT NULL default '0', `cat_rate_level` tinyint(3) NOT NULL default '0', `cat_comment_level` tinyint(3) NOT NULL default '0', `cat_edit_level` tinyint(3) NOT NULL default '0', `cat_delete_level` tinyint(3) NOT NULL default '2', `cat_view_groups` varchar(255) NULL default '', `cat_upload_groups` varchar(255) NULL default '', `cat_rate_groups` varchar(255) NULL default '', `cat_comment_groups` varchar(255) NULL default '', `cat_edit_groups` varchar(255) NULL default '', `cat_delete_groups` varchar(255) NULL default '', `cat_moderator_groups` varchar(255) NULL default '', `cat_approval` tinyint(3) NOT NULL default '0', `cat_parent` mediumint(8) unsigned default '0', `cat_user_id` mediumint(8) unsigned default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) )

      +++ Successful

    * CREATE TABLE `phpbb_album_comment` ( `comment_id` int(11) unsigned NOT NULL auto_increment, `comment_pic_id` int(11) unsigned NOT NULL default '0', `comment_cat_id` int(11) NOT NULL default '0', `comment_user_id` mediumint(8) NOT NULL default '0', `comment_username` varchar(32) default '', `comment_user_ip` varchar(8) NOT NULL default '', `comment_time` int(11) unsigned NOT NULL default '0', `comment_text` text, `comment_edit_time` int(11) unsigned default NULL, `comment_edit_count` smallint(5) unsigned NOT NULL default '0', `comment_edit_user_id` mediumint(8) default NULL, PRIMARY KEY (`comment_id`), KEY `comment_pic_id` (`comment_pic_id`), KEY `comment_user_id` (`comment_user_id`), KEY `comment_user_ip` (`comment_user_ip`), KEY `comment_time` (`comment_time`) )

      +++ Successful

    * CREATE TABLE `phpbb_album_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )

      +++ Successful

    * CREATE TABLE `phpbb_album_rate` ( `rate_pic_id` int(11) unsigned NOT NULL default '0', `rate_user_id` mediumint(8) NOT NULL default '0', `rate_user_ip` char(8) NOT NULL default '', `rate_point` tinyint(3) unsigned NOT NULL default '0', `rate_hon_point` tinyint(3) NOT NULL default '0', KEY `rate_pic_id` (`rate_pic_id`), KEY `rate_user_id` (`rate_user_id`), KEY `rate_user_ip` (`rate_user_ip`), KEY `rate_point` (`rate_point`) )

      +++ Successful

    * CREATE TABLE phpbb_attachments_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) )

      +++ Successful

    * CREATE TABLE phpbb_forbidden_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, extension varchar(100) NOT NULL, PRIMARY KEY (ext_id) )

      +++ Successful

    * CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, cat_id tinyint(2) DEFAULT '0' NOT NULL, allow_group tinyint(1) DEFAULT '0' NOT NULL, download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, upload_icon varchar(100) DEFAULT '', max_filesize int(20) DEFAULT '0' NOT NULL, forum_permissions varchar(255) default '' NOT NULL, PRIMARY KEY group_id (group_id) )

      +++ Successful

    * CREATE TABLE phpbb_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, extension varchar(100) NOT NULL, comment varchar(100), PRIMARY KEY ext_id (ext_id) )

      +++ Successful

    * CREATE TABLE phpbb_attachments_desc ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, physical_filename varchar(255) NOT NULL, real_filename varchar(255) NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, comment varchar(255), extension varchar(100), mimetype varchar(100), filesize int(20) NOT NULL, filetime int(11) DEFAULT '0' NOT NULL, thumbnail tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY physical_filename (physical_filename(10)), KEY filesize (filesize) )

      +++ Successful

    * CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id_1 mediumint(8) NOT NULL, user_id_2 mediumint(8) NOT NULL, KEY attach_id_post_id (attach_id, post_id), KEY attach_id_privmsgs_id (attach_id, privmsgs_id), KEY post_id (post_id), KEY privmsgs_id (privmsgs_id) )

      +++ Successful

    * CREATE TABLE phpbb_quota_limits ( quota_limit_id mediumint(8) unsigned NOT NULL auto_increment, quota_desc varchar(20) NOT NULL default '', quota_limit bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (quota_limit_id) )

      +++ Successful

    * CREATE TABLE phpbb_attach_quota ( user_id mediumint(8) unsigned NOT NULL default '0', group_id mediumint(8) unsigned NOT NULL default '0', quota_type smallint(2) NOT NULL default '0', quota_limit_id mediumint(8) unsigned NOT NULL default '0', KEY quota_type (quota_type) )

      +++ Successful

    * ALTER TABLE phpbb_forums ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE phpbb_auth_access ADD auth_download TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE phpbb_posts ADD post_attachment TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE phpbb_topics ADD topic_attachment TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * CREATE TABLE `phpbb_autolinks` ( `link_id` mediumint(5) unsigned NOT NULL auto_increment, `link_keyword` varchar(50) NOT NULL default '', `link_title` varchar(50) NOT NULL default '', `link_url` varchar(200) NOT NULL default '', `link_comment` varchar(200) NOT NULL default '', `link_style` varchar(200) NOT NULL default '', `link_forum` tinyint(1) NOT NULL default '0', `link_int` tinyint(1) NOT NULL default '0', KEY `link_id` (`link_id`) )

      +++ Successful

    * ALTER TABLE phpbb_forums ADD auth_globalannounce TINYINT (2) DEFAULT '3' NOT NULL AFTER auth_announce

      +++ Successful

    * ALTER TABLE phpbb_auth_access ADD auth_globalannounce TINYINT (1) not null AFTER auth_announce

      +++ Successful

    * ALTER TABLE phpbb_auth_access ADD `auth_ban` tinyint(1) NOT NULL default '0'

      +++ Successful

    * ALTER TABLE phpbb_auth_access ADD `auth_greencard` tinyint(1) NOT NULL default '0'

      +++ Successful

    * ALTER TABLE phpbb_auth_access ADD `auth_bluecard` tinyint(1) NOT NULL default '0'

      +++ Successful

    * ALTER TABLE phpbb_auth_access ADD `auth_rate` tinyint(1) NOT NULL default '0'

      +++ Successful

    * ALTER TABLE phpbb_auth_access ADD `auth_news` tinyint(1) NOT NULL default '0'

      +++ Successful

    * ALTER TABLE phpbb_auth_access ADD `auth_cal` tinyint(1) NOT NULL default '0'

      +++ Successful

    * ALTER TABLE `phpbb_banlist` ADD `ban_time` INT(11) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_banlist` ADD `ban_expire_time` INT(11) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_banlist` ADD `ban_by_userid` MEDIUMINT(8) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_banlist` ADD `ban_priv_reason` TEXT DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_banlist` ADD `ban_pub_reason_mode` TINYINT(1) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_banlist` ADD `ban_pub_reason` TEXT DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_categories` ADD `cat_main_type` CHAR(1) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_categories` ADD `cat_main` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_categories` ADD `cat_desc` TEXT NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_categories` ADD `icon` VARCHAR(255) DEFAULT NULL

      +++ Successful

    * CREATE TABLE `phpbb_force_read` ( `topic_number` int(25) NOT NULL default '0', `message` text NOT NULL, `install_date` int(15) NOT NULL default '0', `active` tinyint(2) NOT NULL default '1', `effected` tinyint(1) NOT NULL default '1' )

      +++ Successful

    * CREATE TABLE `phpbb_force_read_users` ( `user` varchar(255) NOT NULL default '', `read` int(1) NOT NULL default '0', `time` int(10) NOT NULL default '0' )

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `thank` TINYINT(1) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `forum_notify` TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `forum_link` VARCHAR(255) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `forum_link_internal` TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `forum_link_hit_count` TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `forum_link_hit` BIGINT(20) UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `icon` VARCHAR(255) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `main_type` CHAR(1) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `auth_news` TINYINT(2) DEFAULT '2' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `auth_cal` TINYINT(2) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `auth_ban` TINYINT(2) DEFAULT '3' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `auth_greencard` TINYINT(2) DEFAULT '5' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `auth_bluecard` TINYINT(2) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `auth_rate` TINYINT(2) DEFAULT '-1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `forum_rules` TEXT NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `rules_display_title` TINYINT(1) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `rules_custom_title` VARCHAR(80) NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `rules_in_viewforum` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `rules_in_viewtopic` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_forums` ADD `rules_in_posting` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * CREATE TABLE `phpbb_forums_watch` ( `forum_id` smallint(5) unsigned NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `notify_status` tinyint(1) NOT NULL default '0', KEY `forum_id` (`forum_id`), KEY `user_id` (`user_id`), KEY `notify_status` (`notify_status`) )

      +++ Successful

    * CREATE TABLE `phpbb_google_bot_detector` ( `detect_id` int(8) NOT NULL auto_increment, `detect_time` int(11) NOT NULL default '0', `detect_url` varchar(255) NOT NULL default '', PRIMARY KEY (`detect_id`) )

      +++ Successful

    * ALTER TABLE `phpbb_groups` ADD `group_count` INT(4) UNSIGNED DEFAULT '99999999'

      +++ Successful

    * ALTER TABLE `phpbb_groups` ADD `group_count_max` INT(4) UNSIGNED DEFAULT '99999999'

      +++ Successful

    * ALTER TABLE `phpbb_groups` ADD `group_count_enable` SMALLINT(2) UNSIGNED DEFAULT '0'

      +++ Successful

    * CREATE TABLE `phpbb_hacks_list` ( `hack_id` mediumint(8) unsigned NOT NULL auto_increment, `hack_name` varchar(255) NOT NULL default '', `hack_desc` varchar(255) NOT NULL default '', `hack_author` varchar(255) NOT NULL default '', `hack_author_email` varchar(255) NOT NULL default '', `hack_author_website` tinytext NOT NULL, `hack_version` varchar(32) NOT NULL default '', `hack_hide` enum('Yes','No') NOT NULL default 'No', `hack_download_url` tinytext NOT NULL, `hack_file` varchar(255) NOT NULL default '', `hack_file_mtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`hack_id`), UNIQUE KEY `hack_name` (`hack_name`), KEY `hack_file` (`hack_file`), KEY `hack_hide` (`hack_hide`) )

      +++ Successful

    * CREATE TABLE `phpbb_jr_admin_users` ( `user_id` mediumint(9) NOT NULL default '0', `user_jr_admin` longtext NOT NULL, `start_date` int(10) unsigned NOT NULL default '0', `update_date` int(10) unsigned NOT NULL default '0', `admin_notes` text NOT NULL, `notes_view` tinyint(1) NOT NULL default '0', PRIMARY KEY (`user_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_articles` ( `article_id` mediumint(8) unsigned NOT NULL auto_increment, `article_category_id` mediumint(8) unsigned NOT NULL default '0', `article_title` varchar(255) binary NOT NULL default '', `article_description` varchar(255) binary NOT NULL default '', `article_date` varchar(255) binary NOT NULL default '', `article_author_id` mediumint(8) NOT NULL default '0', `username` varchar(255) default NULL, `article_body` text NOT NULL, `article_type` mediumint(8) unsigned NOT NULL default '0', `approved` tinyint(1) unsigned NOT NULL default '0', `topic_id` mediumint(8) unsigned NOT NULL default '0', `views` bigint(8) NOT NULL default '0', `article_rating` double(6,4) NOT NULL default '0.0000', `article_totalvotes` int(255) NOT NULL default '0', KEY `article_id` (`article_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_categories` ( `category_id` mediumint(8) unsigned NOT NULL auto_increment, `category_name` varchar(255) binary NOT NULL default '', `category_details` varchar(255) binary NOT NULL default '', `number_articles` mediumint(8) unsigned NOT NULL default '0', `parent` mediumint(8) unsigned default NULL, `cat_order` mediumint(8) unsigned NOT NULL default '0', `auth_view` tinyint(3) NOT NULL default '0', `auth_post` tinyint(3) NOT NULL default '0', `auth_rate` tinyint(3) NOT NULL default '0', `auth_comment` tinyint(3) NOT NULL default '0', `auth_edit` tinyint(3) NOT NULL default '0', `auth_delete` tinyint(3) NOT NULL default '2', `auth_approval` tinyint(3) NOT NULL default '0', `auth_approval_edit` tinyint(3) NOT NULL default '0', `auth_view_groups` varchar(255) default NULL, `auth_post_groups` varchar(255) default NULL, `auth_rate_groups` varchar(255) default NULL, `auth_comment_groups` varchar(255) default NULL, `auth_edit_groups` varchar(255) default NULL, `auth_delete_groups` varchar(255) default NULL, `auth_approval_groups` varchar(255) default NULL, `auth_approval_edit_groups` varchar(255) default NULL, `auth_moderator_groups` varchar(255) default NULL, `comments_forum_id` tinyint(3) NOT NULL default '-1', KEY `category_id` (`category_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_custom` ( `custom_id` int(50) NOT NULL auto_increment, `custom_name` text NOT NULL, `custom_description` text NOT NULL, `data` text NOT NULL, `field_order` int(20) NOT NULL default '0', `field_type` tinyint(2) NOT NULL default '0', `regex` varchar(255) NOT NULL default '', PRIMARY KEY (`custom_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_customdata` ( `customdata_file` int(50) NOT NULL default '0', `customdata_custom` int(50) NOT NULL default '0', `data` text NOT NULL )

      +++ Successful

    * CREATE TABLE `phpbb_kb_results` ( `search_id` int(11) unsigned NOT NULL default '0', `session_id` varchar(32) NOT NULL default '', `search_array` text NOT NULL, PRIMARY KEY (`search_id`), KEY `session_id` (`session_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_search` ( `search_id` int(11) unsigned NOT NULL default '0', `session_id` varchar(32) NOT NULL default '', `search_array` text NOT NULL, PRIMARY KEY (`search_id`), KEY `session_id` (`session_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_types` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `type` varchar(255) binary NOT NULL default '', KEY `id` (`id`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_votes` ( `votes_ip` varchar(50) NOT NULL default '0', `votes_userid` int(50) NOT NULL default '0', `votes_file` int(50) NOT NULL default '0' )

      +++ Successful

    * CREATE TABLE `phpbb_kb_wordlist` ( `word_text` varchar(50) binary NOT NULL default '', `word_id` mediumint(8) unsigned NOT NULL auto_increment, `word_common` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`word_text`), KEY `word_id` (`word_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_kb_wordmatch` ( `article_id` mediumint(8) unsigned NOT NULL default '0', `word_id` mediumint(8) unsigned NOT NULL default '0', `title_match` tinyint(1) NOT NULL default '0', KEY `post_id` (`article_id`), KEY `word_id` (`word_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_link_categories` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(100) NOT NULL default '', `cat_order` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) )

      +++ Successful

    * CREATE TABLE `phpbb_link_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '' )

      +++ Successful

    * CREATE TABLE `phpbb_links` ( `link_id` mediumint(8) unsigned NOT NULL auto_increment, `link_title` varchar(100) NOT NULL default '', `link_desc` varchar(255) default NULL, `link_category` mediumint(8) unsigned NOT NULL default '0', `link_url` varchar(100) NOT NULL default '', `link_logo_src` varchar(120) default NULL, `link_joined` int(11) NOT NULL default '0', `link_active` tinyint(1) NOT NULL default '0', `link_hits` int(10) unsigned NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `user_ip` varchar(8) NOT NULL default '', `last_user_ip` varchar(8) NOT NULL default '', PRIMARY KEY (`link_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_liw_cache` ( `image_checksum` varchar(32) NOT NULL default '', `image_width` varchar(10) default NULL, `image_height` varchar(10) default NULL, PRIMARY KEY (`image_checksum`) )

      +++ Successful

    * CREATE TABLE `phpbb_logins` ( `login_id` mediumint(8) unsigned NOT NULL auto_increment, `login_userid` mediumint(8) NOT NULL default '0', `login_ip` varchar(8) NOT NULL default '0', `login_user_agent` varchar(255) NOT NULL default 'n/a', `login_time` int(11) NOT NULL default '0', PRIMARY KEY (`login_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_news` ( `news_id` mediumint(8) unsigned NOT NULL auto_increment, `news_category` varchar(70) NOT NULL default '', `news_image` varchar(70) NOT NULL default '', PRIMARY KEY (`news_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_notes` ( `id` int(8) NOT NULL default '0', `text` text )

      +++ Successful

    * CREATE TABLE `phpbb_pa_auth` ( `group_id` mediumint(8) NOT NULL default '0', `cat_id` smallint(5) unsigned NOT NULL default '0', `auth_view` tinyint(1) NOT NULL default '0', `auth_read` tinyint(1) NOT NULL default '0', `auth_view_file` tinyint(1) NOT NULL default '0', `auth_edit_file` tinyint(1) NOT NULL default '0', `auth_delete_file` tinyint(1) NOT NULL default '0', `auth_upload` tinyint(1) NOT NULL default '0', `auth_download` tinyint(1) NOT NULL default '0', `auth_rate` tinyint(1) NOT NULL default '0', `auth_email` tinyint(1) NOT NULL default '0', `auth_view_comment` tinyint(1) NOT NULL default '0', `auth_post_comment` tinyint(1) NOT NULL default '0', `auth_edit_comment` tinyint(1) NOT NULL default '0', `auth_delete_comment` tinyint(1) NOT NULL default '0', `auth_mod` tinyint(1) NOT NULL default '0', `auth_search` tinyint(1) NOT NULL default '1', `auth_stats` tinyint(1) NOT NULL default '1', `auth_toplist` tinyint(1) NOT NULL default '1', `auth_viewall` tinyint(1) NOT NULL default '1', KEY `group_id` (`group_id`), KEY `cat_id` (`cat_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_pa_cat` ( `cat_id` int(10) NOT NULL auto_increment, `cat_name` text, `cat_desc` text, `cat_parent` int(50) default NULL, `parents_data` text NOT NULL, `cat_order` int(50) default NULL, `cat_allow_file` tinyint(2) NOT NULL default '0', `cat_allow_ratings` tinyint(2) NOT NULL default '1', `cat_allow_comments` tinyint(2) NOT NULL default '1', `cat_files` mediumint(8) NOT NULL default '-1', `cat_last_file_id` mediumint(8) unsigned NOT NULL default '0', `cat_last_file_name` varchar(255) NOT NULL default '', `cat_last_file_time` int(50) unsigned NOT NULL default '0', `auth_view` tinyint(2) NOT NULL default '0', `auth_read` tinyint(2) NOT NULL default '0', `auth_view_file` tinyint(2) NOT NULL default '0', `auth_edit_file` tinyint(1) NOT NULL default '0', `auth_delete_file` tinyint(1) NOT NULL default '0', `auth_upload` tinyint(2) NOT NULL default '0', `auth_download` tinyint(2) NOT NULL default '0', `auth_rate` tinyint(2) NOT NULL default '0', `auth_email` tinyint(2) NOT NULL default '0', `auth_view_comment` tinyint(2) NOT NULL default '0', `auth_post_comment` tinyint(2) NOT NULL default '0', `auth_edit_comment` tinyint(2) NOT NULL default '0', `auth_delete_comment` tinyint(2) NOT NULL default '0', PRIMARY KEY (`cat_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_pa_comments` ( `comments_id` int(10) NOT NULL auto_increment, `file_id` int(10) NOT NULL default '0', `comments_text` text NOT NULL, `comments_title` text NOT NULL, `comments_time` int(50) NOT NULL default '0', `poster_id` mediumint(8) NOT NULL default '0', PRIMARY KEY (`comments_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_pa_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )

      +++ Successful

    * CREATE TABLE `phpbb_pa_custom` ( `custom_id` int(50) NOT NULL auto_increment, `custom_name` text NOT NULL, `custom_description` text NOT NULL, `data` text NOT NULL, `field_order` int(20) NOT NULL default '0', `field_type` tinyint(2) NOT NULL default '0', `regex` varchar(255) NOT NULL default '', PRIMARY KEY (`custom_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_pa_customdata` ( `customdata_file` int(50) NOT NULL default '0', `customdata_custom` int(50) NOT NULL default '0', `data` text NOT NULL )

      +++ Successful

    * CREATE TABLE `phpbb_pa_download_info` ( `file_id` mediumint(8) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `downloader_ip` varchar(8) NOT NULL default '', `downloader_os` varchar(255) NOT NULL default '', `downloader_browser` varchar(255) NOT NULL default '', `browser_version` varchar(255) NOT NULL default '' )

      +++ Successful

    * CREATE TABLE `phpbb_pa_files` ( `file_id` int(10) NOT NULL auto_increment, `user_id` mediumint(8) NOT NULL default '0', `poster_ip` varchar(8) NOT NULL default '', `file_name` text, `file_size` int(20) NOT NULL default '0', `unique_name` varchar(255) NOT NULL default '', `real_name` varchar(255) NOT NULL default '', `file_dir` varchar(255) NOT NULL default '', `file_desc` text, `file_creator` text, `file_version` text, `file_longdesc` text, `file_ssurl` text, `file_sshot_link` tinyint(2) NOT NULL default '0', `file_dlurl` text, `file_time` int(50) default NULL, `file_update_time` int(50) NOT NULL default '0', `file_catid` int(10) default NULL, `file_posticon` text, `file_license` int(10) default NULL, `file_dls` int(10) default NULL, `file_last` int(50) default NULL, `file_pin` int(2) default NULL, `file_docsurl` text, `file_approved` tinyint(1) NOT NULL default '1', `file_broken` tinyint(1) NOT NULL default '0', PRIMARY KEY (`file_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_pa_license` ( `license_id` int(10) NOT NULL auto_increment, `license_name` text, `license_text` text, PRIMARY KEY (`license_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_pa_mirrors` ( `mirror_id` mediumint(8) NOT NULL auto_increment, `file_id` int(10) NOT NULL default '0', `unique_name` varchar(255) NOT NULL default '', `file_dir` varchar(255) NOT NULL default '', `file_dlurl` varchar(255) NOT NULL default '', `mirror_location` varchar(255) NOT NULL default '', PRIMARY KEY (`mirror_id`), KEY `file_id` (`file_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_pa_votes` ( `user_id` mediumint(8) NOT NULL default '0', `votes_ip` varchar(50) NOT NULL default '0', `votes_file` int(50) NOT NULL default '0', `rate_point` tinyint(3) unsigned NOT NULL default '0', `voter_os` varchar(255) NOT NULL default '', `voter_browser` varchar(255) NOT NULL default '', `browser_version` varchar(8) NOT NULL default '', KEY `user_id` (`user_id`) )

      +++ Successful

    * ALTER TABLE `phpbb_posts` ADD `post_bluecard` TINYINT(1) DEFAULT NULL

      +++ Successful

    * CREATE TABLE `phpbb_privmsgs_archive` ( `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment, `privmsgs_type` tinyint(4) NOT NULL default '0', `privmsgs_subject` varchar(255) NOT NULL default '0', `privmsgs_from_userid` mediumint(8) NOT NULL default '0', `privmsgs_to_userid` mediumint(8) NOT NULL default '0', `privmsgs_date` int(11) NOT NULL default '0', `privmsgs_ip` varchar(8) NOT NULL default '', `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1', `privmsgs_enable_html` tinyint(1) NOT NULL default '0', `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1', `privmsgs_attach_sig` tinyint(1) NOT NULL default '1', `privmsgs_attachment` tinyint(1) NOT NULL default '0', `privmsgs_enable_autolinks_acronyms` tinyint(1) NOT NULL default '0', PRIMARY KEY (`privmsgs_id`), KEY `privmsgs_from_userid` (`privmsgs_from_userid`), KEY `privmsgs_to_userid` (`privmsgs_to_userid`) )

      +++ Successful

    * CREATE TABLE `phpbb_profile_view` ( `user_id` mediumint(8) NOT NULL default '0', `viewername` varchar(25) NOT NULL default '', `viewer_id` mediumint(8) NOT NULL default '0', `view_stamp` int(11) NOT NULL default '0', `counter` mediumint(8) NOT NULL default '0' )

      +++ Successful

    * CREATE TABLE `phpbb_rate_results` ( `rating_id` mediumint(8) unsigned NOT NULL auto_increment, `user_id` mediumint(8) unsigned NOT NULL default '0', `topic_id` mediumint(8) unsigned NOT NULL default '0', `rating` mediumint(8) unsigned NOT NULL default '0', `user_ip` char(8) NOT NULL default '', `rating_time` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`rating_id`), KEY `topic_id` (`topic_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_referrers` ( `referrer_id` int(11) NOT NULL auto_increment, `referrer_host` varchar(255) NOT NULL default '', `referrer_url` varchar(255) NOT NULL default '', `referrer_ip` varchar(8) NOT NULL default '', `referrer_hits` int(11) NOT NULL default '1', `referrer_firstvisit` int(11) NOT NULL default '0', `referrer_lastvisit` int(11) NOT NULL default '0', PRIMARY KEY (`referrer_id`) )

      +++ Successful

    * ALTER TABLE `phpbb_sessions` ADD `session_user_agent` VARCHAR(255) NOT NULL

      +++ Successful

    * CREATE TABLE `phpbb_shout` ( `shout_id` mediumint(8) unsigned NOT NULL auto_increment, `shout_username` varchar(25) NOT NULL default '', `shout_user_id` mediumint(8) NOT NULL default '0', `shout_group_id` mediumint(8) NOT NULL default '0', `shout_session_time` int(11) NOT NULL default '0', `shout_ip` varchar(8) NOT NULL default '', `shout_text` text NOT NULL, `shout_active` mediumint(8) NOT NULL default '0', `enable_bbcode` tinyint(1) NOT NULL default '0', `enable_html` tinyint(1) NOT NULL default '0', `enable_smilies` tinyint(1) NOT NULL default '0', `enable_sig` tinyint(1) NOT NULL default '0', KEY `shout_id` (`shout_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_site_history` ( `date` int(11) NOT NULL default '0', `reg` mediumint(8) NOT NULL default '0', `hidden` mediumint(8) NOT NULL default '0', `guests` mediumint(8) NOT NULL default '0', `new_topics` mediumint(8) NOT NULL default '0', `new_posts` mediumint(8) NOT NULL default '0', UNIQUE KEY `date` (`date`) )

      +++ Successful

    * CREATE TABLE `phpbb_stats_config` ( `config_name` varchar(50) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )

      +++ Successful

    * CREATE TABLE `phpbb_stats_modules` ( `module_id` tinyint(8) NOT NULL default '0', `name` varchar(150) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', `installed` tinyint(1) NOT NULL default '0', `display_order` mediumint(8) unsigned NOT NULL default '0', `update_time` mediumint(8) unsigned NOT NULL default '0', `auth_value` tinyint(2) NOT NULL default '0', `module_info_cache` blob, `module_db_cache` blob, `module_result_cache` blob, `module_info_time` int(10) unsigned NOT NULL default '0', `module_cache_time` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`module_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_thanks` ( `topic_id` mediumint(8) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `thanks_time` int(11) NOT NULL default '0' )

      +++ Successful

    * CREATE TABLE `phpbb_title_infos` ( `id` int(11) NOT NULL auto_increment, `title_info` varchar(255) NOT NULL default '', `date_format` varchar(25) default NULL, `admin_auth` tinyint(1) default '0', `mod_auth` tinyint(1) default '0', `poster_auth` tinyint(1) default '0', UNIQUE KEY `id` (`id`) )

      +++ Successful

    * CREATE TABLE `phpbb_topic_view` ( `topic_id` mediumint(8) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `view_time` int(11) NOT NULL default '0', `view_count` int(11) NOT NULL default '0' )

      +++ Successful

    * ALTER TABLE `phpbb_topics` ADD `topic_desc` VARCHAR(255)

      +++ Successful

    * ALTER TABLE `phpbb_topics` ADD `title_compl_infos` VARCHAR(255) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_topics` ADD `news_id` INT(10) UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_topics` ADD `topic_calendar_time` INT(11) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_topics` ADD `topic_calendar_duration` INT(11) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_topics` ADD `topic_rating` DOUBLE UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_http_agents` VARCHAR(255) NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_rank2` INT(11) DEFAULT '-1'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_rank3` INT(11) DEFAULT '-2'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_rank4` INT(11) DEFAULT '-2'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_rank5` INT(11) DEFAULT '-2'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `ct_search` VARCHAR(10) NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_birthday` INT(11) DEFAULT '999999' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_next_birthday_greeting` INT(11) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_sub_forum` TINYINT(1) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_split_cat` TINYINT(1) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_last_topic_title` TINYINT(1) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_sub_level_links` TINYINT(1) DEFAULT '2' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_display_viewonline` TINYINT(1) DEFAULT '2' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_color_group` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_gender` TINYINT(4) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_lastlogon` INT(11) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_totaltime` INT(11) DEFAULT '0'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_totallogon` INT(11) DEFAULT '0'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_totalpages` INT(11) DEFAULT '0'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_calendar_display_open` TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_calendar_header_cells` TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_calendar_week_start` TINYINT(1) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_calendar_nb_row` TINYINT(2) UNSIGNED DEFAULT '5' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_calendar_birthday` TINYINT(1) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_calendar_forum` TINYINT(1) DEFAULT '1' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_warnings` SMALLINT(5) DEFAULT '0'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_time_mode` TINYINT(4) DEFAULT '5' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_dst_time_lag` TINYINT(4) DEFAULT '60' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_pc_timeOffsets` VARCHAR(11) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_skype` VARCHAR(255) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_registered_ip` VARCHAR(8) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_registered_hostname` VARCHAR(255) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_profile_view` SMALLINT(5) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_last_profile_view` INT(11) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_topics_per_page` VARCHAR(5) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_hot_threshold` VARCHAR(5) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_posts_per_page` VARCHAR(5) DEFAULT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_allowswearywords` TINYINT(1) DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_showavatars` TINYINT(1) DEFAULT '1'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_showsignatures` TINYINT(1) DEFAULT '1'

      +++ Successful

    * ALTER TABLE `phpbb_users` ADD `user_profile_view_popup` TINYINT(1) DEFAULT '0'

      +++ Successful

    * ALTER TABLE `phpbb_vote_voters` ADD `vote_cast` TINYINT(4) UNSIGNED DEFAULT '0' NOT NULL

      +++ Successful

    * ALTER TABLE phpbb_users ADD ct_mailcount INT(10) NOT NULL AFTER user_newpasswd

      +++ Successful

    * ALTER TABLE phpbb_users ADD ct_pwreset INT(2) NOT NULL AFTER user_newpasswd

      +++ Successful

    * ALTER TABLE phpbb_users ADD ct_unsucclogin INT(10) DEFAULT NULL AFTER user_newpasswd

      +++ Successful

    * ALTER TABLE phpbb_users ADD ct_logintry INT(2) DEFAULT 0 AFTER user_newpasswd

      +++ Successful

    * CREATE TABLE phpbb_ct_viskey ( confirm_id char(32) NOT NULL default '', session_id char(32) NOT NULL default '', code char(6) NOT NULL default '', PRIMARY KEY (session_id,confirm_id))

      +++ Successful

    * CREATE TABLE `phpbb_xs_news` ( `news_id` mediumint(8) unsigned NOT NULL auto_increment, `news_date` int(11) NOT NULL default '0', `news_text` text NOT NULL, `news_display` tinyint(1) NOT NULL default '1', `news_smilies` tinyint(1) NOT NULL default '0', PRIMARY KEY (`news_id`) )

      +++ Successful

    * CREATE TABLE `phpbb_xs_news_cfg` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) )

      +++ Successful

    * CREATE TABLE `phpbb_xs_news_xml` ( `xml_id` mediumint(8) NOT NULL auto_increment, `xml_title` varchar(255) NOT NULL default '', `xml_show` tinyint(1) NOT NULL default '0', `xml_feed` text NOT NULL, `xml_is_feed` tinyint(1) NOT NULL default '1', `xml_width` varchar(4) NOT NULL default '98%', `xml_height` char(3) NOT NULL default '20', `xml_font` char(3) NOT NULL default '0', `xml_speed` char(2) NOT NULL default '3', `xml_direction` tinyint(1) NOT NULL default '0', PRIMARY KEY (`xml_id`) )

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_pics', '1024')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('user_pics_limit', '-1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('mod_pics_limit', '-1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_file_size', '128000')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_width', '1024')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_height', '768')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('rows_per_page', '5')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('cols_per_page', '4')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('fullpic_popup', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('thumbnail_quality', '75')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('thumbnail_size', '125')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('thumbnail_cache', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('sort_method', 'pic_time')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('sort_order', 'DESC')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('jpg_allowed', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('png_allowed', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('gif_allowed', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('desc_length', '512')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('hotlink_prevent', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('hotlink_allowed', 'mightygorgon.com,icyphoenix.com')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_gallery', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_private', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_limit', '-1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_gallery_view', '-1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('rate', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('rate_scale', '10')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('comment', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('gd_version', '2')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('album_version', '.0.56')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('fap_version', '1.2.4')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_thumb', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_total_pics', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_total_comments', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_comments', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_last_comment', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_pics', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_recent_in_subcats', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_recent_instead_of_nopics', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('line_break_subcats', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_subcats', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_allow_gallery_mod', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_allow_sub_categories', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_sub_category_limit', '-1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_show_subcats_in_index', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_in_subcats', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_show_recent_instead_of_nopics', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_personal_gallery_link', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting', 'cat_order')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('album_category_sorting_direction', 'ASC')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('album_debug_mode', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_all_in_personal_gallery', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('new_pic_check_interval', '1M')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('index_enable_supercells', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('email_notification', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_download', '2')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_slideshow', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_pic_size_on_thumb', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('hon_rate_users', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('hon_rate_where', '')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('hon_rate_sep', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('hon_rate_times', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('disp_watermark_at', '3')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('wut_users', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('use_watermark', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('rate_type', '2')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('disp_rand', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('disp_mostv', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('disp_high', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('disp_late', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('img_cols', '4')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('img_rows', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('midthumb_use', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('midthumb_height', '450')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('midthumb_width', '600')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('midthumb_cache', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_files_to_upload', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_pregenerated_fields', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('dynamic_fields', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('pregenerate_fields', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('propercase_pic_title', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_index_last_pic_lv', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_pics_approval', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_img_no_gd', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('dynamic_pic_resampling', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_file_size_resampling', '1024000')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('switch_nuffload', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('path_to_bin', './cgi-bin/')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('perl_uploader', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_progress_bar', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('close_on_finish', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_pause', '5')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('simple_format', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('multiple_uploads', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('max_uploads', '5')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('zip_uploads', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('resize_pic', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('resize_width', '600')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('resize_height', '600')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('resize_quality', '70')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_pics_nav', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_inline_copyright', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('enable_nuffimage', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('enable_sepia_bw', '0')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('personal_allow_avatar_gallery', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('show_gif_mid_thumb', '1')

      +++ Successful

    * INSERT INTO `phpbb_album_config` VALUES ('slideshow_script', '0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir','files')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_img','images/attach_post.png')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('topic_icon','images/disk_multiple.png')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('display_order','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize','262144')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_quota','52428800')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize_pm','262144')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments','3')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments_pm','1')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('disable_mod','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_pm_attach','1')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_topic_review','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_ftp_upload','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('show_apcp','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attach_version','2.4.0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_upload_quota', '0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_pm_quota', '0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_server','')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_path','')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('download_path','')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_user','')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pass','')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pasv_mode','1')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_display_inlined','1')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_width','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_height','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_width','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_height','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_create_thumbnail','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_min_thumb_filesize','12000')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_imagick', '')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('use_gd2','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('wma_autoplay','0')

      +++ Successful

    * INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('flash_autoplay','0')

      +++ Successful

    * INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php')

      +++ Successful

    * INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3')

      +++ Successful

    * INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4')

      +++ Successful

    * INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml')

      +++ Successful

    * INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl')

      +++ Successful

    * INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp')

      +++ Successful

    * INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi')

      +++ Successful

    * INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (1,'Images',1,1,1,'',0,'')

      +++ Successful

    * INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (2,'Archives',0,1,1,'',0,'')

      +++ Successful

    * INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (3,'Plain Text',0,0,1,'',0,'')

      +++ Successful

    * INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (4,'Documents',0,0,1,'',0,'')

      +++ Successful

    * INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (5,'Real Media',0,0,2,'',0,'')

      +++ Successful

    * INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (6,'Streams',2,0,1,'',0,'')

      +++ Successful

    * INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, ma

Mighty Gorgon [ Sat 28 Nov, 2009 20:47 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Are you sure that the upgrade didn't succeed?

I can see just few errors related to some mods which you didn't have... so I guess your upgrade is fine.

Try to go on and see if it works.

ancraz [ Sun 29 Nov, 2009 01:37 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Mighty Gorgon wrote: [View Post]
Are you sure that the upgrade didn't succeed?

I can see just few errors related to some mods which you didn't have... so I guess your upgrade is fine.

Try to go on and see if it works.

no it didn't work

spydie and his friend is trying helping me solve the problem

checker here http://underarchive.com/phpBB2/

spydie [ Sun 29 Nov, 2009 11:36 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

looks like some of the files are corruped.

the install apears a blanc page.

reupload everything in binary mod of ftp client. the DB looks fine.

ancraz [ Sun 29 Nov, 2009 11:44 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

spydie wrote: [View Post]
looks like some of the files are corruped.

the install apears a blanc page.

reupload everything in binary mod of ftp client. the DB looks fine.

I did that to as soon as you said that

still no use

Mighty Gorgon [ Sun 29 Nov, 2009 23:35 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Quote:
HTTP 500 - Internal Server Error
The server responded with an error page.

Is your server supporting .htaccess correctly?

Did you try a clean installation just to make sure it is working fine on your server?

spydie [ Sun 29 Nov, 2009 23:43 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

it looks like the server is´nt suporting file rewrite and auto chmod.

had to set all chmod manualy. and got a message that the server can´t create files

Mighty Gorgon [ Sun 29 Nov, 2009 23:57 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Try to remove htaccess just to make a test.

spydie [ Mon 30 Nov, 2009 00:00 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

thats what i´ve been thinking about.

maybe run everything via ini file.

nothing:

same thing
install apears blanc page.

the funny thing is that you can see the database update without problems, but install itself zip

ancraz [ Mon 30 Nov, 2009 05:19 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

when i did a fresh installation the script works like charm but not when i try to upgrade it

. i am posting this hoping that this will help you guys

Mighty Gorgon [ Mon 30 Nov, 2009 12:39 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Try to change config.php and make it point to the updated DB to see if it works.

It shouldn't... but that would be another check... and that would also probably mean that the DB isn't upgraded correctly.

spydie [ Mon 30 Nov, 2009 13:46 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

i already tried that. pointing to the upgraded one.

thing is , that the upgrade is´nt finished. posts are only in _old_phpbb_posts and _old_phpbb_posts_text

the script didn´t move them to phpbb_posts.

And there are many other tables showing 0 content

ancraz [ Mon 30 Nov, 2009 13:56 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

is there a way to convert them manually

so the problem is not with the server . thank u spydie you are me helping a lot and i must thank the rest of you all too

thank u so much this means a lot to me

novice programmer [ Mon 30 Nov, 2009 17:10 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

I have been around the server with ancraz's permisson, and it looks like it was a CHMOD issue. Php was only allowed to read on the server, but we need to make it capable of read & write...

ancraz [ Mon 30 Nov, 2009 23:39 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Thats means my server is not able to support icy phoenix , what changes in the server will help script run

novice programmer [ Tue 01 Dec, 2009 00:07 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

ancraz wrote: [View Post]
Thats means my server is not able to support icy phoenix , what changes in the server will help script run

That is not fully true, as long as a fresh install suceed, but a upgrade don't.

In order to workaround and troubleshoot this thing, this is the way I have tried to update and upgrade his board:

SMF 1.1 -> PhpBB 2.0.22 -> PhpBB 2.0.23 -> Icy Phoenix 1.3.0.53

That last stage do fail, as long as the update suceeds, but quering the server for icy's root index.php redirects to the install procedure (install/install.php). I have been trying to execute the clean_tables_ip.php file, but it returns nothing. All of this happens while the files are chmod 777, so I assume it is not a permissions problem.

It does not mind if I try to update to Icy Phoenix 1.3.0.53 or directly to build 053a RC3.

I think there is something on the files the server os not able to do. On the update page it appears the "Your server does not support file creation and editing", but the cache files of Icy are on their folder and filled with contents...

It is a very rare issue, and I guess you will need to contact your hosting service to fix your server in order to be able to run Icy Phoenix with any issues. I am sorry I cannot help you anymore.

Perhaps you will be aimed to make a SSH login into your server if it is a VPS or a dedicated one ir order to access your server's configuration files.

ancraz [ Tue 01 Dec, 2009 11:01 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

novice programmer wrote: [View Post]
ancraz wrote: [View Post]
Thats means my server is not able to support icy phoenix , what changes in the server will help script run

That is not fully true, as long as a fresh install suceed, but a upgrade don't.

In order to workaround and troubleshoot this thing, this is the way I have tried to update and upgrade his board:

SMF 1.1 -> PhpBB 2.0.22 -> PhpBB 2.0.23 -> Icy Phoenix 1.3.0.53

That last stage do fail, as long as the update suceeds, but quering the server for icy's root index.php redirects to the install procedure (install/install.php). I have been trying to execute the clean_tables_ip.php file, but it returns nothing. All of this happens while the files are chmod 777, so I assume it is not a permissions problem.

It does not mind if I try to update to Icy Phoenix 1.3.0.53 or directly to build 053a RC3.

I think there is something on the files the server os not able to do. On the update page it appears the "Your server does not support file creation and editing", but the cache files of Icy are on their folder and filled with contents...

It is a very rare issue, and I guess you will need to contact your hosting service to fix your server in order to be able to run Icy Phoenix with any issues. I am sorry I cannot help you anymore.

Perhaps you will be aimed to make a SSH login into your server if it is a VPS or a dedicated one ir order to access your server's configuration files.

is it possible for me convert in a different server move back the site this server . will that work

spydie [ Tue 01 Dec, 2009 11:43 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

if you can try that , it will probably work

depending on the permissions on that server of course.

ancraz [ Tue 01 Dec, 2009 12:29 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

spydie wrote: [View Post]
if you can try that , it will probably work

depending on the permissions on that server of course.

do you know some place where i can get a sub domain easy . iave a ccount on a different server but a domain name name for it

or do you know any free host where i can do this

spydie [ Tue 01 Dec, 2009 13:06 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

i´ll try later on on my server.

ancraz [ Tue 01 Dec, 2009 13:25 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

spydie wrote: [View Post]
i´ll try later on on my server.

thank u

Mighty Gorgon [ Tue 01 Dec, 2009 13:31 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Before trying to switch to another server you should try doing the conversion on a local testing environment (using XAMPP for example).

Only after you have that working correctly on your local server I would take any other decision.

spydie [ Tue 01 Dec, 2009 13:35 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

I´ll probably do the conversion on my Wamp enviorment and take it converted to ancraz server

ancraz [ Tue 01 Dec, 2009 15:00 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

spydie wrote: [View Post]
I´ll probably do the conversion on my Wamp enviorment and take it converted to ancraz server

thank u so much man it means a lot

tried in my friends server still did not work the same error

novice programmer [ Wed 02 Dec, 2009 15:28 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Mighty Gorgon wrote: [View Post]
Before trying to switch to another server you should try doing the conversion on a local testing environment (using XAMPP for example).

Only after you have that working correctly on your local server I would take any other decision.

Well, I think that my post has been mis-understood. I were not talking about a server swich, but to get root at the SSH terminal of his VPS/dedicated server and make the required changes, but I think it is too much for ancraz to handle...

ancraz [ Thu 03 Dec, 2009 11:07 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

novice programmer wrote: [View Post]
Mighty Gorgon wrote: [View Post]
Before trying to switch to another server you should try doing the conversion on a local testing environment (using XAMPP for example).

Only after you have that working correctly on your local server I would take any other decision.

Well, I think that my post has been mis-understood. I were not talking about a server swich, but to get root at the SSH terminal of his VPS/dedicated server and make the required changes, but I think it is too much for ancraz to handle...

what i thought was since i am not able to complete the upgrade in my server i thought i will do the upgrade in a different server and after completing the upgrade and the script is working properly . i will move it to my server

thus avoiding this server error

ancraz [ Fri 04 Dec, 2009 13:37 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

does any one won a server who has a this feature to upgrade the phpbb2 to ice i will try and pay for that server as much as i can or can some post the manual upgrade steps like what are the files that needs to be edited and what are sql file that needs to be executed

after finding a cms i like and now i cant use breaks my heart . hope i find a solution

but till now you guys provided some good support

Mighty Gorgon [ Fri 04 Dec, 2009 21:44 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

spydie, did you manage to get the offline version to work fine?

spydie [ Fri 04 Dec, 2009 21:48 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

I´m still stuck with this

first had to sort out , what was from whitch script.

Edit:

But if i get it working localy, i think i can update his DB with the updated

Mighty Gorgon [ Fri 04 Dec, 2009 21:50 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

ancraz wrote: [View Post]
does any one won a server who has a this feature to upgrade the phpbb2 to ice i will try and pay for that server as much as i can or can some post the manual upgrade steps like what are the files that needs to be edited and what are sql file that needs to be executed

after finding a cms i like and now i cant use breaks my heart . hope i find a solution but till now you guys provided some good support

If a clean install works fine, then it's not an hosting related issue... you should pay someone to upgrade that DB for you instead.

ancraz [ Sun 06 Dec, 2009 10:29 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Mighty Gorgon wrote: [View Post]

If a clean install works fine, then it's not an hosting related issue... you should pay someone to upgrade that DB for you instead.

so this a DB issue is there a manual update available i am asking this since i don't have any money

and dont want to trouble spydie any more since has helped me a lot already

ancraz [ Wed 09 Dec, 2009 15:26 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Is this problem caused by DB . Is something wrong with DB. all i have 3$ so i think any one will do it for that amount

.Please tell me how to fix this issue or give the instruction and i will do the update manually than running upgrade phpbb2 script

spydie [ Wed 09 Dec, 2009 15:43 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

I´ve tried to convert this site in Local-wamp enviorment.

No chance to get it working. the update PhpBB2 to IP1.3 is´nt completed like it should.

The post table remains empty, and some other tables aswell.

I through the towel

ancraz [ Wed 09 Dec, 2009 15:48 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

spydie wrote: [View Post]
I´ve tried to convert this site in Local-wamp enviorment.

No chance to get it working. the update PhpBB2 to IP1.3 is´nt completed like it should.

The post table remains empty, and some other tables aswell.

I through the towel

so my Db is the one thats giving the problem

thank u for telling me that

spydie [ Wed 09 Dec, 2009 22:26 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Its not your DB. Thats something in the script
i could´nt find

ancraz [ Thu 10 Dec, 2009 00:08 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

so upgrade script is not working

hope the developer looks into this issue and fixes it

So i can make the move to this script

Informpro [ Thu 10 Dec, 2009 13:03 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

I was having a blank page when I update to IP ... Because I forgot to escape a '

DWho [ Thu 10 Dec, 2009 14:46 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

ancraz, you have a pm

ancraz [ Thu 10 Dec, 2009 15:16 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

DWho wrote: [View Post]
ancraz, you have a pm

I did not any PM from you

DWho [ Thu 10 Dec, 2009 15:35 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

Lol sorry i forgot to hit submit you have a pm

ancraz [ Sat 12 Dec, 2009 00:12 ]
Post subject: Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(

some one help me

i willing to pay the 3 $ i have in my account

i know its not much but that all i have