|
Page 1 of 4
|
 ancraz 
Joined: November 2009
Posts: 50
|
 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
|
| Description: |
|
| Filesize: |
64.77 KB |
| Viewed: |
112 Time(s) |
|
____________  NO can say who is wright or wrong all we can do is follow what we believe is right  . This is the code by which i live 
Last edited by ancraz on Fri 27 Nov, 2009 16:19; edited 1 time in total |
#1 Wed 25 Nov, 2009 16:03 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
ancraz
Joined: November 2009
Posts: 50
|
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
____________ NO can say who is wright or wrong all we can do is follow what we believe is right . This is the code by which i live
|
#2 Fri 27 Nov, 2009 16:18 |
|
spydie
Joined: December 2008
Posts: 1796
Location:  In the Boxes
|
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.
____________
Out of Order
|
#3 Fri 27 Nov, 2009 19:41 |
|
ancraz
Joined: November 2009
Posts: 50
|
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.
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
____________ NO can say who is wright or wrong all we can do is follow what we believe is right . This is the code by which i live
|
#4 Fri 27 Nov, 2009 23:42 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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
____________
Out of Order
|
#5 Fri 27 Nov, 2009 23:48 |
|
ancraz
Joined: November 2009
Posts: 50
|
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
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
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
____________ NO can say who is wright or wrong all we can do is follow what we believe is right . This is the code by which i live
Edited by Mighty Gorgon, Sat 28 Nov, 2009 20:46: Added a spoiler |
#6 Sat 28 Nov, 2009 00:08 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7192
Location:  Borgo San Michele
|
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.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#7 Sat 28 Nov, 2009 20:47 |
|
ancraz
Joined: November 2009
Posts: 50
|
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.
no it didn't work spydie and his friend is trying helping me solve the problem
checker here http://underarchive.com/phpBB2/
____________ NO can say who is wright or wrong all we can do is follow what we believe is right . This is the code by which i live
|
#8 Sun 29 Nov, 2009 01:37 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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.
____________
Out of Order
|
#9 Sun 29 Nov, 2009 11:36 |
|
ancraz
Joined: November 2009
Posts: 50
|
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.
I did that to as soon as you said that  still no use
____________ NO can say who is wright or wrong all we can do is follow what we believe is right . This is the code by which i live
|
#10 Sun 29 Nov, 2009 11:44 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7192
Location: Borgo San Michele
|
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?
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#11 Sun 29 Nov, 2009 23:35 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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
____________
Out of Order
|
#12 Sun 29 Nov, 2009 23:43 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7192
Location: Borgo San Michele
|
Re: Upgrading From Phbb2 To Ice Phoenix Not Working Tryed 5 Times To Upgrading :(
Try to remove htaccess just to make a test.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#13 Sun 29 Nov, 2009 23:57 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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
____________
Out of Order
|
#14 Mon 30 Nov, 2009 00:00 |
|
ancraz
Joined: November 2009
Posts: 50
|
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
____________ NO can say who is wright or wrong all we can do is follow what we believe is right . This is the code by which i live
|
#15 Mon 30 Nov, 2009 05:19 |
|
|
|
Page 1 of 4
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
|
|
|
|
