Updating phpBB3 Beta5 to RC1 Tutorial+Script

[legocrazy1]

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

[MarkBarl]

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.

[Tails5 Francisco]

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.

[rnr_woogie Wes]

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.

[orkgashmo]

it also worked for me, fast and without problems

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!

[gawaya Lahiru]

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!

[aspicer Alan]

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 Alan]

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.

[..::Frans::..]

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...

[aspicer Alan]

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

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.