I upgraded my DNN version 5..4.4 to 5.5. The upgrade went on fine except this SQL Error  saying please see View log 5.5.0. The following is the view log details.
Please let me know what is the error about.

System.Data.SqlClient.SqlException: Invalid object name 'portals'.
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 SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)




/* 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.dnn_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.dnn_userroles as ur inner join dbo.dnn_userportals as up on ur.userid=up.userid where up.portalid=@portalid)

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

FETCH NEXT FROM Portals_Cursor
into @PortalID, @AdministratorRoleId

END
CLOSE Portals_Cursor

AFAIK there has been an issue reported in the script, which will hopefully be fixed in 5.5.1

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Check the permissions for pages and modules. If they look fine, i.e. locked for admins and configurable for all other users, you should be fine.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN