Any idea ?

Here the full 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.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.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])

Thanks, Sandro

---

Sandro De Matteis Microsoft IT Pro: Enterprise Admin, Enterprise Messaging Admin Technology Specialist: Microsoft Virtualization Dnn portals: http://www.dbdog.it , http://www.royalcrestgoldn.it, http://www.retrieversclub.it

 I've read the issue a few times in this forums, but I haven't been able to reproduce or find any cause in the script.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN