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