Some Problems After Upgrade From Phpbb 2.0.22

The time now is Thu 11 Dec, 2025 11:59 • All times are UTC + 1 Hour

Some Problems After Upgrade From Phpbb 2.0.22

Page 1 of 1

niky

Joined: June 2007
Posts: 1

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

#1 Tue 30 Oct, 2007 12:15

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7192 Location: Borgo San Michele	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. ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#2 Mon 05 Nov, 2007 01:11

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Thu 11 Dec, 2025 11:59 • All times are UTC + 1 Hour

Permissions List

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

Icy Phoenix

Some Problems After Upgrade From Phpbb 2.0.22

Was this topic useful?

Was this topic useful?