Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...Problem With Calendar ModuleProblem With Calendar Module
Previous
 
Next
New Post
10/5/2010 11:47 AM
 
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!
 
New Post
10/5/2010 1:45 PM
 
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
 
New Post
10/5/2010 2:10 PM
 
Thanks, Bill. I am using the latest "Events" version.
 
New Post
10/5/2010 5:25 PM
 
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.
 
New Post
10/5/2010 8:15 PM
 
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
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...Problem With Calendar ModuleProblem With Calendar Module


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out