Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ForumsEventsEventsInstall problem with Events_03.03.08_Install.zip Install problem with Events_03.03.08_Install.zip
Previous
 
Next
New Post
7/18/2007 8:23 AM
 
Richard Thurgood

Joined: 3/24/2004
Posts: 6

Re: Events Module 3.3.7 Released By rthurgood on 7/17/2007 Running DNN 3.1.1
Downloaded Events_03.03.08_Install.zip

Getting the following error when I try to add the module and now I cannot uninstall or revert to previous verion. When I try to delete the module, it says "DotNetNuke.Services.Exceptions.ModuleLoadException: The query has been canceled because the estimated cost of this query (200696) exceeds the configured threshold of 200. Contact the system administrator."

Here's the log from trying to install the module:

Resource Upload Logs
Return

StartJob Starting Installation
StartJob Reading files
Info Loading DotNetNuke.Modules.Events.dll
Info File DotNetNuke.Modules.Events.dll read successfully
Info Loading DotNetNuke.Modules.Events.SqlDataProvider.dll
Info File DotNetNuke.Modules.Events.SqlDataProvider.dll read successfully
Info Loading 03.01.00.SqlDataProvider
Info File 03.01.00.SqlDataProvider read successfully
Info Loading 03.02.00.SqlDataProvider
Info File 03.02.00.SqlDataProvider read successfully
Info Loading 03.03.00.SqlDataProvider
Info File 03.03.00.SqlDataProvider read successfully
Info Loading 03.03.02.SqlDataProvider
Info File 03.03.02.SqlDataProvider read successfully
Info Loading 03.03.03.SqlDataProvider
Info File 03.03.03.SqlDataProvider read successfully
Info Loading Uninstall.SqlDataProvider
Info File Uninstall.SqlDataProvider read successfully
Info Loading DotNetNuke.Events.ScheduleControl.dll
Info File DotNetNuke.Events.ScheduleControl.dll read successfully
Info Loading DotNetNuke.Events.WebControls.dll
Info File DotNetNuke.Events.WebControls.dll read successfully
Info Loading 03.03.05.SqlDataProvider
Info File 03.03.05.SqlDataProvider read successfully
Info Loading 03.03.01.SqlDataProvider
Info File 03.03.01.SqlDataProvider read successfully
Info Loading 03.03.07.SqlDataProvider
Info File 03.03.07.SqlDataProvider read successfully
Info Loading 03.03.08.SqlDataProvider
Info File 03.03.08.SqlDataProvider read successfully
Info Loading DNN_Events.dnn
Info File DNN_Events.dnn read successfully
Info Loading 03.03.08.txt
Info File 03.03.08.txt read successfully
Info Loading Resources.zip
Info File Resources.zip read successfully
EndJob Reading files done.

StartJob Reading DNN file
Info DNN file is in valid 3.0 format.
Info ...
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'Events' module
EndJob Dnn load finished successfully

