https://www.myDomain.org/Admin/Pages/...

UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDR; InfoPath.3)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 4b6b8a72-708e-4325-8f84-586d97744ddc

InnerException: Invalid column name 'Level'. Invalid column name 'TabPath'. Invalid column name 'Level'. Invalid column name 'TabPath'.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Invalid column name 'Level'. Invalid column name 'TabPath'. Invalid column name 'Level'. Invalid column name 'TabPath'. ---> System.Data.SqlClient.SqlException: 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) 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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.UpdateTab(Int32 tabId, Int32 contentItemId, Int32 portalId, Guid versionGuid, Guid defaultLanguageGuid, Guid localizedVersionGuid, String tabName, Boolean isVisible, Boolean disableLink, Int32 parentId, String iconFile, String iconFileLarge, String title, String description, String keyWords, Boolean isDeleted, String url, String skinSrc, String containerSrc, DateTime startDate, DateTime endDate, Int32 refreshInterval, String pageHeadText, Boolean isSecure, Boolean permanentRedirect, Single siteMapPriority, Int32 lastModifiedByuserID, String cultureCode) at DotNetNuke.Entities.Tabs.TabController.UpdateTab(TabInfo updatedTab) at DesktopModules.Admin.Tabs.View.CtlPagesNodeEdit(Object sender, RadTreeNodeEditEventArgs e) at Telerik.Web.UI.RadTreeView.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

-----

anyone can tell me what would be the cause of such a thing?

DNN 6.2.3, SQL Server 2008 R2 Express, Windows Server 2008 R2

yeah, or both ... this is not good. I discovered that something bombed in the 6.2 upgrade relative to this and never got cured. Wasn't noticed because no page management has been tried until now.

I upgraded another site to 6.2.3 so that I could compare. The Tabs table on the problem site did not have columns "Level" or "TabPath." I haven't seen any way to cure this other than getting my hands dirty.

So with great care I have compared table structure and stored procedures and constraints and indexes. I added the columns to the table manually with correct defaults and constraints. I rolled my own view based on code in the failed 6.2 sql to get a view that held level and tabpath which matched how they looked in the site that upgraded normally and has a good 6.2.3 build.

Then I updated the tabs table to hold the level and tabpath from that view. The Tabs table in the problem install now looks identical and has the right level and tabpath relative to ParentID. Looks fine.

But the menu comes out in a jumble, one effort to display levels with two pages, the rest just a heap in a single unordered list that fills the page horizontally and vertically. Some items appear more than once. The links work but that is the onlly savng grace. This is a mess.

When I go into Admin Page Management, I can't get to the "More Settings" area. This error is logged:

InnerException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Collections.ArrayList.get_Item

StackTrace:

Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.Collections.ArrayList.get_Item(Int32 index) at System.Web.UI.WebControls.ListItemCollection.get_Item(Int32 index) at DotNetNuke.Web.UI.WebControls.Extensions.ListControlExtensions.Select(ListControl control, String initial, Boolean findByText, Int32 fallbackIndex) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.BindTabControls(TabInfo tab) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.BindTab() at DotNetNuke.Modules.Admin.Tabs.ManageTabs.OnLoad(EventArgs e) --- End of inner exception stack trace ---

I will keep comparing database structure (have a tool) to see what I can find, but I've done that and don't see anything  obvious.

Any ideas would be most welcome.