I'm trying to bring an old DNN site up to date. When I run the upgrade I get a warning message for 06.02.01:
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'Level', table 'dnndb2_93017.dbo.Tabs'; column does not allow nulls. UPDATE fails. 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() 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
The result is a menu system that all of the page names, etc are there but they lead to empty pages:
www.domainname.com/.aspx
I'd sure love some help if anyone has any ideas.
Thanks,
Don