I just upgraded 4.9.5 to the 5.5.0 using the Upgrade download. It ran quickly with the following error. I clipped the recommended script from the log file & ran it on the SQL page, But that failed as displayed at the end of this post.

?? Should I restore 4.9.5 or is this something I can work thru?

Current Assembly Version: 05.05.00
Current Database Version: 04.09.05



Upgrade Status Report
00:00:00.109 - Upgrading to Version: 05.05.00
00:00:00.171 - Executing Script: 05.00.00.SqlDataProvider Success
00:00:07.078 - Executing Script: 05.00.01.SqlDataProvider Success
00:00:07.734 - Executing Script: 05.01.00.SqlDataProvider Success
00:00:15.875 - Executing Script: 05.01.01.SqlDataProvider Success
00:00:16.546 - Executing Script: 05.01.02.SqlDataProvider Success
00:00:16.546 - Executing Script: 05.01.03.SqlDataProvider Success
00:00:16.703 - Executing Script: 05.01.04.SqlDataProvider Success
00:00:16.718 - Executing Script: 05.02.00.SqlDataProvider Success
00:00:17.906 - Executing Script: 05.02.01.SqlDataProvider Success
00:00:18.031 - Executing Script: 05.02.02.SqlDataProvider Success
00:00:18.062 - Executing Script: 05.02.03.SqlDataProvider Success
00:00:18.093 - Executing Script: 05.03.00.SqlDataProvider Success
00:00:18.812 - Executing Script: 05.03.01.SqlDataProvider Success
00:00:18.828 - Executing Script: 05.04.00.SqlDataProvider Success
00:00:19.546 - Executing Script: 05.04.01.SqlDataProvider Success
00:00:19.578 - Executing Script: 05.04.02.SqlDataProvider Success
00:00:19.640 - Executing Script: 05.04.03.SqlDataProvider Success
00:00:19.687 - Executing Script: 05.04.04.SqlDataProvider Success
00:00:19.703 - Executing Script: 05.05.00.SqlDataProvider Error! (see 05.05.00.log.resources for more information)
00:00:21.671 - Executing Application Upgrades: 05.00.00

----- Script in the the Log File ----

/* script to fix issue with errorneous administratorroleid values*/

DECLARE @PortalID int
DECLARE @AdministratorRoleId int

--Iterate through each portal
DECLARE Portals_Cursor CURSOR FOR
SELECT PortalID,AdministratorRoleId
FROM dbo.DNN4_Portals

OPEN Portals_Cursor
--get first
FETCH NEXT FROM Portals_Cursor
into @PortalID,@AdministratorRoleId
WHILE @@FETCH_STATUS = 0
BEGIN
if @AdministratorRoleId=-1 or @AdministratorRoleId not in (select roleid from dbo.DNN4_userroles as ur inner join dbo.DNN4_userportals as up on ur.userid=up.userid where up.portalid=@portalid)

update portals set AdministratorRoleId =
(select roleid from dbo.DNN4_Roles as r where
r.PortalID =dbo.DNN4_Portals.PortalID and RoleName = 'Administrators' and dbo.DNN4_Portals.portalid=@portalid) where portalid=@portalid

FETCH NEXT FROM Portals_Cursor
into @PortalID, @AdministratorRoleId

END
CLOSE Portals_Cursor

---- Error from running this script on the SQL page ---

System.Data.SqlClient.SqlException: The multi-part identifier "dbo.DNN4_Portals.PortalID" could not be bound. The multi-part identifier "dbo.DNN4_Portals.portalid" could not be bound. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String ConnectionString, String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) /* script to fix issue with errorneous administratorroleid values*/ DECLARE @PortalID int DECLARE @AdministratorRoleId int --Iterate through each portal DECLARE Portals_Cursor CURSOR FOR SELECT PortalID,AdministratorRoleId FROM dbo.DNN4_Portals OPEN Portals_Cursor --get first FETCH NEXT FROM Portals_Cursor into @PortalID,@AdministratorRoleId WHILE @@FETCH_STATUS = 0 BEGIN if @AdministratorRoleId=-1 or @AdministratorRoleId not in (select roleid from dbo.DNN4_userroles as ur inner join dbo.DNN4_userportals as up on ur.userid=up.userid where up.portalid=@portalid) update portals set AdministratorRoleId = (select roleid from dbo.DNN4_Roles as r where r.PortalID =dbo.DNN4_Portals.PortalID and RoleName = 'Administrators' and dbo.DNN4_Portals.portalid=@portalid) where portalid=@portalid FETCH NEXT FROM Portals_Cursor into @PortalID, @AdministratorRoleId END CLOSE Portals_Cursor

System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

/* Fix incorrect culture codes assigned pre-5.5 */
/************************************************/

UPDATE dbo.Tabs
 SET CultureCode = NULL

I got the same error as Bill B in one upgrade 5.4 to 5.5
logged in 5.5 log