I have attempted to upgrade from 6.1.5 to 6.2.3 several times.  Always with the following errors:

 

within the 06/02/01 06.02.01. Log.resources file, I find the following;:

 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

 

When I open the website, I see that any reference to a pages always has a blank name, with the .apsx file type appended.

when I look at the Tabs table, the URL is blank.

How can this be corrected and what is wrong.

 

 

---

Regards
Hans

Sebastian,

 This worked!!  Thank you .

I also found that several entries on the Tabs table were invalid in that they appear to have been aborted during the update cycle. . 

Found this condition by relaxing the NULL constraint on the TabPath column and running the procedure. Observed the NULL entry in the TabPath column.  I then deleted these rows from the Tabs table.

After that all went well.  Thanks....

 

---

Regards
Hans

Hans, Sebastian... wow - well done and thank you. I came to the same impasse and was clueless. It's now resolved.

I did have to change the null constraint before the script would run, but this was simple
ALTER TABLE Tabs
ALTER COLUMN TabPath NVARCHAR(255) NULL

Thanks both.