StartJob Begin Sql execution
Info Executing 03.02.00.SqlDataProvider
StartJob Start Sql execution: 03.02.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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, CreatedDate, -- CreatedBy = U.FirstName + ' ' + U.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 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: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsGetByDate ( @EventDate datetime, @ModuleID int ) AS SET DATEFORMAT mdy SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, CreatedDate, --CreatedBy = U.FirstName + ' ' + U.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 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 EventsLocation c on E.Location = c.Location WHERE ((@EventDate BETWEEN EventDateBegin AND EventDateEnd) AND (ModuleID = @ModuleID) AND (Approved = 1)) OR ((EventDateEnd >= @EventDate) AND (ModuleID = @ModuleID) AND (Approved = 1)) ORDER BY (SELECT (datepart(hour, EventTimeBegin) * 10000) + (datepart(minute, EventTimeBegin) * 100) + (datepart(second, EventTimeBegin))) System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsGetByMonthYear ( @ModuleID int, @Month int, @Year int ) AS SET DATEFORMAT mdy SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, 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 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 ((MONTH(EventDateBegin) = @Month) AND (YEAR(EventDateBegin) = @Year) AND (ModuleID = @ModuleID) AND (Approved = 1)) OR ((MONTH(EventDateEnd) = @Month) AND (YEAR(EventDateEnd) = @Year) AND (ModuleID = @ModuleID) AND (Approved = 1)) ORDER BY EventDateBegin,EventDateEnd, (SELECT (datepart(hour, EventTimeBegin) * 10000) + (datepart(minute, EventTimeBegin) * 100) + (datepart(second, EventTimeBegin))) System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Added for Module Notification Scheduling NOTE: This version also checks for SendReminder = True **/ CREATE PROCEDURE dbo.EventsGetByRange ( @ModuleID int, @BeginDate datetime, @EndDate datetime ) AS SET DATEFORMAT mdy IF @ModuleID = 0 BEGIN SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, 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 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) AND (SendReminder = 1) AND (Approved = 1)) OR ((EventDateEnd >= @BeginDate) AND (SendReminder = 1) AND (Approved = 1)) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END ELSE BEGIN SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, 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 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) AND (ModuleID = @ModuleID) AND (Approved = 1)) OR ((EventDateEnd >= @BeginDate) AND (ModuleID = @ModuleID) AND (Approved = 1)) ORDER BY EventDateBegin, EventTimeBegin, EventDateEnd END System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsModerateEvents ( @ModuleID int ) AS SET DATEFORMAT mdy SELECT EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, CreatedDate, --CreatedBy = Users.FirstName + ' ' + Users.LastName, CreatedBy = U.DisplayName, CreatorID = CreatedBy, Every, Period, RepeatType, Notify, Approved, MaxEnrollment, (Select count(*) from dbo.EventsSignups WHERE EventID = E.EventID and E.Signups = 1) as Enrolled, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, TimeZoneOffset FROM dbo.Events E left outer join dbo.Users U on E.CreatedBy = U.UserID WHERE Approved = 0 AND ModuleID = @ModuleID ORDER BY EventDateBegin, EventDateEnd, (SELECT (datepart(hour, EventTimeBegin) * 10000) + (datepart(minute, EventTimeBegin) * 100) + (datepart(second, EventTimeBegin))) System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsModerateSignups ( @ModuleID int ) AS SET DATEFORMAT mdy Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, --u.FirstName + ' ' + u.LastName as UserName, u.DisplayName as UserName, u.Email, c.EventDateBegin, c.EventTimeBegin,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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, c.TimeZoneOffset from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.Approved = 0 AND s.ModuleID = @ModuleID ORDER BY c.EventDateBegin, c.EventTimeBegin, c.EventName, UserName System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSave ( @PortalID int, @EventID int, @ModuleID int, @EventDateBegin datetime, @EventDateEnd datetime, @EventTimeBegin datetime, @Duration int, @EventName nvarchar(100), @EventDesc ntext, @Importance int, @CreatedBy varchar(100), @CreatorID varchar(100), @Every int, @Period nvarchar(10), @RepeatType char(10), @Notify nvarchar(100), @Approved bit, @Signups bit, @MaxEnrollment int, @EnrollRoleID varchar(50), @EnrollFee money, @EnrollType varchar(10), @PayPalAccount varchar(100), @PayPalPassword varchar(100), @Cancelled bit, @ImageURL varchar(100), @ImageType varchar(1), @ImageWidth int, @ImageHeight int, @ImageDisplay bit, @Location int, @LocationName nvarchar(50), @MapURL varchar(255), @Category int, @CategoryName nvarchar(50), @Color varchar(10), @Reminder nvarchar(100), @TimezoneOffset int, @SendReminder bit, @ReminderTime int, @ReminderTimeMeasurement varchar(2), @ReminderFrom nvarchar(100), @SearchSubmitted bit ) AS SET DATEFORMAT mdy IF @EventID = -1 OR @EventID IS NULL INSERT dbo.Events ( PortalID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted ) VALUES ( @PortalID, @ModuleID, @EventDateBegin, @EventDateEnd, @EventTimeBegin, @Duration, @EventName, @EventDesc, @Importance, @CreatorID, @Every, @Period, @RepeatType, @Notify, @Approved, @Signups, @MaxEnrollment, @EnrollRoleID, @EnrollFee, @EnrollType, @PayPalAccount, @PayPalPassword, @Cancelled, @ImageURL, @ImageType, @ImageWidth, @ImageHeight, @ImageDisplay, @Location, @Category, @Reminder, @TimezoneOffset, @SendReminder, @ReminderTime, @ReminderTimeMeasurement, @ReminderFrom, @SearchSubmitted ) ELSE UPDATE dbo.Events SET PortalID = @PortalID, ModuleID = @ModuleID, EventDateBegin = @EventDateBegin, EventDateEnd = @EventDateEnd, EventTimeBegin = @EventTimeBegin, Duration = @Duration, EventName = @EventName, EventDesc = @EventDesc, Importance = @Importance, Every = @Every, Period = @Period, RepeatType = @RepeatType, Notify = @Notify, Approved = @Approved, Signups = @Signups, MaxEnrollment = @MaxEnrollment, EnrollRoleID = @EnrollRoleID, EnrollFee = @EnrollFee, EnrollType = @EnrollType, PayPalAccount = @PayPalAccount, PayPalPassword = @PayPalPassword, Cancelled = @Cancelled, ImageURL = @ImageURL, ImageType = @ImageType, ImageWidth = @ImageWidth, ImageHeight = @ImageHeight, ImageDisplay = @ImageDisplay, Location = @Location, Category = @Category, Reminder = @Reminder, TimezoneOffset = @TimezoneOffset, SendReminder = @SendReminder, ReminderTime = @ReminderTime, ReminderTimeMeasurement = @ReminderTimeMeasurement, ReminderFrom = @ReminderFrom, SearchSubmitted = @SearchSubmitted WHERE EventID = @EventID SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, 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, c.Location, c.LocationName, c.MapURL, b.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom 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 EventID = @@Identity System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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.DisplayName as UserName, u.Email, c.EventDateBegin, c.EventTimeBegin,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.SignupID = @SignupID System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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.DisplayName as UserName, u.Email, c.EventDateBegin, c.EventTimeBegin,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.EventID = @EventID ORDER BY c.EventDateBegin, c.EventTimeBegin, c.EventName, UserName System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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.DisplayName as UserName, u.Email, c.EventDateBegin, c.EventTimeBegin,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.EventID = @EventID And s.Userid = @UserID System.Data.SqlClient.SqlException: Invalid column name 'displayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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.displayName as UserName, u.Email, c.EventDateBegin, c.EventTimeBegin,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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, c.TimeZoneOffset from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Modules m on m.ModuleID = s.ModuleID Left Join dbo.TabModules x on m.ModuleID = x.ModuleID Left Join dbo.Tabs t on t.TabID = x.TabID Left Join dbo.Events c ON s.EventID = c.EventID Where s.Userid = @UserID AND t.PortalID = @ModuleID ORDER BY c.EventDateBegin desc, c.EventTimeBegin desc System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSignupsSave ( @EventID int, @SignupID int, @ModuleID int, @UserID int, @Approved int, @PayPalStatus varchar(50), @PayPalReason varchar(100), @PayPalTransID varchar(50), @PayPalPayerID varchar(50), @PayPalPayerStatus varchar(50), @PayPalRecieverEmail varchar(100), @PayPalUserEmail varchar(100), @PayPalPayerEmail varchar(100), @PayPalFirstName varchar(50), @PayPalLastName varchar(50), @PayPalAddress varchar(100), @PayPalCity varchar(25), @PayPalState varchar(25), @PayPalZip varchar(25), @PayPalCountry varchar(25), @PayPalCurrency varchar(25), @PayPalPaymentDate datetime , @PayPalAmount money, @PayPalFee money ) AS SET DATEFORMAT mdy IF @SignupID = 0 OR @SignupID IS NULL INSERT dbo.EventsSignups ( EventID, ModuleID, UserID, Approved, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee ) VALUES ( @EventID, @ModuleID, @UserID, @Approved, @PayPalStatus, @PayPalReason, @PayPalTransID, @PayPalPayerID, @PayPalPayerStatus, @PayPalRecieverEmail, @PayPalUserEmail, @PayPalPayerEmail, @PayPalFirstName, @PayPalLastName, @PayPalAddress, @PayPalCity, @PayPalState, @PayPalZip, @PayPalCountry, @PayPalCurrency, @PayPalPaymentDate, @PayPalAmount, @PayPalFee ) ELSE UPDATE dbo.EventsSignups SET EventID = @EventID, ModuleID = @ModuleID, UserID = @UserID, Approved = @Approved, PayPalStatus = @PayPalStatus, PayPalReason = @PayPalReason, PayPalTransID = @PayPalTransID, PayPalPayerID = @PayPalPayerID, PayPalPayerStatus = @PayPalPayerStatus, PayPalRecieverEmail = @PayPalRecieverEmail, PayPalUserEmail = @PayPalUserEmail, PayPalPayerEmail = @PayPalPayerEmail, PayPalFirstName = @PayPalFirstName, PayPalLastName = @PayPalLastName, PayPalAddress = @PayPalAddress, PayPalCity = @PayPalCity, PayPalState = @PayPalState, PayPalZip = @PayPalZip, PayPalCountry = @PayPalCountry, PayPalCurrency = @PayPalCurrency, PayPalPaymentDate = @PayPalPaymentDate, PayPalAmount = @PayPalAmount, PayPalFee = @PayPalFee WHERE SignupID = @SignupID Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, -- u.FirstName + ' ' + u.LastName as UserName, u.DisplayName as UserName, u.Email, c.EventDateBegin, c.EventTimeBegin,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 from dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.SignupID = @@Identity ORDER BY c.EventDateBegin, c.EventTimeBegin, c.EventName, UserName System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsUpgrade ( @ModuleID int ) AS SET DATEFORMAT mdy IF (SELECT Count(*) from dbo.Schedule WHERE TypeFullName = 'DotNetNuke.Modules.Events.EventNotification, DotNetNuke.Modules.Events') = 0 INSERT dbo.Schedule ( TypeFullName, AttachToEvent, CatchUpEnabled, Enabled, ObjectDependencies, RetainHistoryNum, Servers, TimeLapse, TimeLapseMeasurement, RetryTimeLapse, RetryTimeLapseMeasurement ) VALUES ( 'DotNetNuke.Modules.Events.EventNotification, DotNetNuke.Modules.Events', '', 0, 0, '', 10, '', 30, 'm', 30, 'm' ) SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, 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 FROM dbo.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 PayPalAccount = 'UPGRADEDEVENT' and ModuleID = @ModuleID
EndJob End Sql execution: 03.02.00.SqlDataProvider file

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 'DisplayName'. Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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, 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, 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
EndJob End Sql execution: 03.03.00.SqlDataProvider file

