hello,

i'm trying to upgrade my portal to version 05.01.04.

during the upgrade process i get the below errors:

Upgrading DotNetNuke

Current Assembly Version: 05.01.04

Current Database Version: 04.09.02

Upgrade Status Report00:00:00.576 - Upgrading to Version: 05.01.04
00:00:00.691 -   Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:00:16.216 -   Executing Script: 05.00.01.SqlDataProvider Success
00:00:17.776 -   Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:25.263 -   Executing Script: 05.01.01.SqlDataProvider Success

all others are successfull.

and the log files contains the following:

05.00.00 log:

System.Data.SqlClient.SqlException: 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(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)



/* Update IconFile References for Admin Tabs */
/*********************************************/

UPDATE dbo.Tabs
    SET IconFile = '~/images/' + IconFile
    WHERE IconFile LIKE 'icon_%'
        AND (TabPath LIKE '//Host%' OR TabPath LIKE '//Admin%')


System.Data.SqlClient.SqlException: 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(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)



/* Set Admin and Host Pages to be Secure By Default */
/****************************************************/

UPDATE dbo.[Tabs]
    SET IsSecure = 1
WHERE PortalID IS NULL
    OR TabID IN (SELECT AdminTabId FROM dbo.[Portals])
    OR ParentId IN (SELECT AdminTabId FROM dbo.[Portals])

05.01.00 log:

System.Data.SqlClient.SqlException: 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(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)



UPDATE dbo.Tabs SET Title='Pages', TabName='Pages' WHERE TabPath='//Admin//Tabs'

/* Enable link of Admin, Host tabs */
UPDATE dbo.Tabs SET DisableLink=0 WHERE TabPath='//Admin' OR TabPath='//Host'

i hope my post is easily readable.

please advice what might caused the problem.

thx all in advance.