-
2
Answers
-
Last Activity:
long time ago,
noor alam
Your question has been submitted and is awaiting moderation.
Thank you for reporting this content, moderators have been notified of your submission.
I'm adding a page in a DNN 06.02.00 site, it was updated from 06.01.05. please check attached log file.
When I add the page I get this error:
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.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)
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