Hello All,

My first post, so please excuse my ignorance.

1. I created a dev server to upgrade a DNN site.
2. I backed up the site files and database, MS SQL 2005
3. I created a dev.website.com portal alias
4. I upgraded DNN from 04.08.02 to 05.06.03 Community Edition
5. The upgrade went well, with no errors.

Most things have been sorted out and working, however some links under the Host section are not displaying content. They just display a blank area with no content. The links are:

• Module Definitions
• Dashboard
• Extensions
• What's New
• Marketplace
• Configuration Manager

The rest of the Host links are working fine, just the ones listed above are displaying a blank page. They work on the old version of the site, after the upgrade they just quit. I've checked the portalalias, tabs, and a few other tables in the database to no avail. I've read through this forum and have not found a solution.

Any help would be greatly appreciated. Thank you.

Hello,

Yes, running .NET 3.5 SP1. But in IIS manager the site is running off the 2.0 Framework, can't get it to show 3.5 as an option in the drop-down list for ASP.NET site settings tab. Should I change something in the web.config of my dev DNN site for 3.5 SP1 to be used?

I can't get to Host->Extensions, that's one of the blank host pages.

I'm sorry, I don't understand your question about adding a new instance. I can add a module instance to a new page and it works fine if that's what I am supposed to try next. Logged in as a superuser.

Thanks for your time, please advise as I have not found anyone else with the same problem to get a solution.

Thanks for clearing up the .NET settings. Yes, definitely running 3.5 SP1.

I tried adding an instance of the Marketplace module to a page and received the following error:

ModuleId: -1
ModuleDefId: -1
FriendlyName:
ModuleControlSource:
AssemblyVersion: 5.6.3
PortalID: 0
PortalName: Alphatek Solutions
UserID: 12
UserName: Everett
ActiveTabID: 36
ActiveTabName: Home
RawURL: /Home/tabid/36/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://dev.alphateksolutions.com/Home/tabid/36/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 1c8a6b43-9d76-4c8e-a686-80c3a2284aac
InnerException: Invalid column name 'ModuleTitle'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModule(Int32 ContentItemID, Int32 PortalID, Int32 ModuleDefID, Boolean AllTabs, DateTime StartDate, DateTime EndDate, Boolean InheritViewPermissions, Boolean IsDeleted, Int32 createdByUserID) at DotNetNuke.Entities.Modules.ModuleController.AddModuleInternal(ModuleInfo objModule) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo objModule) at DotNetNuke.UI.ControlPanels.ControlPanelBase.AddNewModule(String title, Int32 desktopModuleId, String paneName, Int32 position, ViewPermissionType permissionType, String align) at DotNetNuke.UI.ControlPanels.IconBar.AddModule_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: ALPHATEKDEV


I also checked the event log. There were about a dozen errors during the upgrade, they all seem to be about table "dbo.Modules", column 'ModuleID'. Here is one of the event log errors:

AssemblyVersion: 5.6.3
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL: /Install/Install.aspx?mode=upgrade
AbsoluteURL: /Install/Install.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c32631db-9b19-46b7-bb39-234723865bff
InnerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "Alphatek", table "dbo.Modules", column 'ModuleID'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.
StackTrace:
Message: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "Alphatek", table "dbo.Modules", column 'ModuleID'. 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.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.AddModuleSetting(Int32 ModuleId, String SettingName, String SettingValue, Int32 createdByUserID) at DotNetNuke.Entities.Modules.ModuleController.UpdateModuleSettingInternal(Int32 ModuleId, String SettingName, String SettingValue, Boolean updateVersion)
Source:
Server Name: ALPHATEKDEV

I hope this helps. It seems to make more sense to me now, but unsure on how to fix it.

Thanks again.