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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsEvents Module 03.03.00 Beta UploadedEvents Module 03.03.00 Beta Uploaded
Previous
 
Next
New Post
2/6/2007 1:36 PM
 

Hi,

Just trying to install Events 03.03.01 on DNN 4.4.1.  

During the install I get a single long error SQL showed below. (Errors with 3.3.0 SQL script which seems to be fixed in 3.3.1 since the SProcs are created in the DB at the end of the install process).

Then, the module does show up as 3.3.1 in Module Definitions.  The module can be added to a tab. Though once I try to go Settings to initially configure the module, I get the following:

Error: Module is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(PortalModuleBase ctrlModule, Exception exc) at DotNetNuke.Modules.Events.EventController.UpgradeEvents(Int32 ModuleID) at DotNetNuke.Modules.Events.Settings.LoadSettings() at DotNetNuke.Modules.Admin.Modules.ModuleSettingsPage.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace

 

 

StartJob Begin Sql execution
Info Executing 03.03.00.SqlDataProvider
StartJob Start Sql execution: 03.03.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'EventTimeBegin'. Invalid column name 'TimeZoneOffset'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSignupsGet ( @SignupID int ) AS SET DATEFORMAT mdy Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, u.FirstName + ' ' + u.LastName as UserName,u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, s.TimeZoneOffset from EventsSignups s Left Join Users u ON s.UserID = u.UserID Left Join Events c ON s.EventID = c.EventID Where s.SignupID = @SignupID System.Data.SqlClient.SqlException: Invalid column name 'EventTimeBegin'. Invalid column name 'TimeZoneOffset'. Invalid column name 'EventTimeBegin'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSignupsGetEvent ( @EventID int ) AS SET DATEFORMAT mdy Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, u.FirstName + ' ' + u.LastName as UserName,u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, s.TimeZoneOffset from EventsSignups s Left Join Users u ON s.UserID = u.UserID Left Join Events c ON s.EventID = c.EventID Where s.EventID = @EventID ORDER BY s.EventTimeBegin, c.EventName, UserName System.Data.SqlClient.SqlException: Invalid column name 'EventTimeBegin'. Invalid column name 'TimeZoneOffset'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSignupsGetUser ( @EventID int, @UserID int ) AS SET DATEFORMAT mdy Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, u.FirstName + ' ' + u.LastName as UserName,u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, s.TimeZoneOffset from EventsSignups s Left Join Users u ON s.UserID = u.UserID Left Join Events c ON s.EventID = c.EventID Where s.EventID = @EventID And s.Userid = @UserID System.Data.SqlClient.SqlException: Invalid column name 'EventTimeBegin'. Invalid column name 'TimeZoneOffset'. Invalid column name 'EventTimeBegin'. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSignupsMyEnrollments ( @ModuleID int, @UserID int ) AS SET DATEFORMAT mdy Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, u.FirstName + ' ' + u.LastName as UserName,u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from EventsSignups WHERE EventID = c.EventID and c.Signups = 1) as Enrolled, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, s.TimeZoneOffset from EventsSignups s Left Join Users u ON s.UserID = u.UserID Left Join Modules m on m.ModuleID = s.ModuleID Left Join TabModules x on m.ModuleID = x.ModuleID Left Join Tabs t on t.TabID = x.TabID Left Join Events c ON s.EventID = c.EventID Where s.Userid = @UserID AND t.PortalID = @ModuleID ORDER BY s.EventTimeBegin desc 
EndJob End Sql execution: 03.03.00.SqlDataProvider file


 
New Post
2/6/2007 3:27 PM
 

Alan,

Great work, glad to see some progress here.

I am not getting an enrollment link. I have tried various roles to see if it's role based. So far no roles get the link.

 
New Post
2/6/2007 3:40 PM
 

I also got a long SQL error during installation (won't quote it here). But this seems only to happen when formerly version 3.02 or no events module at all was installed. I didn't got this error with formerly installed version 3.03.00 Beta (although installation of 3.03.00 went through without errors).

But now another bug with recurring events and localization:

----------------------------------------------------
My DNN config: DNN 4.03.06.
My Events module config: 3.03.01 Beta1 (update from 3.03.00 Beta1)
----------------------------------------------------

If you select german language (de-DE) and then enter an annually recurring event  in the following format:

Annual Event: repeat on date "31.12." (note the TWO dots) which is "12/31" in en-US locale)

then ALL events in that module instance will disappear in all calendar views! They will show again if English (US) language is selected.
If you omit the second dot (i. e. if you enter "31.12"), everything's OK!

Note: date format in Germany is "DD.MM.YYYY". If you leave out the year, you nevertheless append a second dot after the month: ("DD.MM.").

 
New Post
2/6/2007 5:53 PM
 

For the Enrollment links to work:

1) Turn on Enrollments Checkbox on the Settings Page
2) Turn on Enrollments on the Event Edit and Set the Max # of Enrollments (also select Free or Paid)
3) After this Users (Registered Users) will see the Enrollment Link on the Detailed Event Page (only the first time the hit the page).  They can then select it and be enrolled (pending approval, if moderated)

 
New Post
2/6/2007 5:57 PM
 

Annual Event: repeat on date "31.12." (note the TWO dots) which is "12/31" in en-US locale)
then ALL events in that module instance will disappear in all calendar views! They will show again if English (US) language is selected.
If you omit the second dot (i. e. if you enter "31.12"), everything's OK!
Note: date format in Germany is "DD.MM.YYYY". If you leave out the year, you nevertheless append a second dot after the month: ("DD.MM.").

OK...I definitely don't understand this one?  How do you eliminate the second dot?  How are you setup that you do not have to enter year?  Steps to replicate?

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsEvents Module 03.03.00 Beta UploadedEvents Module 03.03.00 Beta Uploaded


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