I did follow the guide above in trying to fix the issue but no luck
Could someone please help on upgrade to 07.00.06
Here is my log error
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Level'.
Invalid column name 'TabPath'.
Invalid column name 'Level'.
Invalid column name 'TabPath'.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:6599c7cc-b3fa-46ee-9d0a-cdf02eefbea9
CREATE PROCEDURE dbo.[BuildTabLevelAndPath](@TabId INT, @IncludeChild BIT = 0)
AS
BEGIN
DECLARE @ParentId INT, @Level INT, @TabPath NVARCHAR(255), @TabName NVARCHAR(200)
SELECT @ParentId = ParentId, @TabName = TabName FROM dbo.[Tabs] WHERE TabID = @TabId
IF @ParentId > 0
BEGIN
SELECT
@Level = [Level] + 1,
@TabPath = TabPath + '//' + dbo.[RemoveStringCharacters](@TabName, '&? ./''#:*')
FROM dbo.[Tabs] WHERE TabID = @ParentId
END
ELSE
BEGIN
SELECT @Level = 0, @TabPath = '//' + dbo.[RemoveStringCharacters](@TabName, '&? ./''#:*')
END
UPDATE dbo.[Tabs] SET [Level] = @Level, TabPath = @TabPath WHERE TabID = @TabId
IF @IncludeChild = 1
BEGIN
DECLARE @ChildTabs TABLE(TabID INT)
DECLARE @ChildID INT
INSERT INTO @ChildTabs SELECT TabID FROM dbo.[Tabs] WHERE ParentId = @TabId
WHILE EXISTS (SELECT TOP 1 TabID FROM @ChildTabs)
BEGIN
SET @ChildID = (SELECT TOP 1 TabID FROM @ChildTabs)
EXEC dbo.[BuildTabLevelAndPath] @ChildID, @IncludeChild
DELETE FROM @ChildTabs WHERE TabID = @ChildID
END
END
END