Updating phpBB3 Beta5 to RC1 Tutorial+Script

Support for upgrading any version of your phpBB3 installation
Forum rules
READ: StarTrekGuide.com Board Rules

Support for upgrading any version of phpBB3 to the most recent version.

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby legocrazy1 » 26 Jul 2007, 17:52

Ok, this worked first time for me and was very very straight forward. :good:


:clapping: :clapping: :clapping:
User avatar
legocrazy1
Cadet III
Cadet III
 
Posts: 39
Joined: 26 Oct 2006, 18:41
Gender: Male




phpBB Academy at StarTrekGuide
Support STG
Using PayPal Donate

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby MarkBarl » 28 Sep 2007, 07:31

Hi,
I'm hoping that someone can help me. I have currently phpBB3 Beta 5 set up with a MSSQL Express 2005 database. I have read the tutorials in this thread and have tried to run the update process to RC1 on a path to upgrading to RC5. However it does not appear to work. I have lots of error messages when the update_database.php runs
Spoiler:
Code: Select all
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'DEFAULT'.
SQL :: ALTER TABLE [phpbb_topics] ALTER COLUMN [poll_title] [varchar] (255) DEFAULT ('') NOT NULL
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'DEFAULT'.
SQL :: ALTER TABLE [phpbb_sessions] ALTER COLUMN [session_forwarded_for] [varchar] (255) DEFAULT ('') NOT NULL
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '\.'.
SQL :: DROP INDEX phpbb_users\.username_clean ON phpbb_users
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '\.'.
SQL :: DROP INDEX phpbb_styles_imageset\.imgset_nm ON phpbb_styles_imageset
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '\.'.
SQL :: DROP INDEX phpbb_bookmarks\.order_id ON phpbb_bookmarks
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '\.'.
SQL :: DROP INDEX phpbb_bookmarks\.topic_user_id ON phpbb_bookmarks
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__site___2B947552' is dependent on column 'site_logo'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [site_logo]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__uploa__2C88998B' is dependent on column 'upload_bar'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [upload_bar]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__poll___2D7CBDC4' is dependent on column 'poll_left'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [poll_left]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__poll___2E70E1FD' is dependent on column 'poll_center'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [poll_center]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__poll___2F650636' is dependent on column 'poll_right'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [poll_right]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___30592A6F' is dependent on column 'icon_friend'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_friend]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___314D4EA8' is dependent on column 'icon_foe'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_foe]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__forum__324172E1' is dependent on column 'forum_link'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [forum_link]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__forum__3335971A' is dependent on column 'forum_read'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [forum_read]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__forum__3429BB53' is dependent on column 'forum_read_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [forum_read_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__forum__351DDF8C' is dependent on column 'forum_read_subforum'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [forum_read_subforum]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__forum__361203C5' is dependent on column 'forum_unread'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [forum_unread]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__forum__370627FE' is dependent on column 'forum_unread_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [forum_unread_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__forum__37FA4C37' is dependent on column 'forum_unread_subforum'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [forum_unread_subforum]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__38EE7070' is dependent on column 'topic_moved'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_moved]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__39E294A9' is dependent on column 'topic_read'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_read]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__3AD6B8E2' is dependent on column 'topic_read_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_read_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__3BCADD1B' is dependent on column 'topic_read_hot'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_read_hot]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__3CBF0154' is dependent on column 'topic_read_hot_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_read_hot_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__3DB3258D' is dependent on column 'topic_read_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_read_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__3EA749C6' is dependent on column 'topic_read_locked_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_read_locked_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__3F9B6DFF' is dependent on column 'topic_unread'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_unread]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__408F9238' is dependent on column 'topic_unread_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_unread_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__4183B671' is dependent on column 'topic_unread_hot'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_unread_hot]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__4277DAAA' is dependent on column 'topic_unread_hot_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_unread_hot_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__436BFEE3' is dependent on column 'topic_unread_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_unread_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__topic__4460231C' is dependent on column 'topic_unread_locked_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [topic_unread_locked_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__stick__45544755' is dependent on column 'sticky_read'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [sticky_read]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__stick__46486B8E' is dependent on column 'sticky_read_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [sticky_read_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__stick__473C8FC7' is dependent on column 'sticky_read_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [sticky_read_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__stick__4830B400' is dependent on column 'sticky_read_locked_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [sticky_read_locked_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__stick__4924D839' is dependent on column 'sticky_unread'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [sticky_unread]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__stick__4A18FC72' is dependent on column 'sticky_unread_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [sticky_unread_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__stick__4B0D20AB' is dependent on column 'sticky_unread_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [sticky_unread_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__stick__4C0144E4' is dependent on column 'sticky_unread_locked_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [sticky_unread_locked_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__annou__4CF5691D' is dependent on column 'announce_read'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [announce_read]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__annou__4DE98D56' is dependent on column 'announce_read_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [announce_read_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__annou__4EDDB18F' is dependent on column 'announce_read_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [announce_read_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__annou__4FD1D5C8' is dependent on column 'announce_read_locked_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [announce_read_locked_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__annou__50C5FA01' is dependent on column 'announce_unread'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [announce_unread]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__annou__51BA1E3A' is dependent on column 'announce_unread_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [announce_unread_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__annou__52AE4273' is dependent on column 'announce_unread_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [announce_unread_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__annou__53A266AC' is dependent on column 'announce_unread_locked_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [announce_unread_locked_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__globa__54968AE5' is dependent on column 'global_read'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [global_read]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__globa__558AAF1E' is dependent on column 'global_read_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [global_read_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__globa__567ED357' is dependent on column 'global_read_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [global_read_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__globa__5772F790' is dependent on column 'global_read_locked_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [global_read_locked_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__globa__58671BC9' is dependent on column 'global_unread'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [global_unread]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__globa__595B4002' is dependent on column 'global_unread_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [global_unread_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__globa__5A4F643B' is dependent on column 'global_unread_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [global_unread_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__globa__5B438874' is dependent on column 'global_unread_locked_mine'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [global_unread_locked_mine]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__pm_re__5C37ACAD' is dependent on column 'pm_read'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [pm_read]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__pm_un__5D2BD0E6' is dependent on column 'pm_unread'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [pm_unread]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___5E1FF51F' is dependent on column 'icon_contact_aim'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_contact_aim]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___5F141958' is dependent on column 'icon_contact_email'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_contact_email]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___60083D91' is dependent on column 'icon_contact_icq'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_contact_icq]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___60FC61CA' is dependent on column 'icon_contact_jabber'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_contact_jabber]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___61F08603' is dependent on column 'icon_contact_msnm'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_contact_msnm]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___62E4AA3C' is dependent on column 'icon_contact_pm'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_contact_pm]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___63D8CE75' is dependent on column 'icon_contact_yahoo'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_contact_yahoo]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___64CCF2AE' is dependent on column 'icon_contact_www'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_contact_www]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___65C116E7' is dependent on column 'icon_post_delete'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_post_delete]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___66B53B20' is dependent on column 'icon_post_edit'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_post_edit]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___67A95F59' is dependent on column 'icon_post_info'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_post_info]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___689D8392' is dependent on column 'icon_post_quote'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_post_quote]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___6991A7CB' is dependent on column 'icon_post_report'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_post_report]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___6A85CC04' is dependent on column 'icon_post_target'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_post_target]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___6B79F03D' is dependent on column 'icon_post_target_unread'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_post_target_unread]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___6C6E1476' is dependent on column 'icon_topic_attach'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_topic_attach]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___6D6238AF' is dependent on column 'icon_topic_latest'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_topic_latest]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___6E565CE8' is dependent on column 'icon_topic_newest'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_topic_newest]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___6F4A8121' is dependent on column 'icon_topic_reported'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_topic_reported]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___703EA55A' is dependent on column 'icon_topic_unapproved'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_topic_unapproved]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___7132C993' is dependent on column 'icon_user_online'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_user_online]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___7226EDCC' is dependent on column 'icon_user_offline'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_user_offline]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___731B1205' is dependent on column 'icon_user_profile'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_user_profile]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___740F363E' is dependent on column 'icon_user_search'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_user_search]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__icon___75035A77' is dependent on column 'icon_user_warn'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [icon_user_warn]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__butto__75F77EB0' is dependent on column 'button_pm_forward'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [button_pm_forward]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__butto__76EBA2E9' is dependent on column 'button_pm_new'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [button_pm_new]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__butto__77DFC722' is dependent on column 'button_pm_reply'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [button_pm_reply]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__butto__78D3EB5B' is dependent on column 'button_topic_locked'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [button_topic_locked]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__butto__79C80F94' is dependent on column 'button_topic_new'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [button_topic_new]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__butto__7ABC33CD' is dependent on column 'button_topic_reply'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [button_topic_reply]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___7BB05806' is dependent on column 'user_icon1'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon1]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___7CA47C3F' is dependent on column 'user_icon2'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon2]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___7D98A078' is dependent on column 'user_icon3'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon3]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___7E8CC4B1' is dependent on column 'user_icon4'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon4]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___7F80E8EA' is dependent on column 'user_icon5'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon5]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___00750D23' is dependent on column 'user_icon6'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon6]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___0169315C' is dependent on column 'user_icon7'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon7]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___025D5595' is dependent on column 'user_icon8'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon8]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___035179CE' is dependent on column 'user_icon9'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon9]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_sty__user___04459E07' is dependent on column 'user_icon10'.
SQL :: ALTER TABLE [phpbb_styles_imageset] DROP COLUMN [user_icon10]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF__phpbb_boo__order__3E52440B' is dependent on column 'order_id'.
SQL :: ALTER TABLE [phpbb_bookmarks] DROP COLUMN [order_id]
?  Error :: [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'username_clean' already exists on table 'phpbb_users'.
SQL :: CREATE UNIQUE INDEX username_clean ON phpbb_users(username_clean) ON [PRIMARY]

The db user is connecting via mssql_odbc and has db_owner rights. These are the only error messages I get, but when I try to log in I get an error could not get style data.

Any help would be appreciated.

Mark.
MarkBarl
Crewman
Crewman
 
Posts: 2
Joined: 28 Sep 2007, 04:01
Gender: Male

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby Tails5 » 25 Oct 2007, 03:47

Can someone help me? I have PHPBB3 Beta 5, and have found the only way to update is to go to RC1, then 2, then 3, and so on... but I cant find an RC1 download package anywhere, PHPBB has taken it down for the RC7 release.
Tails5    
Crewman
Crewman
 
Posts: 1
Joined: 25 Oct 2007, 03:28
Gender: Male

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby rnr_woogie » 02 Nov 2007, 09:39

I could not make the update from B5 to RC1 work. I'm sure I was doing something wrong. However I did find a way that worked for me and it may work for others that are having issues.

1.Create a new RC1 database using the same table prefix as the B5
2. Install RC1 in a seperate folder.
3. Install subsilver theme to RC1 and set to default
4. Set B5 default theme to subsilver and override user settings.
5. Export the B5 database less the styles_tables
6. From the RC1 database drop all tables except styles_tables
7. Import B5 database to RC1
8. Run RC7 updater
9. Do a web redirect to the new RC7 forum
So far everything seems to work.
rnr_woogie    
Crewman
Crewman
 
Posts: 1
Joined: 02 Nov 2007, 08:57
Gender: Male

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby orkgashmo » 16 Dec 2007, 06:08

it also worked for me, fast and without problems :good:

the only thing I've found so far is that the version number keeps being B5 instead of RC1, but I hope that will be solved within the next upgrades.

thanks for your work! :clapping:
orkgashmo
Crewman
Crewman
 
Posts: 8
Joined: 03 Apr 2007, 08:15
Gender: Male

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby gawaya » 20 May 2008, 06:04

Hi Frans,

I followed your guide to update a B5 board to RC1 with the version3 file and it worked like a charm. However it didn't give me any of the two errors but I'm assuming it's just my lucky day :) I checked the board and it's working fine.

Thanks a lot Frans and STG! :good:
gawaya    
Crewman
Crewman
 
Posts: 3
Joined: 20 May 2008, 05:58
Gender: Male

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby aspicer » 21 May 2008, 12:29

..::Frans::.. wrote:As said before, i think this is a sign that the install directory is still in the voard directory, so renaming the install dir should do the trick...;)


