 |
|
|
Joined: 6/9/2008
Posts: 11
|
|
|
I have upgraded DNN from 4.9.5 to 5.5.1. There was one error listed during the upgrade. There error was retrieved from:
\Providers\DataProviders\SqlDataProvider\05.03.00_Application.log.resources
The error message is:
---------------------------------------------------------------------------------------
Error: Invalid column name 'ModuleTitle'. 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(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.Entities.Modules.ModuleController.DeserializeModule(XmlNode nodeModule, XmlNode nodePane, Int32 PortalId, Int32 TabId, PortalTemplateModuleAction mergeTabs, Hashtable hModules)
at DotNetNuke.Entities.Tabs.TabController.DeserializePanes(XmlNode nodePanes, Int32 PortalId, Int32 TabId, PortalTemplateModuleAction mergeTabs, Hashtable hModules)
at DotNetNuke.Entities.Tabs.TabController.DeserializeTab(XmlNode nodeTab, TabInfo objTab, Hashtable hTabs, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable hModules)
at DotNetNuke.Services.Upgrade.Upgrade.UpgradeToVersion_530()
at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication(String strProviderPath, Version version, Boolean writeFeedback)
---------------------------------------------------------------------------------------
I have had issues similar to this in the past using the ifinity url master on other sites. The related thread to the ifinity url master issue is:
http://web3.dotnetnuke.com/Community/Forums/tabid/795/forumid/200/postid/382473/scope/posts/Default.aspx
This site did at one time have the ifinity url master installed. However, it caused to much load on this active site so it was removed. I have tripple checked and the web.config file does not have any reference to the ifinity url master.
Everything on the site appears to work except I cannot add modules to any page without getting the following error:
---------------------------------------------------------------------------------------
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. 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(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 ---
---------------------------------------------------------------------------------------
Also, if I click on the admin or host menus, I refreshes the page and the skin displays, but the admin and host menu items are not displayed. Also, if I go to host -> module definitions or host -> extensions I get the same thing and it doesn't show any modules.
I need getting this site fixed asap. Anyone have any ideas what might be wrong?
|
| |
|
|
 | |
|
|
|
It looks like not all upgrade scripts have run properly, please check upgrade logs in /providers/dataproviders/sqldataprovider folder.
|
| |
|
|
| |
|
|
Joined: 6/9/2008
Posts: 11
|
|
|
I looked in /providers/dataproviders/sqldataprovider and sorted the directory listing by date modified. I then looked in all the files that were modified on or after the date I upgraded to 5.5.1. Every file (05.00.00.log.resources - 05.05.01.log.resources) was empty. The only other file that had any data in it was 05.03.00_Application.log.resources which had the following:
-------------------------
Error: Invalid column name 'ModuleTitle'. 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(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.Entities.Modules.ModuleController.DeserializeModule(XmlNode nodeModule, XmlNode nodePane, Int32 PortalId, Int32 TabId, PortalTemplateModuleAction mergeTabs, Hashtable hModules)
at DotNetNuke.Entities.Tabs.TabController.DeserializePanes(XmlNode nodePanes, Int32 PortalId, Int32 TabId, PortalTemplateModuleAction mergeTabs, Hashtable hModules)
at DotNetNuke.Entities.Tabs.TabController.DeserializeTab(XmlNode nodeTab, TabInfo objTab, Hashtable hTabs, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable hModules)
at DotNetNuke.Services.Upgrade.Upgrade.UpgradeToVersion_530()
at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication(String strProviderPath, Version version, Boolean writeFeedback)
-------------------------
Are there any other files that I should be looking at?
|
| |
|
|
| |
|
|
 |
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
I recall tracking down that same issue during the upgrade of a client's site. I found that even though iFinity URL Master had been un-installed some time prior, the trigger that it had placed on the database's Modules table had not been removed or disabled resulting in this error and the failure to add any module to a page. As a further bit of background, be aware that the ModuleTitle column (and two others, ModuleHeader and ModuleFooter if I recall correctly) was moved from the Modules table to the TabModules table in DotNetNuke 5.05.00.
The fix for this error being logged and for the addition of modules to a page failing is to open the database using Microsoft SQL Server Management Studio or other similar tool and open the Triggers node of the Modules table. You may then either remove or disable the trigger. However, note that whatever module (probably Messaging or Taxonomy) which was to be added to a page as part of the 5.03.00 upgrade also failed. Your best course may be to roll back to the 4.09.05 database and files backup which you (hopefully) made, remove/disable the trigger on the Modules table, then re-run the upgrade to 05.05.01.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
| |
|
|
Joined: 6/9/2008
Posts: 11
|
|
|
I did check and there is a trigger called ifty_ilm_onNewModule. I looked at the code for that module and it references the ifinity url master.
I did make a backup prior to upgrading, so I can revert back, delete the trigger and try the upgrade again.
However, is there any way to determine which scripts are run during a specific phase of an upgrade and possible run them manually or do you think that could break some other update that was made after that one was origianlly supposed to be run?
|
| |
|
|
| |