Hello,
While I was upgrading my site from 6.2.0 to 6.2.1, I received some errors and I was wondering if anyone could point me in the right direction to fix this. Thanks!
Executing Script: 06.02.01.SqlDataProvider Error! (see 06.02.01.log.resources for more information)
06.02.01.log.resources:
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. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (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)
WITH RecursiveTabs (TabID, Level, TabPath)
AS
(
SELECT
TabID,
0 AS Level,
CAST('//' + dbo.RemoveStringCharacters(TabName, '&? ./''-#') AS NVARCHAR(255)) AS TabPath
FROM dbo.Tabs
WHERE ParentId IS Null
UNION ALL
SELECT
T.TabID,
R.Level + 1,
CAST(R.TabPath + '//' + dbo.RemoveStringCharacters(TabName, '&? ./''-#') AS NVARCHAR(255))
FROM dbo.Tabs T
INNER JOIN RecursiveTabs R ON T.ParentId = R.TabID
)
UPDATE dbo.Tabs SET Level = R.LEVEL, TabPath = R.TabPath
FROM dbo.Tabs T
LEFT JOIN RecursiveTabs R ON R.TabID = T.tabID