* I believe I am quoting page 16 of this topic on here.
"Sorry but the board is temporarily unavailable, please try again in a few minutes." is the error message. But also was getting "board is disabled" when logged on and when viewing forums.

I just had this same problem. All of a sudden noticed that my board was telling that it was temporarily unavailable when you were not logged in, and that it was disabled when you were logged in. An "admin" could see all of the forums and messages. Probably noone else.

I upgraded to 3.0.1 just to be safe. Was afraid I'd been hacked somehow. Just at the last minute I decided to check my file permissions in the phpBB3 directory. I saw several things owner/group as "33". So I did a chmod of everything in phpBB3 to webservers username. Bada Bing! all fixed.

I think I might have deleted a user on my server awhile back, and I might have used that user to originally install or upgrade phpBB ... by deleting that user I end up with a user/group "33". I guess phpBB didn't like that at all.
aspicer    
Crewman
Crewman
 
Posts: 3
Joined: 21 May 2008, 12:21
Gender: Male
phpBB Knowledge: 3

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby aspicer » 21 May 2008, 12:53

nope! it's still broken...

I forgot also that I have been making backup of primary server to backup server with rsync program. Now the primary server died, and this is the backup server.

Something must still be wrong in files/permissions. The database seems ok. And it let me upgrade ok. But something about the files/permissions and it still thinks the board should be disabled.
aspicer    
Crewman
Crewman
 
Posts: 3
Joined: 21 May 2008, 12:21
Gender: Male
phpBB Knowledge: 3

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby ..::Frans::.. » 21 May 2008, 13:37

Files have absolutely nothing to do with your borad, thinking that it is offline or disabled. Go to the config table and switch the board_disabled setting to 0...
ping...
User avatar
..::Frans::..
STG Development
STG Development
 
Posts: 1608
Joined: 28 Mar 2007, 15:37
Location: Netherlands
Favorite Team: RKC
Gender: Male
phpBB Knowledge: 9

Re: Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby aspicer » 21 May 2008, 20:44

In Unix everything is a file... didn't you watch Jurrasic Park? Just kidding. :shock:

config_name config_value is_dynamic
board_disable 0 0

* Anything else I should check?

It's just funny that this is my backup server, this is an Rsync Backup including phpBB3 directory and the MySQL database. I have the primary up and running and the problem doesn't exist there.

I bet if I rsync'd it back to the primary server... the problem would then occur there. SUMTHIN got glitched.
aspicer    
Crewman
Crewman
 
Posts: 3
Joined: 21 May 2008, 12:21
Gender: Male
phpBB Knowledge: 3

PreviousNext

Return to phpBB3 upgrade support

Who is online

Users browsing this forum: Google Adsense [Bot] and 6 guests