Info Executing 03.03.02.SqlDataProvider
StartJob Start Sql execution: 03.03.02.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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, 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, 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 System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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.DisplayName as UserName, u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.SignupID = @SignupID System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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.DisplayName as UserName, u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.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 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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.DisplayName as UserName, u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.EventID = @EventID And s.Userid = @UserID System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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.DisplayName as UserName, u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Modules m on m.ModuleID = s.ModuleID Left Join dbo.TabModules x on m.ModuleID = x.ModuleID Left Join dbo.Tabs t on t.TabID = x.TabID Left Join dbo.Events c ON s.EventID = c.EventID Where s.Userid = @UserID AND t.PortalID = @ModuleID ORDER BY s.EventTimeBegin desc System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSignupsSave ( @EventID int, @SignupID int, @ModuleID int, @UserID int, @Approved int, @PayPalStatus varchar(50), @PayPalReason varchar(100), @PayPalTransID varchar(50), @PayPalPayerID varchar(50), @PayPalPayerStatus varchar(50), @PayPalRecieverEmail varchar(100), @PayPalUserEmail varchar(100), @PayPalPayerEmail varchar(100), @PayPalFirstName varchar(50), @PayPalLastName varchar(50), @PayPalAddress varchar(100), @PayPalCity varchar(25), @PayPalState varchar(25), @PayPalZip varchar(25), @PayPalCountry varchar(25), @PayPalCurrency varchar(25), @PayPalPaymentDate datetime , @PayPalAmount money, @PayPalFee money, @EventTimeBegin datetime, @TimeZoneOffset int ) AS SET DATEFORMAT mdy IF @SignupID = 0 OR @SignupID IS NULL INSERT dbo.EventsSignups ( EventID, ModuleID, UserID, Approved, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, EventTimeBegin, TimeZoneOffset ) VALUES ( @EventID, @ModuleID, @UserID, @Approved, @PayPalStatus, @PayPalReason, @PayPalTransID, @PayPalPayerID, @PayPalPayerStatus, @PayPalRecieverEmail, @PayPalUserEmail, @PayPalPayerEmail, @PayPalFirstName, @PayPalLastName, @PayPalAddress, @PayPalCity, @PayPalState, @PayPalZip, @PayPalCountry, @PayPalCurrency, @PayPalPaymentDate, @PayPalAmount, @PayPalFee, @EventTimeBegin, @TimeZoneOffset ) ELSE UPDATE dbo.EventsSignups SET EventID = @EventID, ModuleID = @ModuleID, UserID = @UserID, Approved = @Approved, PayPalStatus = @PayPalStatus, PayPalReason = @PayPalReason, PayPalTransID = @PayPalTransID, PayPalPayerID = @PayPalPayerID, PayPalPayerStatus = @PayPalPayerStatus, PayPalRecieverEmail = @PayPalRecieverEmail, PayPalUserEmail = @PayPalUserEmail, PayPalPayerEmail = @PayPalPayerEmail, PayPalFirstName = @PayPalFirstName, PayPalLastName = @PayPalLastName, PayPalAddress = @PayPalAddress, PayPalCity = @PayPalCity, PayPalState = @PayPalState, PayPalZip = @PayPalZip, PayPalCountry = @PayPalCountry, PayPalCurrency = @PayPalCurrency, PayPalPaymentDate = @PayPalPaymentDate, PayPalAmount = @PayPalAmount, PayPalFee = @PayPalFee, EventTimeBegin = @EventTimeBegin, TimeZoneOffset = @TimeZoneOffset WHERE SignupID = @SignupID Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, --u.FirstName + ' ' + u.LastName as UserName, u.DisplayName as UserName, u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.SignupID = @@Identity ORDER BY s.EventTimeBegin, c.EventName, UserName
EndJob End Sql execution: 03.03.02.SqlDataProvider file

