|
 |
Joined: 9/15/2010
Posts: 30
|
|
|
Hi Team,
I am getting a error in the event module after installation when I am going to edit the item. I have installed the version Events_05.00.03_Install.zip. I am giving the error as below
| Info |
Starting Installation - DNN_Events |
| Info |
Starting Installation - Script |
| Info |
Begin Sql execution |
| Info |
Created - 03.01.00.SqlDataProvider |
| Info |
Executing 03.01.00.SqlDataProvider |
| Info |
Start Sql execution: 03.01.00.SqlDataProvider file |
| Info |
End Sql execution: 03.01.00.SqlDataProvider file |
| Info |
Created - 03.02.00.SqlDataProvider |
| Info |
Executing 03.02.00.SqlDataProvider |
| Info |
Start Sql execution: 03.02.00.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterAssignedModules ( @ModuleID int ) AS Select a.ModuleID as ModuleID, 0 as PortalID, a.MasterID, a.SubEventID as SubEventID, b.ModuleTitle as SubEventTitle from dbo.EventsMaster a join dbo.Modules b on a.SubEventID = b.ModuleID WHERE a.ModuleID = @ModuleID Group BY b.ModuleTitle, a.MasterID, a.ModuleID, a.SubEventID Order By b.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterAvailableModules ( @PortalID int, @ModuleID int ) AS Select @ModuleID as ModuleID, c.PortalID, 0 as MasterID, a.ModuleID as SubEventID, a.ModuleTitle as SubEventTitle from dbo.Modules a left join dbo.ModuleDefinitions b on a.ModuleDefID = b.ModuleDefID left join dbo.ModuleControls d on b.ModuleDefID = d.ModuleDefID left join dbo.TabModules t on a.ModuleID = t.ModuleID left join dbo.Tabs c on t.TabID = c.TabID where d.ControlSrc = 'DesktopModules/Events/Events.ascx' AND c.PortalID = @PortalID and a.ModuleID Not In (select SubEventID from dbo.EventsMaster where ModuleID = @ModuleID) AND a.ModuleID Not In (select ModuleID from dbo.EventsMaster where SubEventID = @ModuleID) AND a.ModuleID != @ModuleID Group BY a.ModuleTitle, c.PortalID, a.ModuleID Order By a.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterGet ( @ModuleID int, @SubEventID int ) AS Select @ModuleID as ModuleID, b.PortalID, 0 as MasterID, a.ModuleID as SubEventID, a.ModuleTitle as SubEventTitle from dbo.Modules a left join dbo.TabModules t on a.ModuleID = t.ModuleID left join dbo.Tabs b on t.TabID = b.TabID where a.ModuleID = @SubEventID Group BY a.ModuleTitle, b.PortalID, a.ModuleID Order By a.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterSave ( @MasterID int, @ModuleID int, @SubEventID int ) AS IF @MasterID = 0 OR @MasterID IS NULL INSERT dbo.EventsMaster ( ModuleID, SubEventID ) VALUES ( @ModuleID, @SubEventID ) ELSE UPDATE dbo.EventsMaster SET ModuleID = @ModuleID, SubEventID = @SubEventID WHERE MasterID = @MasterID Select a.MasterID, a.ModuleID, b.ModuleTitle, a.SubEventID from dbo.EventsMaster a left join dbo.Modules b on a.SubEventID = b.ModuleID WHERE a.MasterID = @@Identity Group BY a.MasterID, a.ModuleID, b.ModuleTitle, a.SubEventID System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsAVCalendarList ( @PortalID int ) AS SELECT ModuleID, Version + ' - ' + ModuleTitle as VersionTitle FROM dbo.Modules M left join dbo.ModuleDefinitions b on M.ModuleDefID = b.ModuleDefID left join dbo.DesktopModules c on b.DesktopModuleID = c.DesktopModuleID WHERE c.ModuleName = 'Calendar' AND PortalID = @PortalID |
| Info |
End Sql execution: 03.02.00.SqlDataProvider file |
| Info |
Created - 03.03.00.SqlDataProvider |
| Info |
Executing 03.03.00.SqlDataProvider |
| Info |
Start Sql execution: 03.03.00.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGetByRange ( @Modules nvarchar(255), @BeginDate datetime, @EndDate datetime, @Category nvarchar(50) ) AS SET DATEFORMAT mdy IF (LEN(@Modules) = 0) BEGIN /** Added for Module Notification Scheduling NOTE: This version also checks for SendReminder = True **/ SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, -- CreatedBy = Users.FirstName + ' ' + Users.LastName, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventDateBegin BETWEEN @BeginDate AND @EndDate) OR (EventDateBegin <=@EndDate AND EventDateEnd >= @EndDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END ELSE BEGIN SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, -- CreatedBy = Users.FirstName + ' ' + Users.LastName, createdBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, (Select ModuleTitle from Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join EventsCategory b on E.Category = b.Category left join EventsLocation c on E.Location = c.Location WHERE (((EventDateBegin BETWEEN @BeginDate AND @EndDate) OR (EventDateBegin <=@EndDate AND EventDateEnd >= @EndDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END |
| Info |
End Sql execution: 03.03.00.SqlDataProvider file |
| Info |
Created - 03.03.01.SqlDataProvider |
| Info |
Executing 03.03.01.SqlDataProvider |
| Info |
Start Sql execution: 03.03.01.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGetByRange ( @Modules nvarchar(255), @BeginDate datetime, @EndDate datetime, @Category nvarchar(50) ) AS SET DATEFORMAT mdy IF (LEN(@Modules) = 0) BEGIN /** Added for Module Notification Scheduling NOTE: This version also checks for SendReminder = True **/ SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, -- CreatedBy = Users.FirstName + ' ' + Users.LastName, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join EventsCategory b on E.Category = b.Category left join EventsLocation c on E.Location = c.Location WHERE (((EventDateBegin BETWEEN @BeginDate AND @EndDate) OR (EventDateBegin <=@EndDate AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END ELSE BEGIN SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, -- CreatedBy = Users.FirstName + ' ' + Users.LastName, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventDateBegin BETWEEN @BeginDate AND @EndDate) OR (EventDateBegin <=@EndDate AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END |
| Info |
End Sql execution: 03.03.01.SqlDataProvider file |
| Info |
Created - 03.03.02.SqlDataProvider |
| Info |
Executing 03.03.02.SqlDataProvider |
| Info |
Start Sql execution: 03.03.02.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGetByRange ( @Modules nvarchar(255), @BeginDate datetime, @EndDate datetime, @Category nvarchar(50) ) AS SET DATEFORMAT mdy IF (LEN(@Modules) = 0) BEGIN /** Added for Module Notification Scheduling NOTE: This version also checks for SendReminder = True **/ SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, -- CreatedBy = Users.FirstName + ' ' + Users.LastName, CreatedBy = u.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM Events E left outer join Users U on E.CreatedBy = U.UserID left join EventsCategory b on E.Category = b.Category left join EventsLocation c on E.Location = c.Location WHERE (((EventDateBegin BETWEEN @BeginDate AND @EndDate) OR (EventDateBegin <=@EndDate AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END ELSE BEGIN SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, -- CreatedBy = Users.FirstName + ' ' + Users.LastName, CreatedBy = u.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventDateBegin BETWEEN @BeginDate AND @EndDate) OR (EventDateBegin <=@EndDate AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END |
| Info |
End Sql execution: 03.03.02.SqlDataProvider file |
| Info |
Created - 03.03.03.SqlDataProvider |
| Info |
Executing 03.03.03.SqlDataProvider |
| Info |
Start Sql execution: 03.03.03.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGet ( @EventID int ) AS SET DATEFORMAT mdy SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, --CreatedBy = Users.FirstName + ' ' + Users.LastName, CreatedBy = u.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE EventID = @EventID |
| Info |
End Sql execution: 03.03.03.SqlDataProvider file |
| Info |
Created - 03.03.05.SqlDataProvider |
| Info |
Executing 03.03.05.SqlDataProvider |
| Info |
Start Sql execution: 03.03.05.SqlDataProvider file |
| Info |
End Sql execution: 03.03.05.SqlDataProvider file |
| Info |
Created - 03.03.07.SqlDataProvider |
| Info |
Executing 03.03.07.SqlDataProvider |
| Info |
Start Sql execution: 03.03.07.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterAvailableModules ( @PortalID int, @ModuleID int ) AS Select @ModuleID as ModuleID, c.PortalID, 0 as MasterID, a.ModuleID as SubEventID, a.ModuleTitle as SubEventTitle from dbo.Modules a left join dbo.ModuleDefinitions b on a.ModuleDefID = b.ModuleDefID left join dbo.DesktopModules d on b.DesktopModuleID = d.DesktopModuleID left join dbo.TabModules t on a.ModuleID = t.ModuleID left join dbo.Tabs c on t.TabID = c.TabID where d.BusinessControllerClass = 'DotNetNuke.Modules.Events.EventController, DotNetNuke.Modules.Events' AND c.PortalID = @PortalID and a.ModuleID Not In (select SubEventID from dbo.EventsMaster where ModuleID = @ModuleID) AND a.ModuleID Not In (select ModuleID from dbo.EventsMaster where SubEventID = @ModuleID) AND a.ModuleID != @ModuleID Group BY a.ModuleTitle, c.PortalID, a.ModuleID Order By a.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterSave ( @MasterID int, @ModuleID int, @SubEventID int ) AS IF @MasterID = 0 OR @MasterID IS NULL INSERT dbo.EventsMaster ( ModuleID, SubEventID ) VALUES ( @ModuleID, @SubEventID ) ELSE UPDATE dbo.EventsMaster SET ModuleID = @ModuleID, SubEventID = @SubEventID WHERE MasterID = @MasterID Select a.MasterID, a.ModuleID, b.ModuleTitle, a.SubEventID from dbo.EventsMaster a left join dbo.Modules b on a.SubEventID = b.ModuleID WHERE a.MasterID = scope_identity() Group BY a.MasterID, a.ModuleID, b.ModuleTitle, a.SubEventID |
| Info |
End Sql execution: 03.03.07.SqlDataProvider file |
| Info |
Created - 03.03.08.SqlDataProvider |
| Info |
Executing 03.03.08.SqlDataProvider |
| Info |
Start Sql execution: 03.03.08.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGetByRange ( @Modules nvarchar(255), @BeginDate datetime, @EndDate datetime, @Category nvarchar(50) ) AS SET DATEFORMAT mdy IF (LEN(@Modules) = 0) BEGIN /** Added for Module Notification Scheduling NOTE: This version also checks for SendReminder = True **/ SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, --CreatedBy = Users.FirstName + ' ' + Users.LastName, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventTimeBegin <= @EndDate AND DATEADD(minute,Duration,EventTimeBegin) >= @BeginDate) OR (EventTimeBegin BETWEEN @BeginDate AND @EndDate) OR (EventTimeBegin <=@EndDate AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END ELSE BEGIN SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, --CreatedBy = Users.FirstName + ' ' + Users.LastName, createdBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, (Select ModuleTitle from Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventTimeBegin <= @EndDate AND DATEADD(minute,Duration,EventTimeBegin) >= @BeginDate) OR (EventTimeBegin BETWEEN @BeginDate AND @EndDate) OR (EventTimeBegin <=@EndDate AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END |
| Info |
End Sql execution: 03.03.08.SqlDataProvider file |
| Info |
Created - 04.00.00.SqlDataProvider |
| Info |
Executing 04.00.00.SqlDataProvider |
| Info |
Start Sql execution: 04.00.00.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGetByRange ( @Modules nvarchar(255), @BeginDate datetime, @EndDate datetime, @Category nvarchar(50) ) AS SET DATEFORMAT mdy IF (LEN(@Modules) = 0) BEGIN /** Added for Module Notification Scheduling NOTE: This version Solves EndDate issue by Adding 1 day to EndDate for WHERE clause **/ SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventTimeBegin <= DATEADD(DAY,1,@EndDate) AND DATEADD(minute,Duration,EventTimeBegin) >= @BeginDate) OR (EventTimeBegin BETWEEN @BeginDate AND DATEADD(DAY,1,@EndDate)) OR (EventTimeBegin <=DATEADD(DAY,1,@EndDate) AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END ELSE BEGIN SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, createdBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventTimeBegin <= DATEADD(DAY,1,@EndDate) AND DATEADD(minute,Duration,EventTimeBegin) >= @BeginDate) OR (EventTimeBegin BETWEEN @BeginDate AND DATEADD(DAY,1,@EndDate)) OR (EventTimeBegin <=DATEADD(DAY,1,@EndDate) AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGet ( @EventID int ) AS SET DATEFORMAT mdy SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, --CreatedBy = dbo.Users.FirstName + ' ' + dbo.Users.LastName, CreatedBy = u.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE EventID = @EventID System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterAssignedModules ( @ModuleID int ) AS Select a.ModuleID as ModuleID, 0 as PortalID, a.MasterID, a.SubEventID as SubEventID, b.ModuleTitle as SubEventTitle from dbo.EventsMaster a join dbo.Modules b on a.SubEventID = b.ModuleID WHERE a.ModuleID = @ModuleID Group BY b.ModuleTitle, a.MasterID, a.ModuleID, a.SubEventID Order By b.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterAvailableModules ( @PortalID int, @ModuleID int ) AS Select @ModuleID as ModuleID, c.PortalID, 0 as MasterID, a.ModuleID as SubEventID, a.ModuleTitle as SubEventTitle from dbo.Modules a left join dbo.ModuleDefinitions b on a.ModuleDefID = b.ModuleDefID left join dbo.DesktopModules d on b.DesktopModuleID = d.DesktopModuleID left join dbo.TabModules t on a.ModuleID = t.ModuleID left join dbo.Tabs c on t.TabID = c.TabID where d.BusinessControllerClass = 'DotNetNuke.Modules.Events.EventController, DotNetNuke.Modules.Events' AND c.PortalID = @PortalID and a.ModuleID Not In (select SubEventID from dbo.EventsMaster where ModuleID = @ModuleID) AND a.ModuleID Not In (select ModuleID from dbo.EventsMaster where SubEventID = @ModuleID) AND a.ModuleID != @ModuleID Group BY a.ModuleTitle, c.PortalID, a.ModuleID Order By a.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterGet ( @ModuleID int, @SubEventID int ) AS Select @ModuleID as ModuleID, b.PortalID, 0 as MasterID, a.ModuleID as SubEventID, a.ModuleTitle as SubEventTitle from dbo.Modules a left join dbo.TabModules t on a.ModuleID = t.ModuleID left join dbo.Tabs b on t.TabID = b.TabID where a.ModuleID = @SubEventID Group BY a.ModuleTitle, b.PortalID, a.ModuleID Order By a.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsMasterSave ( @MasterID int, @ModuleID int, @SubEventID int ) AS IF @MasterID = 0 OR @MasterID IS NULL INSERT dbo.EventsMaster ( ModuleID, SubEventID ) VALUES ( @ModuleID, @SubEventID ) ELSE UPDATE dbo.EventsMaster SET ModuleID = @ModuleID, SubEventID = @SubEventID WHERE MasterID = @MasterID Select a.MasterID, a.ModuleID, b.ModuleTitle, a.SubEventID from dbo.EventsMaster a left join dbo.Modules b on a.SubEventID = b.ModuleID WHERE a.MasterID = scope_identity() Group BY a.MasterID, a.ModuleID, b.ModuleTitle, a.SubEventID |
| Info |
End Sql execution: 04.00.00.SqlDataProvider file |
| Info |
Created - 04.00.01.SqlDataProvider |
| Info |
Executing 04.00.01.SqlDataProvider |
| Info |
Start Sql execution: 04.00.01.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGet ( @EventID int, @ModuleID int ) AS SET DATEFORMAT mdy SELECT E.PortalID, EventID, e.ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, --CreatedBy = dbo.Users.FirstName + ' ' + dbo.Users.LastName, CreatedBy = u.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, CustomField1, CustomField2, LastUpdatedAt, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location left outer join dbo.EventsMaster m ON e.ModuleID = m.SubEventID WHERE EventID = @EventID And (e.ModuleID = @ModuleID Or m.ModuleID = @ModuleID) System.Data.SqlClient.SqlException (0x80131904): 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() 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.EventsGetByRange ( @Modules nvarchar(255), @BeginDate datetime, @EndDate datetime, @Category nvarchar(50) ) AS SET DATEFORMAT mdy IF (LEN(@Modules) = 0) BEGIN /** Added for Module Notification Scheduling NOTE: This version Solves EndDate issue by Adding 1 day to EndDate for WHERE clause **/ SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, CustomField1, CustomField2, LastUpdatedAt, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventTimeBegin <= DATEADD(DAY,1,@EndDate) AND DATEADD(minute,Duration,EventTimeBegin) >= @BeginDate) OR (EventTimeBegin BETWEEN @BeginDate AND DATEADD(DAY,1,@EndDate)) OR (EventTimeBegin <=DATEADD(DAY,1,@EndDate) AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END ELSE BEGIN SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, createdBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, CustomField1, CustomField2, LastUpdatedAt, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((EventTimeBegin <= DATEADD(DAY,1,@EndDate) AND DATEADD(minute,Duration,EventTimeBegin) >= @BeginDate) OR (EventTimeBegin BETWEEN @BeginDate AND DATEADD(DAY,1,@EndDate)) OR (EventTimeBegin <=DATEADD(DAY,1,@EndDate) AND EventDateEnd >= @BeginDate AND RepeatType <> 'N')) AND (ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END |
| Info |
End Sql execution: 04.00.01.SqlDataProvider file |
| Info |
Created - 04.00.02.SqlDataProvider |
| Info |
Executing 04.00.02.SqlDataProvider |
| Info |
Start Sql execution: 04.00.02.SqlDataProvider file |
| Info |
End Sql execution: 04.00.02.SqlDataProvider file |
| Info |
Created - 04.01.00.SqlDataProvider |
| Info |
Executing 04.01.00.SqlDataProvider |
| Info |
Start Sql execution: 04.01.00.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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) /*** EventsGetByRange ***/ CREATE PROCEDURE dbo.EventsGetByRange ( @Modules nvarchar(255), @BeginDate datetime, @EndDate datetime, @Category nvarchar(50) ) AS SET DATEFORMAT mdy IF (LEN(@Modules) = 0) BEGIN /** Added for Module Notification Scheduling NOTE: This version Solves EndDate issue by Adding 1 day to EndDate for WHERE clause **/ SELECT E.PortalID, E.EventID, E.RecurMasterID, E.ModuleID, E.EventDateBegin, E.EventDateEnd, E.EventTimeBegin, E.Duration, E.EventName, E.EventDesc, E.Importance, E.CreatedDate, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, E.Every, E.Period, E.RepeatType, E.Notify, E.approved, E.Signups, E.MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, E.EnrollRoleID, E.EnrollFee, E.EnrollType, E.PayPalAccount, E.PayPalPassword, E.Cancelled, E.ImageURL, E.ImageType, E.ImageWidth, E.ImageHeight, E.ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, E.Reminder, E.TimezoneOffset, E.SendReminder, E.ReminderTime, E.ReminderTimeMeasurement, E.ReminderFrom, E.SearchSubmitted, E.CustomField1, E.CustomField2, E.EnrollListView, E.DisplayEndDate, E.AllDayEvent, E.OwnerID, OwnerName = O.DisplayName, E.LastUpdatedAt, LastUpdatedBy = L.DisplayName, E.LastUpdatedID, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle, RMOwnerID = r.OwnerID, r.RRULE, E.OriginalDateBegin, E.NewEventEmailSent FROM dbo.Events E inner join dbo.EventsRecurMaster AS r on E.RecurMasterID = r.RecurMasterID left outer join dbo.Users U on E.CreatedBy = U.UserID left outer join dbo.Users O on E.OwnerID = O.UserID left outer join dbo.Users L on E.LastUpdatedID = L.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((E.EventTimeBegin <= DATEADD(DAY,1,@EndDate) AND DATEADD(minute,E.Duration,E.EventTimeBegin) >= @BeginDate) OR (E.EventTimeBegin BETWEEN @BeginDate AND DATEADD(DAY,1,@EndDate)) OR (E.EventTimeBegin <=DATEADD(DAY,1,@EndDate) AND E.EventDateEnd >= @BeginDate AND E.RepeatType <> 'N')) AND (E.ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (E.Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) AND E.Cancelled = 0 ORDER BY E.EventDateBegin, E.EventTimeBegin, E.EventDateEnd END ELSE BEGIN SELECT E.PortalID, E.EventID, E.RecurMasterID, E.ModuleID, E.EventDateBegin, E.EventDateEnd, E.EventTimeBegin, E.Duration, E.EventName, E.EventDesc, E.Importance, E.CreatedDate, createdBy = U.DisplayName, CreatorID = E.CreatedBy, E.Every, E.Period, E.RepeatType, E.Notify, E.Approved, E.Signups, E.MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, E.EnrollRoleID, E.EnrollFee, E.EnrollType, E.PayPalAccount, E.PayPalPassword, E.Cancelled, E.ImageURL, E.ImageType, E.ImageWidth, E.ImageHeight, E.ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, E.Reminder, E.TimezoneOffset, E.SendReminder, E.ReminderTime, E.ReminderTimeMeasurement, E.CustomField1, E.CustomField2, E.EnrollListView, E.DisplayEndDate, E.AllDayEvent, E.OwnerID, OwnerName = O.DisplayName, E.LastUpdatedAt, LastUpdatedBy = L.DisplayName, E.LastUpdatedID, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle, RMOwnerID = r.OwnerID, r.RRULE, E.OriginalDateBegin, E.NewEventEmailSent FROM dbo.Events E inner join dbo.EventsRecurMaster AS r on E.RecurMasterID = r.RecurMasterID left outer join dbo.Users U on E.CreatedBy = U.UserID left outer join dbo.Users O on E.OwnerID = O.UserID left outer join dbo.Users L on E.LastUpdatedID = L.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (((E.EventTimeBegin <= DATEADD(DAY,1,@EndDate) AND DATEADD(minute,E.Duration,E.EventTimeBegin) >= @BeginDate) OR (E.EventTimeBegin BETWEEN @BeginDate AND DATEADD(DAY,1,@EndDate)) OR (E.EventTimeBegin <=DATEADD(DAY,1,@EndDate) AND E.EventDateEnd >= @BeginDate AND E.RepeatType <> 'N')) AND (E.ModuleID in (SELECT * FROM dbo.[SplitIDs](@Modules))) AND (E.Approved = 1) AND (b.CategoryName = @Category OR @Category = '')) AND E.Cancelled = 0 ORDER BY E.EventDateBegin, E.EventTimeBegin, E.EventDateEnd END System.Data.SqlClient.SqlException (0x80131904): 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() 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) /*** EventsGetRecurrences ***/ CREATE PROCEDURE dbo.EventsGetRecurrences ( @RecurMasterID int, @ModuleID int ) AS SELECT E.PortalID, EventID, RecurMasterID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, CustomField1, CustomField2, EnrollListView, DisplayEndDate, AllDayEvent, OwnerID, OwnerName = O.DisplayName, LastUpdatedAt, LastUpdatedBy = L.DisplayName, LastUpdatedID, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle, OriginalDateBegin, NewEventEmailSent FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left outer join dbo.Users O on E.OwnerID = O.UserID left outer join dbo.Users L on E.LastUpdatedID = L.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (RecurMasterID = @RecurMasterID AND ModuleID = @ModuleID) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd |
| Info |
End Sql execution: 04.01.00.SqlDataProvider file |
| Info |
Created - 04.01.01.SqlDataProvider |
| Info |
Executing 04.01.01.SqlDataProvider |
| Info |
Start Sql execution: 04.01.01.SqlDataProvider file |
| Info |
End Sql execution: 04.01.01.SqlDataProvider file |
| Info |
Created - 04.01.02.SqlDataProvider |
| Info |
Executing 04.01.02.SqlDataProvider |
| Info |
Start Sql execution: 04.01.02.SqlDataProvider file |
| Info |
End Sql execution: 04.01.02.SqlDataProvider file |
| Info |
Created - 05.00.00.SqlDataProvider |
| Info |
Executing 05.00.00.SqlDataProvider |
| Info |
Start Sql execution: 05.00.00.SqlDataProvider file |
| Info |
End Sql execution: 05.00.00.SqlDataProvider file |
| Info |
Created - 05.00.01.SqlDataProvider |
| Info |
Executing 05.00.01.SqlDataProvider |
| Info |
Start Sql execution: 05.00.01.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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) /*** EventsGetRecurrences ***/ CREATE PROCEDURE dbo.EventsGetRecurrences ( @RecurMasterID int, @ModuleID int ) AS SELECT E.PortalID, EventID, RecurMasterID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, CreatedBy = U.DisplayName, CreatorID = E.CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, DetailPage, DetailNewWin, DetailURL, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, CustomField1, CustomField2, EnrollListView, DisplayEndDate, AllDayEvent, OwnerID, OwnerName = O.DisplayName, LastUpdatedAt, LastUpdatedBy = L.DisplayName, LastUpdatedID, (Select ModuleTitle from dbo.Modules WHERE ModuleID = E.ModuleID) as ModuleTitle, OriginalDateBegin, NewEventEmailSent FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID left outer join dbo.Users O on E.OwnerID = O.UserID left outer join dbo.Users L on E.LastUpdatedID = L.UserID left join dbo.EventsCategory b on E.Category = b.Category left join dbo.EventsLocation c on E.Location = c.Location WHERE (RecurMasterID = @RecurMasterID AND ModuleID = @ModuleID) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd |
| Info |
End Sql execution: 05.00.01.SqlDataProvider file |
| Info |
Created - 05.00.02.SqlDataProvider |
| Info |
Executing 05.00.02.SqlDataProvider |
| Info |
Start Sql execution: 05.00.02.SqlDataProvider file |
| Info |
End Sql execution: 05.00.02.SqlDataProvider file |
| Info |
Created - 05.00.03.SqlDataProvider |
| Info |
Executing 05.00.03.SqlDataProvider |
| Info |
Start Sql execution: 05.00.03.SqlDataProvider file |
| Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 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() 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) /*** EventsGetRecurrences ***/ CREATE PROCEDURE dbo.[EventsGetRecurrences] ( @RecurMasterID int, @ModuleID int ) AS SELECT E.PortalID, EventID, RecurMasterID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, E.CreatedDate, CreatedBy = U.DisplayName, E.CreatedByID, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, (Select count(*) from dbo.[EventsSignups] WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, Cancelled, DetailPage, DetailNewWin, DetailURL, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, E.Location, c.LocationName, c.MapURL, E.Category, b.CategoryName, b.Color, b.FontColor, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted, CustomField1, CustomField2, EnrollListView, DisplayEndDate, AllDayEvent, OwnerID, OwnerName = O.DisplayName, LastUpdatedAt, LastUpdatedBy = L.DisplayName, LastUpdatedID, (Select ModuleTitle from dbo.[Modules] WHERE ModuleID = E.ModuleID) as ModuleTitle, OriginalDateBegin, NewEventEmailSent FROM dbo.[Events] E left outer join dbo.[Users] U on E.CreatedByID = U.UserID left outer join dbo.[Users] O on E.OwnerID = O.UserID left outer join dbo.[Users] L on E.LastUpdatedID = L.UserID left join dbo.[EventsCategory] b on E.Category = b.Category left join dbo.[EventsLocation] c on E.Location = c.Location WHERE (RecurMasterID = @RecurMasterID AND ModuleID = @ModuleID) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd |
| Info |
End Sql execution: 05.00.03.SqlDataProvider file |
| Info |
Created - Uninstall.SqlDataProvider |
| Info |
Finished Sql execution |
| Info |
Component installed successfully - Script |
| Info |
Starting Installation - Cleanup |
|
| |
|
|