|
|
|
www.bellingham-marine.com Joined: 1/18/2006
Posts: 27
|
|
|
Since upgrading to version DNN 5.5.1 my page containg a Calendar no longer functions. I show a page load error in the Event Log as follows:
ModuleId: 582
ModuleDefId: -1
FriendlyName:
ModuleControlSource: Admin/Modules/ModuleSettings.ascx
AssemblyVersion: 5.5.1
PortalID: 0
PortalName: ProtalName
UserID: 3
UserName: UserName
ActiveTabID: 95
ActiveTabName: Schedules
RawURL: /Schedules/tabid/95/ctl/Module/ModuleId/582/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET4.0C; .NET4.0E)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 90887b73-1a2c-4741-acb2-5312a6e73441
InnerException: Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. 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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Calendar.Data.SqlDataProvider.CalendarMasterAvailableModules(Int32 PortalID, Int32 ModuleID) at DotNetNuke.Modules.Calendar.Business.CalendarMasterController.CalendarMasterAvailableModules(Int32 PortalID, Int32 ModuleID) at DotNetNuke.Modules.CalendarList.CalendarListSettings.BindAvailableCalendars() at DotNetNuke.Modules.CalendarList.CalendarListSettings.LoadSettings() at DotNetNuke.Modules.Admin.Modules.ModuleSettingsPage.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: ServerName
My Calendar version is 3.2.0.
I also show a Module Load error in the Event Log as follows:
ModuleId: 582
ModuleDefId: -1
FriendlyName:
ModuleControlSource: Admin/Modules/ModuleSettings.ascx
AssemblyVersion: 5.5.1
PortalID: 0
PortalName: PortalNameUserID: 3
UserName: UserNameActiveTabID: 95
ActiveTabName: Schedules
RawURL: /Schedules/tabid/95/ctl/Module/ModuleId/582/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET4.0C; .NET4.0E)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 90887b73-1a2c-4741-acb2-5312a6e73441
InnerException: Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. ---> System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. 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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Calendar.Data.SqlDataProvider.CalendarMasterAvailableModules(Int32 PortalID, Int32 ModuleID) at DotNetNuke.Modules.Calendar.Business.CalendarMasterController.CalendarMasterAvailableModules(Int32 PortalID, Int32 ModuleID) at DotNetNuke.Modules.CalendarList.CalendarListSettings.BindAvailableCalendars() at DotNetNuke.Modules.CalendarList.CalendarListSettings.LoadSettings() at DotNetNuke.Modules.Admin.Modules.ModuleSettingsPage.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: ServerName
I've cleared all of the items in the Calendar database so I should get a blank calendar. It also appears that the Page Load error occurs before the Modlue Load error.
Can someone help me to resolve these errors so that I can get the Calendar functional again?
Thanks!
|
|
|
|
| |
|
|
|
www.wesnetdesigns.com Joined: 2/18/2005
Posts: 3253
|
|
|
Please see this pinned post in the Events module forum:
http://www.dotnetnuke.com/Community/F...
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
|
|
|
|
| |
|
|
www.bellingham-marine.com Joined: 1/18/2006
Posts: 27
|
|
|
Thanks, Bill. I am using the latest "Events" version.
|
|
|
|
| |
|
|
www.bellingham-marine.com Joined: 1/18/2006
Posts: 27
|
|
|
I tried upgrading the "Events" module to the RC version 5.1.5 but that didn't help. I aslo tried adding a new Calendar module to the page and then went into its settings. As soon as I clicked on the option to set it as "Master" I got the following error:
An error has occurred.
DotNetNuke.Services.Exceptions.PageLoadException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. ---> System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value) at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value) at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) 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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Calendar.Data.SqlDataProvider.CalendarGetByRange(Int32 ModuleID, DateTime BeginDate, DateTime EndDate) at DotNetNuke.Modules.Calendar.Business.CalendarController.CalendarGetByRange(Int32 ModuleID, DateTime BeginDate, DateTime EndDate) at DotNetNuke.Modules.Calendar.Business.CalendarInfoHelper.LoadCalendarDateRange(Int32 ModuleID, DateTime BeginDate, DateTime EndDate, Boolean Initialize) at DotNetNuke.Modules.Calendar.CalendarMonth.BindDataGrid() at DotNetNuke.Modules.Calendar.CalendarMonth.Page_PreRender(Object sender, EventArgs e) at System.Web.UI.Control.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean
This is with no Events in the "Calendar" database.
|
|
|
|
| |
|
|
|
www.wesnetdesigns.com Joined: 2/18/2005
Posts: 3253
|
|
|
Kevin,
If I had looked more closely at the stack traces you provided I would have realized that your issue is not with the standard DotNetNuke events module (sometimes referred to as the DotNetNuke calendar) but with a module having the namespace of DotNetNuke.Modules.Calendar. Since the error you are receiving is the same as in versions of the standard DotNetNuke events module prior to v 5.01.04 when running on DotNetNuke v 5.05.0x, I had jumped to the incorrect conclusion that you needed to upgrade to Events v 5.01.04.
Seeing that your calandar module was version 3.02.00 I then thought that you might have an early version of the events module (back when it was the AVCalendar) but after researching the version history of that module have concluded that your calendar module is a third party component. I did several Google searches for DotNetNuke calendar modules and also the DotNetNuke.Modules.Calendar namespace without determining who is the developer/vendor of that particular module. Try looking on the Host-->Extensions page for the module's developer information (if it has a DNN 5 compatible manifest) and in it's sub-folder under the DesktopModule's folder. If you want to continue using that particular module you will need to contact its developer/vendor to obtain an upgraded version that is compatible with DNN 5.05.0x.
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
|
|
|
|
| |