Icy Phoenix :: View topic - Upgrading From Standard PhpBB 2.0.x ERRORS

kelel [ Wed 12 Dec, 2007 14:21 ]
Post subject: Upgrading From Standard PhpBB 2.0.x ERRORS

After execute update_to_ip.php, i have get these errors:

# 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`) ) TYPE=MyISAM

+++ 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_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

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

+++ Error: Duplicate column name 'search_time'

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

+++ Error: Duplicate column name 'search_time'

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'

# CHMOD Files

# CHMOD 0777: cache

+++ Error CHMOD 0777: cache

# CHMOD 0777: ctracker/logfiles/logfile_attempt_counter.txt

+++ Error CHMOD 0777: ctracker/logfiles/logfile_attempt_counter.txt

# CHMOD 0777: ctracker/logfiles/logfile_blocklist.txt

+++ Error CHMOD 0777: ctracker/logfiles/logfile_blocklist.txt

# CHMOD 0777: ctracker/logfiles/logfile_debug_mode.txt

+++ Error CHMOD 0777: ctracker/logfiles/logfile_debug_mode.txt

# CHMOD 0777: ctracker/logfiles/logfile_malformed_logins.txt

+++ Error CHMOD 0777: ctracker/logfiles/logfile_malformed_logins.txt

# CHMOD 0777: ctracker/logfiles/logfile_spammer.txt

+++ Error CHMOD 0777: ctracker/logfiles/logfile_spammer.txt

# CHMOD 0777: ctracker/logfiles/logfile_worms.txt

+++ Error CHMOD 0777: ctracker/logfiles/logfile_worms.txt

# CHMOD 0777: files

+++ Error CHMOD 0777: files

# CHMOD 0777: files/album

+++ Error CHMOD 0777: files/album

# CHMOD 0777: files/album/cache

+++ Error CHMOD 0777: files/album/cache

# CHMOD 0777: files/album/med_cache

+++ Error CHMOD 0777: files/album/med_cache

# CHMOD 0777: files/album/wm_cache

+++ Error CHMOD 0777: files/album/wm_cache

# CHMOD 0777: files/posted_images

+++ Error CHMOD 0777: files/posted_images

# CHMOD 0777: files/thumbs

+++ Error CHMOD 0777: files/thumbs

# CHMOD 0777: images/avatars

+++ Error CHMOD 0777: images/avatars

# CHMOD 0777: logs

+++ Error CHMOD 0777: logs

# CHMOD 0777: pafiledb/uploads

+++ Error CHMOD 0777: pafiledb/uploads

# CHMOD 0777: pafiledb/cache

+++ Error CHMOD 0777: pafiledb/cache

# CHMOD 0777: pafiledb/cache/templates

+++ Error CHMOD 0777: pafiledb/cache/templates

# CHMOD 0777: pafiledb/cache/templates/ca_aphrodite

+++ Error CHMOD 0777: pafiledb/cache/templates/ca_aphrodite

# CHMOD 0777: pafiledb/cache/templates/mg_themes

+++ Error CHMOD 0777: pafiledb/cache/templates/mg_themes

# CHMOD 0666: includes/def_themes.php

+++ Error CHMOD 0666: includes/def_themes.php

# CHMOD 0666: includes/def_tree.php

+++ Error CHMOD 0666: includes/def_tree.php

# CHMOD 0666: includes/def_words.php

+++ Error CHMOD 0666: includes/def_words.php

# CHMOD 0666: language/lang_english/lang_extend.php

+++ Error CHMOD 0666: language/lang_english/lang_extend.php

are these errors important? can i continue with the upgrading?.

Thanks a lot.

Zuker [ Wed 12 Dec, 2007 16:30 ]
Post subject: Re: Upgrading From Standard PhpBB 2.0.x ERRORS

The only things that matters there it's to check if chmod's are setted fine

kelel [ Thu 13 Dec, 2007 09:29 ]
Post subject: Re: Upgrading From Standard PhpBB 2.0.x ERRORS

Then, don't i have to worry about these errors?. I change the permissions, and all have to work fine, isn't it?.

Thanks.

Zuker [ Thu 13 Dec, 2007 14:00 ]
Post subject: Re: Upgrading From Standard PhpBB 2.0.x ERRORS

kelel wrote: [View Post]
Then, don't i have to worry about these errors?. I change the permissions, and all have to work fine, isn't it?.

Thanks.

Nope, don't worry.

Icy Phoenix

Old Support Topics - Upgrading From Standard PhpBB 2.0.x ERRORS