Info Executing 03.03.03.SqlDataProvider
StartJob Start Sql execution: 03.03.03.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSignupsGetUser ( @EventID int, @UserID int, @EventDate datetime ) AS SET DATEFORMAT mdy Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, -- u.FirstName + ' ' + u.LastName as UserName, u.DisplayName as USerName, u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.EventID = @EventID And s.Userid = @UserID And DATEADD(day, DATEDIFF(day, 0, s.EventTimeBegin), 0) = DATEADD(day, DATEDIFF(day, 0, @EventDate), 0) System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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, 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
EndJob End Sql execution: 03.03.03.SqlDataProvider file

Info Executing 03.03.05.SqlDataProvider
StartJob Start Sql execution: 03.03.05.SqlDataProvider file
EndJob End Sql execution: 03.03.05.SqlDataProvider file

Info Executing 03.03.07.SqlDataProvider
StartJob Start Sql execution: 03.03.07.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSave ( @PortalID int, @EventID int, @ModuleID int, @EventDateBegin datetime, @EventDateEnd datetime, @EventTimeBegin datetime, @Duration int, @EventName nvarchar(100), @EventDesc ntext, @Importance int, @CreatedBy varchar(100), @CreatorID varchar(100), @Every int, @Period nvarchar(10), @RepeatType char(10), @Notify nvarchar(100), @Approved bit, @Signups bit, @MaxEnrollment int, @EnrollRoleID varchar(50), @EnrollFee money, @EnrollType varchar(10), @PayPalAccount varchar(100), @PayPalPassword varchar(100), @Cancelled bit, @ImageURL varchar(100), @ImageType varchar(1), @ImageWidth int, @ImageHeight int, @ImageDisplay bit, @Location int, @LocationName nvarchar(50), @MapURL varchar(255), @Category int, @CategoryName nvarchar(50), @Color varchar(10), @Reminder nvarchar(100), @TimezoneOffset int, @SendReminder bit, @ReminderTime int, @ReminderTimeMeasurement varchar(2), @ReminderFrom nvarchar(100), @SearchSubmitted bit ) AS SET DATEFORMAT mdy IF @EventID = -1 OR @EventID IS NULL INSERT dbo.Events ( PortalID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, CreatedBy, Every, Period, RepeatType, Notify, Approved, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted ) VALUES ( @PortalID, @ModuleID, @EventDateBegin, @EventDateEnd, @EventTimeBegin, @Duration, @EventName, @EventDesc, @Importance, @CreatorID, @Every, @Period, @RepeatType, @Notify, @Approved, @Signups, @MaxEnrollment, @EnrollRoleID, @EnrollFee, @EnrollType, @PayPalAccount, @PayPalPassword, @Cancelled, @ImageURL, @ImageType, @ImageWidth, @ImageHeight, @ImageDisplay, @Location, @Category, @Reminder, @TimezoneOffset, @SendReminder, @ReminderTime, @ReminderTimeMeasurement, @ReminderFrom, @SearchSubmitted ) ELSE UPDATE dbo.Events SET PortalID = @PortalID, ModuleID = @ModuleID, EventDateBegin = @EventDateBegin, EventDateEnd = @EventDateEnd, EventTimeBegin = @EventTimeBegin, Duration = @Duration, EventName = @EventName, EventDesc = @EventDesc, Importance = @Importance, Every = @Every, Period = @Period, RepeatType = @RepeatType, Notify = @Notify, Approved = @Approved, Signups = @Signups, MaxEnrollment = @MaxEnrollment, EnrollRoleID = @EnrollRoleID, EnrollFee = @EnrollFee, EnrollType = @EnrollType, PayPalAccount = @PayPalAccount, PayPalPassword = @PayPalPassword, Cancelled = @Cancelled, ImageURL = @ImageURL, ImageType = @ImageType, ImageWidth = @ImageWidth, ImageHeight = @ImageHeight, ImageDisplay = @ImageDisplay, Location = @Location, Category = @Category, Reminder = @Reminder, TimezoneOffset = @TimezoneOffset, SendReminder = @SendReminder, ReminderTime = @ReminderTime, ReminderTimeMeasurement = @ReminderTimeMeasurement, ReminderFrom = @ReminderFrom, SearchSubmitted = @SearchSubmitted WHERE EventID = @EventID SELECT E.PortalID, EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, 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, c.Location, c.LocationName, c.MapURL, b.Category, b.CategoryName, b.Color, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom 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 = scope_identity() System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsSignupsSave ( @EventID int, @SignupID int, @ModuleID int, @UserID int, @Approved int, @PayPalStatus varchar(50), @PayPalReason varchar(100), @PayPalTransID varchar(50), @PayPalPayerID varchar(50), @PayPalPayerStatus varchar(50), @PayPalRecieverEmail varchar(100), @PayPalUserEmail varchar(100), @PayPalPayerEmail varchar(100), @PayPalFirstName varchar(50), @PayPalLastName varchar(50), @PayPalAddress varchar(100), @PayPalCity varchar(25), @PayPalState varchar(25), @PayPalZip varchar(25), @PayPalCountry varchar(25), @PayPalCurrency varchar(25), @PayPalPaymentDate datetime , @PayPalAmount money, @PayPalFee money, @EventTimeBegin datetime, @TimeZoneOffset int ) AS SET DATEFORMAT mdy IF @SignupID = 0 OR @SignupID IS NULL INSERT dbo.EventsSignups ( EventID, ModuleID, UserID, Approved, PayPalStatus, PayPalReason, PayPalTransID, PayPalPayerID, PayPalPayerStatus, PayPalRecieverEmail, PayPalUserEmail, PayPalPayerEmail, PayPalFirstName, PayPalLastName, PayPalAddress, PayPalCity, PayPalState, PayPalZip, PayPalCountry, PayPalCurrency, PayPalPaymentDate, PayPalAmount, PayPalFee, EventTimeBegin, TimeZoneOffset ) VALUES ( @EventID, @ModuleID, @UserID, @Approved, @PayPalStatus, @PayPalReason, @PayPalTransID, @PayPalPayerID, @PayPalPayerStatus, @PayPalRecieverEmail, @PayPalUserEmail, @PayPalPayerEmail, @PayPalFirstName, @PayPalLastName, @PayPalAddress, @PayPalCity, @PayPalState, @PayPalZip, @PayPalCountry, @PayPalCurrency, @PayPalPaymentDate, @PayPalAmount, @PayPalFee, @EventTimeBegin, @TimeZoneOffset ) ELSE UPDATE dbo.EventsSignups SET EventID = @EventID, ModuleID = @ModuleID, UserID = @UserID, Approved = @Approved, PayPalStatus = @PayPalStatus, PayPalReason = @PayPalReason, PayPalTransID = @PayPalTransID, PayPalPayerID = @PayPalPayerID, PayPalPayerStatus = @PayPalPayerStatus, PayPalRecieverEmail = @PayPalRecieverEmail, PayPalUserEmail = @PayPalUserEmail, PayPalPayerEmail = @PayPalPayerEmail, PayPalFirstName = @PayPalFirstName, PayPalLastName = @PayPalLastName, PayPalAddress = @PayPalAddress, PayPalCity = @PayPalCity, PayPalState = @PayPalState, PayPalZip = @PayPalZip, PayPalCountry = @PayPalCountry, PayPalCurrency = @PayPalCurrency, PayPalPaymentDate = @PayPalPaymentDate, PayPalAmount = @PayPalAmount, PayPalFee = @PayPalFee, EventTimeBegin = @EventTimeBegin, TimeZoneOffset = @TimeZoneOffset WHERE SignupID = @SignupID Select s.EventID, s.SignupID, s.ModuleID, s.Userid, s.Approved, --u.FirstName + ' ' + u.LastName as UserName, u.DisplayName as UserName, u.Email, s.EventTimeBegin,c.Duration,c.EventName,c.Importance,c.Approved as EventApproved, c.MaxEnrollment, (Select count(*) from dbo.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 dbo.EventsSignups s Left Join dbo.Users u ON s.UserID = u.UserID Left Join dbo.Events c ON s.EventID = c.EventID Where s.SignupID = scope_identity() ORDER BY s.EventTimeBegin, c.EventName, UserName
EndJob End Sql execution: 03.03.07.SqlDataProvider file

Info Executing 03.03.08.SqlDataProvider
StartJob Start Sql execution: 03.03.08.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'. Invalid column name 'DisplayName'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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, 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, 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
EndJob End Sql execution: 03.03.08.SqlDataProvider file

EndJob Finished Sql execution

StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created

Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\03.03.08.txt
StartJob Expanding Resource file
EndJob Resource Files created

Info Created D:\clnts\www.TheThurgoods.com\bin\DotNetNuke.Modules.Events.dll
Info Created D:\clnts\www.TheThurgoods.com\bin\DotNetNuke.Modules.Events.SqlDataProvider.dll
Info Created D:\clnts\www.TheThurgoods.com\bin\DotNetNuke.Events.ScheduleControl.dll
Info Created D:\clnts\www.TheThurgoods.com\bin\DotNetNuke.Events.WebControls.dll
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.02.00.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.00.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.02.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.03.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.05.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.07.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Providers\DataProviders\SqlDataProvider\03.03.08.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\Uninstall.SqlDataProvider
Info Created D:\clnts\www.TheThurgoods.com\DesktopModules\Events\DNN_Events.dnn
EndJob Files created

StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished

EndJob Installation successful.
 
 Page 1 of 1
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsInstall problem with Events_03.03.08_Install.zip Install problem with Events_03.03.08_Install.zip


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