Bill,
I restored the database and site files and then proceeded to perform the upgrade again. Again,m the Telerik dlls were not included, however, I corrected the issue, as you had suggested.
However, another strange thing happened, for every page, i receive a resource note fount error in that the page is just localhost/.aspx.
I reviewed the errors and yest, there was an error with the 06.02.01 SQL Provider. The following is the error from the resource log;
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Level', table 'dotnetnukevwc.dbo.Tabs'; column does not allow nulls. UPDATE fails.
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
Looking at the original databse table, there are no entries for the level column that are NULL. However, attempting to run the update area for the Tabs table manually, I noticed that there was an error in the the 'RemoveStringCharacters function or SP is not in my database.
From this error, I would assume that the "RemoveStringCharacters" function was omitted from the file.
As I do not have an issue with the tab displays or use with DNN 5.1.6, can I just delete the RecursiveTabs procedure?