Some Problems After Upgrade From Phpbb 2.0.22

Posts: 1

Tue 30 Oct, 2007 12:15

Subject: Some Problems After Upgrade From Phpbb 2.0.22

First of all I wish to congratulate with all programmers for this wonderful software.
I follow all steps to upgrade from phpbb 2.0.22 modded with eXtreme Styles and I got these errors:

Code: [Download] [Hide] [Select]

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

+++ Error: Duplicate column name 'auth_globalannounce'

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

+++ Error: Duplicate column name 'auth_globalannounce'

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

+++ Error: Duplicate column name 'auth_mod'

INSERT INTO phpbb_config VALUES ('xs_shownav', '17')

+++ Error: Duplicate entry 'xs_shownav' 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

# INSERT INTO phpbb_config VALUES ('xs_auto_compile', '1')

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

# INSERT INTO phpbb_config VALUES ('xs_auto_recompile', '1')

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

# INSERT INTO phpbb_config VALUES ('xs_use_cache', '1')

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

# INSERT INTO phpbb_config VALUES ('xs_php', 'php')

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

# INSERT INTO phpbb_config VALUES ('xs_def_template', 'mg_themes')

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

# INSERT INTO phpbb_config VALUES ('xs_check_switches', '1')

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

# INSERT INTO phpbb_config VALUES ('xs_warn_includes', '1')

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

# INSERT INTO phpbb_config VALUES ('xs_add_comments', '0')

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

# INSERT INTO phpbb_config VALUES ('xs_ftp_host', '')

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

# INSERT INTO phpbb_config VALUES ('xs_ftp_login', '')

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

# INSERT INTO phpbb_config VALUES ('xs_ftp_path', '')

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

# INSERT INTO phpbb_config VALUES ('xs_downloads_count', '0')

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

# INSERT INTO phpbb_config VALUES ('xs_downloads_default', '0')

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

# INSERT INTO phpbb_config VALUES ('xs_template_time', '1132930673')

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

# INSERT INTO phpbb_config VALUES ('xs_version', '7')

+++ Error: Duplicate entry 'xs_version' for key 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'

I'm unable to open any post, but I can access at ACP.
What I can do?

Sorry for my poor English... and thanks in advance

Profile PM

Mighty Gorgon

Quote

Posts: 7192 Location: Borgo San Michele

Mon 05 Nov, 2007 01:11

Subject: Re: Some Problems After Upgrade From Phpbb 2.0.22

Try to launch again the update script, do not pay attention to the errors.

Then reupload all Icy Phoenix files (paying attention to not replace some useful files like config.php) and try again.

Profile PM Website

Reply to topic

Page 1 of 1

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

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.6313s (PHP: 3% SQL: 97%)
SQL queries: 10 - Debug Off - GZIP Enabled

Icy Phoenix

Icy Phoenix - Powering Communities

Some Problems After Upgrade From Phpbb 2.0.22