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 ForumsEventsEventsA serious event: DNN Events 06.01.01 BETA is available!A serious event: DNN Events 06.01.01 BETA is available!
Previous
 
Next
New Post
2/18/2013 2:30 PM
 
Leslie Turner


Joined: 11/29/2007
Posts: 107
Roger Selwyn wrote:
Hi Leslie,

This would take some thinking about to get implemented, so I don't think I can just slip it into v6.1.0.

Could I ask that you raise this on CodePlex and I'll try to get it into the next release since we are focusing on Social Enhancements at the moment.

Thanks
Roger

 Hi Roger,

I appreciate the work that would be involved, it would be great to complete the enhancement of social integration. Even if for the moment displaying social groups in a master calendar would be great with the ability to flag what group it is in.

Thanks. Leslie.
 
New Post
2/18/2013 5:13 PM
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
No promises... I'll take a look
DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
2/24/2013 2:23 PM
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
Hi Leslie,

Have a look at my comments here for the functionality I have added - http://dnnevents.codeplex.com/workite...

Wait for a new beta to be posted. You will either need to start from your previous install, or re-apply the sproc updates in the 6.1.0 data provider, after you have done a re-install over the previous beta. (i.e. it is not a straight upgrade from previous beta).

Cheers
Roger
DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
3/1/2013 1:02 PM
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531

I have posted a new beta version 6.1.1 onto CodePlex. This has:-

  • Added admin ability to control sorting and date filtering of My Enrolments
  • Corrected category based filtering of enrolments
  • Fixed issues with check boxes and radio buttons not working correctly in a DNN 7 portal

The new version will allow an upgrade from v6.1.0 beta.

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
3/4/2013 2:04 PM
 
Robin Wilson

Joined: 3/14/2004
Posts: 4
After upgrading to 7.0.3 , I tried to upload DNN Events as New Extension Package. I got an error message. Can you tell me what should I do to correct this problem? Thanks.

StartJob Starting Installation
Info Starting Installation - DNN_Events
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - Installation\Install.05.02.04.SqlDataProvider
Info Created - Installation\Install.05.02.04.SqlDataProvider
Info Executing Install.05.02.04.SqlDataProvider
Info Start Sql execution: Install.05.02.04.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsRecurMaster' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:262fe0d9-db51-479c-a181-38b36c091c62 CREATE TABLE dbo.[EventsRecurMaster] ( [RecurMasterID] [int] NOT NULL IDENTITY(1, 1) , [ModuleID] [int] NOT NULL , [PortalID] [int] NOT NULL , [RRULE] [nvarchar](1000) NOT NULL , [DTSTART] [datetime] NOT NULL , [Duration] [nvarchar](50) NOT NULL , [Until] [datetime] NOT NULL , [EventName] [nvarchar](100) NOT NULL , [EventDesc] [ntext] NULL , [Importance] [int] NOT NULL , [Reminder] [nvarchar](2048) NULL , [Notify] [nvarchar](2048) NULL , [Approved] [bit] NOT NULL , [Signups] [bit] NOT NULL , [MaxEnrollment] [int] NOT NULL , [EnrollRoleID] [int] NULL , [EnrollFee] [money] NOT NULL , [EnrollType] [varchar](10) NOT NULL , [PayPalAccount] [nvarchar](100) NULL , [ImageURL] [nvarchar](100) NULL , [ImageType] [varchar](1) NULL , [ImageWidth] [int] NULL , [ImageHeight] [int] NULL , [ImageDisplay] [bit] NOT NULL , [Location] [int] NULL , [Category] [int] NULL , [TimezoneOffset] [int] NOT NULL , [SendReminder] [bit] NOT NULL , [ReminderTime] [int] NOT NULL , [ReminderTimeMeasurement] [varchar](2) NOT NULL , [ReminderFrom] [nvarchar](100) NOT NULL , [CustomField1] [nvarchar](100) NULL , [CustomField2] [nvarchar](100) NULL , [EnrollListView] [bit] NOT NULL , [DisplayEndDate] [bit] NOT NULL , [AllDayEvent] [bit] NOT NULL , [OwnerID] [int] NOT NULL , [CultureName] [varchar](10) NOT NULL , [CreatedByID] [int] NOT NULL , [CreatedDate] [datetime] NOT NULL , [UpdatedByID] [int] NOT NULL , [UpdatedDate] [datetime] NOT NULL , [DetailPage] [bit] NOT NULL , [DetailURL] [nvarchar](100) NULL , [DetailNewWin] [bit] NOT NULL ) System.Data.SqlClient.SqlException (0x80131904): Table 'EventsRecurMaster' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:26a2da05-9596-43d7-a454-31233d02593c ALTER TABLE dbo.[EventsRecurMaster] ADD CONSTRAINT [PK_EventsRecurMaster] PRIMARY KEY CLUSTERED ([RecurMasterID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsRecurMaster_3' already exists on table 'dbo.EventsRecurMaster'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2f7e1c7f-438a-4e58-8a53-a35c17b298c7 CREATE NONCLUSTERED INDEX [IX_EventsRecurMaster_3] ON dbo.[EventsRecurMaster] ([ModuleID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsRecurMaster_2' already exists on table 'dbo.EventsRecurMaster'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:e442a4c7-0e83-4419-84cd-be6f51693392 CREATE NONCLUSTERED INDEX [IX_EventsRecurMaster_2] ON dbo.[EventsRecurMaster] ([Location]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsRecurMaster_1' already exists on table 'dbo.EventsRecurMaster'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f2173552-08ba-4887-a75e-14af40b97dc5 CREATE NONCLUSTERED INDEX [IX_EventsRecurMaster_1] ON dbo.[EventsRecurMaster] ([Category]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsRecurMasterDelete' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ac0650ee-1c7c-4e09-b112-12cd5525da23 /*** EventsRecurMasterDelete ***/ CREATE PROCEDURE dbo.EventsRecurMasterDelete ( @RecurMasterID INT , @ModuleID INT ) AS DELETE dbo.EventsRecurMaster WHERE RecurMasterID = @RecurMasterID AND ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsCategory' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:dddd1a4d-f21a-4e3f-8def-94d11c7aa94c CREATE TABLE dbo.[EventsCategory] ( [PortalID] [int] NOT NULL , [Category] [int] NOT NULL IDENTITY(1, 1) , [CategoryName] [nvarchar](50) NOT NULL , [Color] [varchar](10) NULL , [FontColor] [varchar](10) NULL ) System.Data.SqlClient.SqlException (0x80131904): Table 'EventsCategory' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8fc604c2-4dbe-4a82-adab-e7c19d01f7b8 ALTER TABLE dbo.[EventsCategory] ADD CONSTRAINT [PK_EventsCategory] PRIMARY KEY CLUSTERED ([Category]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsCategory_2' already exists on table 'dbo.EventsCategory'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:09d8c1bd-6669-44c3-99ee-32c81c18f7eb CREATE NONCLUSTERED INDEX [IX_EventsCategory_2] ON dbo.[EventsCategory] ([PortalID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsCategory' already exists on table 'dbo.EventsCategory'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3f5f58f7-ead8-4b1e-8d72-a56f43259a9d CREATE NONCLUSTERED INDEX [IX_EventsCategory] ON dbo.[EventsCategory] ([CategoryName]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsLocation' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ed93315c-c7ec-49c5-831f-694ad24c973a CREATE TABLE dbo.[EventsLocation] ( [PortalID] [int] NOT NULL , [Location] [int] NOT NULL IDENTITY(1, 1) , [LocationName] [nvarchar](50) NOT NULL , [MapURL] [nvarchar](255) NULL ) System.Data.SqlClient.SqlException (0x80131904): Table 'EventsLocation' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:02c98725-3a10-4039-a19c-20d50247e679 ALTER TABLE dbo.[EventsLocation] ADD CONSTRAINT [PK_EventsLocation] PRIMARY KEY CLUSTERED ([Location]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsLocation_2' already exists on table 'dbo.EventsLocation'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d5aa6035-4eb8-4ba0-89c5-3d576def423b CREATE NONCLUSTERED INDEX [IX_EventsLocation_2] ON dbo.[EventsLocation] ([PortalID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsLocation' already exists on table 'dbo.EventsLocation'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:7604f7f2-c769-4689-b7fd-5face62f37a5 CREATE NONCLUSTERED INDEX [IX_EventsLocation] ON dbo.[EventsLocation] ([LocationName]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsMaster' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3afcb348-03b7-4a75-9862-7d2cfff43f3a CREATE TABLE dbo.[EventsMaster] ( [MasterID] [int] NOT NULL IDENTITY(1, 1) , [ModuleID] [int] NOT NULL , [SubEventID] [int] NOT NULL ) System.Data.SqlClient.SqlException (0x80131904): Table 'EventsMaster' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:9002fc8e-44e0-4547-a17f-5e99a5f4926a ALTER TABLE dbo.[EventsMaster] ADD CONSTRAINT [PK_EventsMaster] PRIMARY KEY CLUSTERED ([MasterID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsMaster_1' already exists on table 'dbo.EventsMaster'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:33bab58f-e3c9-43d5-be62-5ae37d2f7a1c CREATE NONCLUSTERED INDEX [IX_EventsMaster_1] ON dbo.[EventsMaster] ([ModuleID]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsCategoryGet' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b4e3d4a2-fc59-4b02-88ee-db76c1f0c9d5 /*** EventsCategoryGet ***/ CREATE PROCEDURE dbo.EventsCategoryGet ( @Category INT , @PortalID INT ) AS SELECT Category , PortalID , CategoryName , Color , FontColor FROM dbo.EventsCategory WHERE Category = @Category AND PortalID = @PortalID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsCategorySave' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:09888bb6-ce22-4666-bbb1-d08c39669c32 /*** EventsCategorySave ***/ CREATE PROCEDURE dbo.EventsCategorySave ( @PortalID INT , @Category INT , @CategoryName NVARCHAR(50) , @Color VARCHAR(10) , @FontColor VARCHAR(10) ) AS IF @Category = 0 OR @Category IS NULL INSERT dbo.EventsCategory ( PortalID , CategoryName , Color , FontColor ) VALUES ( @PortalID , @CategoryName , @Color , @FontColor ) ELSE UPDATE dbo.EventsCategory SET CategoryName = @CategoryName , Color = @Color , FontColor = @FontColor WHERE Category = @Category AND PortalID = @PortalID SELECT Category , PortalID , CategoryName , Color , FontColor FROM dbo.EventsCategory WHERE Category = SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsCategoryList' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:839d5e9c-ce87-4361-8001-e79413cc4527 /*** EventsCategoryList ***/ CREATE PROCEDURE dbo.EventsCategoryList ( @PortalID INT ) AS SELECT Category , PortalID , CategoryName , Color , FontColor FROM dbo.EventsCategory WHERE PortalID = @PortalID ORDER BY CategoryName System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSubscription' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:05dbd60e-98e9-489b-89f6-9d0c1e2c933d CREATE TABLE dbo.[EventsSubscription] ( [SubscriptionID] [int] NOT NULL IDENTITY(1, 1) , [ModuleID] [int] NOT NULL , [PortalID] [int] NOT NULL , [UserID] [int] NOT NULL ) System.Data.SqlClient.SqlException (0x80131904): Table 'EventsSubscription' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:e032f806-ba43-4cd9-bc7d-37eb406c1012 ALTER TABLE dbo.[EventsSubscription] ADD CONSTRAINT [PK_EventsSubscription] PRIMARY KEY CLUSTERED ([SubscriptionID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsSubscription_1' already exists on table 'dbo.EventsSubscription'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:0fb10f7d-adf7-49fe-a3a7-6b7d2a15596e CREATE NONCLUSTERED INDEX [IX_EventsSubscription_1] ON dbo.[EventsSubscription] ([ModuleID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsSubscription_2' already exists on table 'dbo.EventsSubscription'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:90ffc473-7261-48c1-8df1-d41d31d186df CREATE NONCLUSTERED INDEX [IX_EventsSubscription_2] ON dbo.[EventsSubscription] ([UserID]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSubscriptionSave' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:673ff891-57d5-42c2-a7d0-53b4e8ebb8f4 /* EventsSubscriptionSave */ CREATE PROCEDURE dbo.EventsSubscriptionSave ( @SubscriptionID INT , @ModuleID INT , @PortalID INT , @UserID INT ) AS INSERT dbo.EventsSubscription ( ModuleID, PortalID, UserID ) VALUES ( @ModuleID, @PortalID, @UserID ) SELECT SubscriptionID , ModuleID , PortalID , UserID FROM dbo.EventsSubscription WHERE SubscriptionID = SCOPE_IDENTITY() OR SubscriptionID = @SubscriptionID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSubscriptionDeleteUser' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:6624562f-aeeb-45ae-9e63-f5f43ea368e3 /*** EventsSubscriptionDeleteUser ***/ CREATE PROCEDURE dbo.EventsSubscriptionDeleteUser ( @UserID INT , @ModuleID INT ) AS DELETE dbo.EventsSubscription WHERE UserID = @UserID AND ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSubscriptionGetUser' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:70b0acf7-271f-4128-a6e1-d90d5351e0fa /* EventsSubscriptionGetUser */ CREATE PROCEDURE dbo.EventsSubscriptionGetUser ( @UserID INT , @ModuleID INT ) AS SELECT SubscriptionID , ModuleID , PortalID , UserID FROM dbo.EventsSubscription WHERE UserID = @UserID AND ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSubscriptionGetModule' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2b8d7d1c-7d94-4965-8868-425fbb98706d /* EventsSubscriptionGetModule */ CREATE PROCEDURE dbo.EventsSubscriptionGetModule ( @ModuleID INT ) AS SELECT SubscriptionID , ModuleID , PortalID , UserID FROM dbo.EventsSubscription WHERE ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSubscriptionGetSubModule' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:22c33690-0bd3-4750-afa6-850dd95649c8 /* EventsSubscriptionGetSubModule */ CREATE PROCEDURE dbo.EventsSubscriptionGetSubModule ( @ModuleID INT ) AS SELECT DISTINCT S.SubscriptionID , S.ModuleID , S.PortalID , S.UserID FROM dbo.EventsSubscription AS S LEFT OUTER JOIN dbo.EventsMaster AS M ON S.ModuleID = M.ModuleID WHERE ( S.ModuleID = @ModuleID ) OR ( SubEventID = @ModuleID ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsLocationList' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8f517c6e-622a-406b-949f-488a56366d31 CREATE PROCEDURE dbo.EventsLocationList ( @PortalID INT ) AS SELECT Location , PortalID , LocationName , MapURL FROM dbo.EventsLocation WHERE PortalID = @PortalID ORDER BY LocationName System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsMasterSave' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b0b689d4-ab6c-4478-94ab-1c6eb2dffc0d /*** EventsMasterSave ***/ 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 , a.SubEventID FROM dbo.EventsMaster a WHERE a.MasterID = SCOPE_IDENTITY() GROUP BY a.MasterID , a.ModuleID , a.SubEventID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'SplitIDs' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:93a7f937-8805-4053-83b2-a3ab22472f9b /** SplitIDs Function **/ CREATE FUNCTION dbo.[SplitIDs] ( @RecordIDList VARCHAR(1024) ) RETURNS @ParsedList TABLE ( RecordID INT ) AS BEGIN DECLARE @RecordID VARCHAR(10) , @Pos INT SET @RecordIDList = LTRIM(RTRIM(@RecordIDList)) + ',' SET @Pos = CHARINDEX(',', @RecordIDList, 1) IF REPLACE(@RecordIDList, ',', '') <> '' BEGIN WHILE @Pos > 0 BEGIN SET @RecordID = LTRIM(RTRIM(LEFT(@RecordIDList, @Pos - 1))) IF @RecordID <> '' BEGIN INSERT INTO @ParsedList ( RecordID ) VALUES ( CAST(@RecordID AS INT) ) --Use Appropriate conversion END SET @RecordIDList = RIGHT(@RecordIDList, LEN(@RecordIDList) - @Pos) SET @Pos = CHARINDEX(',', @RecordIDList, 1) END END RETURN END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsCategoryGetByName' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:0b788521-ab9e-4d3d-a6c8-4a74f2f6fc0b /*** EventsCategoryGetByName ***/ CREATE PROCEDURE dbo.EventsCategoryGetByName ( @CategoryName NVARCHAR(50) , @PortalID INT ) AS SELECT Category , PortalID , CategoryName , Color , FontColor FROM dbo.EventsCategory WHERE CategoryName = @CategoryName AND PortalID = @PortalID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsMasterDelete' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b8d50a75-ceba-4de6-b696-b2a81c383759 CREATE PROCEDURE dbo.EventsMasterDelete ( @MasterID INT , @ModuleID INT ) AS DELETE dbo.EventsMaster WHERE MasterID = @MasterID AND ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsLocationGet' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3cdd296b-16bf-4be9-939b-e4865e4e51c4 CREATE PROCEDURE dbo.EventsLocationGet ( @Location INT , @PortalID INT ) AS SELECT Location , PortalID , LocationName , MapURL FROM dbo.EventsLocation WHERE Location = @Location AND PortalID = @PortalID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsLocationSave' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b6b11585-4e95-4aee-a14f-bd1a523b2ae0 CREATE PROCEDURE dbo.EventsLocationSave ( @PortalID INT , @Location INT , @LocationName NVARCHAR(50) , @MapURL NVARCHAR(255) ) AS IF @Location = 0 OR @Location IS NULL INSERT dbo.EventsLocation ( PortalID, LocationName, MapURL ) VALUES ( @PortalID, @LocationName, @MapURL ) ELSE UPDATE dbo.EventsLocation SET LocationName = @LocationName , MapURL = @MapURL WHERE Location = @Location AND PortalID = @PortalID SELECT Location , PortalID , LocationName , MapURL FROM dbo.EventsLocation WHERE Location = SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Events' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:458cac47-dbda-4e48-8fef-767836db04bb CREATE TABLE dbo.[Events] ( [EventID] [int] NOT NULL IDENTITY(1, 1) , [ModuleID] [int] NOT NULL , [EventDateBegin] [datetime] NULL , [EventDateEnd] [datetime] NULL , [EventTimeBegin] [datetime] NOT NULL , [Duration] [int] NOT NULL , [EventName] [nvarchar](100) NOT NULL , [EventDesc] [ntext] NULL , [Importance] [int] NOT NULL , [RepeatType] [varchar](10) NULL , [Every] [varchar](10) NULL , [Period] [nvarchar](50) NULL , [Reminder] [nvarchar](2048) NULL , [Notify] [nvarchar](2048) NULL , [CreatedByID] [int] NOT NULL , [CreatedDate] [datetime] NOT NULL DEFAULT ( GETDATE() ) , [Approved] [bit] NOT NULL , [PortalID] [int] NOT NULL , [Signups] [bit] NOT NULL , [MaxEnrollment] [int] NOT NULL , [EnrollRoleID] [int] NULL , [EnrollFee] [money] NOT NULL , [EnrollType] [varchar](10) NOT NULL , [PayPalAccount] [nvarchar](100) NULL , [Cancelled] [bit] NOT NULL , [ImageURL] [nvarchar](100) NULL , [ImageType] [varchar](1) NULL , [ImageWidth] [int] NULL , [ImageHeight] [int] NULL , [ImageDisplay] [bit] NOT NULL , [Location] [int] NULL , [Category] [int] NULL , [TimezoneOffset] [int] NOT NULL , [SendReminder] [bit] NOT NULL , [ReminderTime] [int] NOT NULL , [ReminderTimeMeasurement] [varchar](2) NOT NULL , [ReminderFrom] [nvarchar](100) NOT NULL , [SearchSubmitted] [bit] NOT NULL , [CustomField1] [nvarchar](100) NULL , [CustomField2] [nvarchar](100) NULL , [LastUpdatedAt] [datetime] NOT NULL , [OriginalDateBegin] [datetime] NOT NULL , [LastUpdatedID] [int] NOT NULL , [OwnerID] [int] NOT NULL , [EnrollListView] [bit] NOT NULL , [NewEventEmailSent] [bit] NOT NULL , [DisplayEndDate] [bit] NOT NULL , [AllDayEvent] [bit] NOT NULL , [RecurMasterID] [int] NOT NULL , [DetailPage] [bit] NOT NULL , [DetailURL] [nvarchar](100) NULL , [DetailNewWin] [bit] NOT NULL ) System.Data.SqlClient.SqlException (0x80131904): Table 'Events' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d07bcfaa-c87b-474f-b0b1-c2825d15a25c ALTER TABLE dbo.[Events] ADD CONSTRAINT [PK_Events] PRIMARY KEY CLUSTERED ([EventID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Events_4' already exists on table 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:0be8498e-fb0d-413e-b2d0-3e1e20856439 CREATE NONCLUSTERED INDEX [IX_Events_4] ON dbo.[Events] ([ModuleID], [RecurMasterID], [EventID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Events_2' already exists on table 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:bca511bb-d005-4fc3-b8c6-fe7f5b95947f CREATE NONCLUSTERED INDEX [IX_Events_2] ON dbo.[Events] ([ModuleID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Events_1' already exists on table 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a7516f93-06e1-4837-8c4c-99a99205a316 CREATE NONCLUSTERED INDEX [IX_Events_1] ON dbo.[Events] ([EventDateBegin]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Events_3' already exists on table 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2c68b38e-5f13-4c6e-9239-8382fedaf321 CREATE NONCLUSTERED INDEX [IX_Events_3] ON dbo.[Events] ([EventDateEnd]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Events_5' already exists on table 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:c666a5e5-a6b1-4747-8b18-4dec2a0694ba CREATE NONCLUSTERED INDEX [IX_Events_5] ON dbo.[Events] ([EventTimeBegin]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Events_7' already exists on table 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:02f233e7-f6db-4fef-a577-c75754643a7c CREATE NONCLUSTERED INDEX [IX_Events_7] ON dbo.[Events] ([Location]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Events_6' already exists on table 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d805e602-7a26-4435-b109-75d9ccf170dd CREATE NONCLUSTERED INDEX [IX_Events_6] ON dbo.[Events] ([Category]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Events_8' already exists on table 'dbo.Events'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:af0ea0f1-1dab-45ad-aa39-3d4d6e2899c5 CREATE NONCLUSTERED INDEX [IX_Events_8] ON dbo.[Events] ([RecurMasterID]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsLocationDelete' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:28388733-4597-479c-b438-38b23588aa23 /*** EventsLocationDelete ***/ CREATE PROCEDURE dbo.EventsLocationDelete ( @Location INT , @PortalID INT ) AS UPDATE dbo.EventsRecurMaster SET Location = NULL WHERE Location = @Location AND PortalID = @PortalID UPDATE dbo.Events SET Location = NULL WHERE Location = @Location AND PortalID = @PortalID DELETE dbo.EventsLocation WHERE Location = @Location AND PortalID = @PortalID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsRecurMasterModerate' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:1e37d7b2-158f-4f7b-a042-60ef1741d060 /*** EventsRecurMasterModerate ***/ CREATE PROCEDURE dbo.EventsRecurMasterModerate ( @ModuleID INT ) AS SET DATEFORMAT mdy SELECT R.RecurMasterID , R.ModuleID , R.DTSTART , R.Until , R.EventName , MIN(E.EventID) AS FirstEventID FROM dbo.EventsRecurMaster AS R INNER JOIN dbo.Events AS E ON R.RecurMasterID = E.RecurMasterID WHERE ( R.Approved = 0 ) AND ( R.ModuleID = @ModuleID ) AND ( R.RRULE <> '' ) AND ( E.Cancelled = 0 ) AND ( E.Approved = 0 ) GROUP BY R.RecurMasterID , R.ModuleID , R.DTSTART , R.Until , R.EventName ORDER BY R.DTSTART System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsNotification' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:85bebc84-4296-4ab6-9052-ebc42f2911ac CREATE TABLE dbo.[EventsNotification] ( [NotificationID] [int] NOT NULL IDENTITY(1, 1) , [EventID] [int] NOT NULL , [PortalAliasID] [int] NOT NULL , [UserEmail] [nvarchar](50) NOT NULL , [NotificationSent] [bit] NOT NULL , [NotifyByDateTime] [datetime] NOT NULL , [EventTimeBegin] [datetime] NOT NULL , [NotifyLanguage] [nvarchar](10) NOT NULL , [ModuleID] [int] NOT NULL , [TabID] [int] NOT NULL DEFAULT ( (1) ) ) System.Data.SqlClient.SqlException (0x80131904): Table 'EventsNotification' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:6ce5cafa-406e-4a1e-a100-458ed51ad6e6 ALTER TABLE dbo.[EventsNotification] ADD CONSTRAINT [PK_EventsNotification] PRIMARY KEY CLUSTERED ([NotificationID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsNotification_3' already exists on table 'dbo.EventsNotification'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:c0b525fb-d4fc-470b-a1fe-7d24e7adc991 CREATE NONCLUSTERED INDEX [IX_EventsNotification_3] ON dbo.[EventsNotification] ([EventID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsNotification' already exists on table 'dbo.EventsNotification'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:28404fe4-c7e2-42b2-90be-411d77a43777 CREATE NONCLUSTERED INDEX [IX_EventsNotification] ON dbo.[EventsNotification] ([EventID], [NotifyByDateTime]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsNotification_1' already exists on table 'dbo.EventsNotification'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:898a4dbd-a720-4d42-906d-3f4cba3bb9d8 CREATE NONCLUSTERED INDEX [IX_EventsNotification_1] ON dbo.[EventsNotification] ([NotifyByDateTime]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsNotificationTimeChange' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:fe73b241-acfe-4655-bf7f-d7122b55ed5b /*** EventsNotificationTimeChange ***/ CREATE PROCEDURE dbo.EventsNotificationTimeChange ( @EventID INT , @EventTimeBegin DATETIME , @ModuleID INT ) AS SET DATEFORMAT mdy UPDATE dbo.EventsNotification SET NotifyByDateTime = DATEADD(n, -( SELECT DATEDIFF(minute, NotifyByDateTime, EventTimeBegin) FROM dbo.EventsNotification LEFT OUTER JOIN dbo.EventsMaster ON dbo.EventsNotification.ModuleID = dbo.EventsMaster.SubEventID WHERE EventID = @EventID AND ( dbo.EventsNotification.ModuleID = @ModuleID OR dbo.EventsMaster.ModuleID = @ModuleID ) ), @EventTimeBegin) , EventTimeBegin = @EventTimeBegin FROM dbo.EventsNotification LEFT OUTER JOIN dbo.EventsMaster ON dbo.EventsNotification.ModuleID = dbo.EventsMaster.SubEventID WHERE EventID = @EventID AND ( dbo.EventsNotification.ModuleID = @ModuleID OR dbo.EventsMaster.ModuleID = @ModuleID ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsTimeZoneUpgrade' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:10677dc8-0917-45da-a9bb-48ba2f557001 /*** EventsTimeZoneUpgrade ***/ CREATE PROCEDURE dbo.EventsTimeZoneUpgrade ( @ModuleID INT , @TimeZoneOffset INT ) AS SET DATEFORMAT mdy DECLARE @GMTBeginTime AS DATETIME DECLARE @GMTBeginDate AS DATETIME DECLARE @GMTEndDate AS DATETIME UPDATE dbo.Events SET TimezoneOffset = @TimeZoneOffset WHERE ModuleID = @ModuleID UPDATE dbo.EventsRecurMaster SET TimezoneOffset = @TimeZoneOffset WHERE ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSignups' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:79b60b4c-21ad-4421-ab24-7a9e58d4557a CREATE TABLE dbo.[EventsSignups] ( [SignupID] [int] NOT NULL IDENTITY(1, 1) , [ModuleID] [int] NOT NULL , [EventID] [int] NOT NULL , [UserID] [int] NOT NULL , [CreateDate] [datetime] NOT NULL DEFAULT ( CONVERT([varchar], GETDATE(), ( 101 )) ) , [Approved] [bit] NOT NULL , [PayPalStatus] [nvarchar](50) NULL , [PayPalReason] [nvarchar](100) NULL , [PayPalTransID] [nvarchar](50) NULL , [PayPalPayerID] [nvarchar](50) NULL , [PayPalPayerStatus] [nvarchar](50) NULL , [PayPalRecieverEmail] [nvarchar](100) NULL , [PayPalUserEmail] [nvarchar](100) NULL , [PayPalPayerEmail] [nvarchar](100) NULL , [PayPalFirstName] [nvarchar](50) NULL , [PayPalLastName] [nvarchar](50) NULL , [PayPalAddress] [nvarchar](100) NULL , [PayPalCity] [nvarchar](50) NULL , [PayPalState] [nvarchar](25) NULL , [PayPalZip] [nvarchar](25) NULL , [PayPalCountry] [nvarchar](25) NULL , [PayPalCurrency] [nvarchar](25) NULL , [PayPalPaymentDate] [datetime] NULL , [PayPalAmount] [money] NULL , [PayPalFee] [money] NULL , [EventTimeBegin] [datetime] NULL , [NoEnrolees] [int] NOT NULL DEFAULT ( (1) ) ) System.Data.SqlClient.SqlException (0x80131904): Table 'EventsSignups' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f00e9a4e-4c35-4891-8d9b-c7ab5368e624 ALTER TABLE dbo.[EventsSignups] ADD CONSTRAINT [PK_EventsSignups] PRIMARY KEY CLUSTERED ([SignupID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsSignups_2' already exists on table 'dbo.EventsSignups'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:4333c4c2-d5c6-4183-855c-a455286ae3e7 CREATE NONCLUSTERED INDEX [IX_EventsSignups_2] ON dbo.[EventsSignups] ([EventID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsSignups_1' already exists on table 'dbo.EventsSignups'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:fd93db57-b604-4c21-915c-57a63ea11fd0 CREATE NONCLUSTERED INDEX [IX_EventsSignups_1] ON dbo.[EventsSignups] ([PayPalTransID]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsRecurMasterSave' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d1cce6c6-fdbe-4a99-a21c-1118f2895f89 /* EventsRecurMasterSave */ CREATE PROCEDURE dbo.[EventsRecurMasterSave] ( @RecurMasterID INT , @ModuleID INT , @PortalID INT , @RRULE NVARCHAR(1000) , @DTSTART DATETIME , @Duration NVARCHAR(50) , @Until DATETIME , @EventName NVARCHAR(100) , @EventDesc NTEXT , @Importance INT , @Notify NVARCHAR(2048) , @Approved BIT , @Signups BIT , @MaxEnrollment INT , @EnrollRoleID INT , @EnrollFee MONEY , @EnrollType VARCHAR(10) , @PayPalAccount NVARCHAR(100) , @DetailPage BIT , @DetailNewWin BIT , @DetailURL NVARCHAR(100) , @ImageURL NVARCHAR(100) , @ImageType VARCHAR(1) , @ImageWidth INT , @ImageHeight INT , @ImageDisplay BIT , @Location INT , @Category INT , @Reminder NVARCHAR(2048) , @TimezoneOffset INT , @SendReminder BIT , @ReminderTime INT , @ReminderTimeMeasurement VARCHAR(2) , @ReminderFrom NVARCHAR(100) , @CustomField1 NVARCHAR(100) , @CustomField2 NVARCHAR(100) , @EnrollListView BIT , @DisplayEndDate BIT , @AllDayEvent BIT , @CultureName VARCHAR(10) , @OwnerID INT , @CreatedByID INT , @UpdatedByID INT ) AS SET DATEFORMAT mdy IF @Location = -1 SELECT @Location = NULL IF @Category = -1 SELECT @Category = NULL IF @EnrollRoleID = -1 SELECT @EnrollRoleID = NULL IF @ImageURL = N'' SELECT @ImageURL = NULL IF @ImageType = '' SELECT @ImageType = NULL IF @DetailURL = N'' SELECT @DetailURL = NULL IF @RecurMasterID = -1 OR @recurMasterID IS NULL INSERT dbo.[EventsRecurMaster] ( ModuleID , PortalID , RRULE , DTSTART , Duration , Until , EventName , EventDesc , Importance , Notify , Approved , Signups , MaxEnrollment , EnrollRoleID , EnrollFee , EnrollType , PayPalAccount , DetailPage , DetailNewWin , DetailURL , ImageURL , ImageType , ImageWidth , ImageHeight , ImageDisplay , Location , Category , Reminder , TimezoneOffset , SendReminder , ReminderTime , ReminderTimeMeasurement , ReminderFrom , CustomField1 , CustomField2 , EnrollListView , DisplayEndDate , AllDayEvent , CultureName , OwnerID , CreatedByID , CreatedDate , UpdatedByID , UpdatedDate ) VALUES ( @ModuleID , @PortalID , @RRULE , @DTSTART , @Duration , @Until , @EventName , @EventDesc , @Importance , @Notify , @Approved , @Signups , @MaxEnrollment , @EnrollRoleID , @EnrollFee , @EnrollType , @PayPalAccount , @DetailPage , @DetailNewWin , @DetailURL , @ImageURL , @ImageType , @ImageWidth , @ImageHeight , @ImageDisplay , @Location , @Category , @Reminder , @TimezoneOffset , @SendReminder , @ReminderTime , @ReminderTimeMeasurement , @ReminderFrom , @CustomField1 , @CustomField2 , @EnrollListView , @DisplayEndDate , @AllDayEvent , @CultureName , @OwnerID , @CreatedByID , GETUTCDATE() , @UpdatedByID , GETUTCDATE() ) ELSE UPDATE dbo.[EventsRecurMaster] SET RRULE = @RRULE , DTSTART = @DTSTART , Duration = @Duration , Until = @Until , EventName = @EventName , EventDesc = @EventDesc , Importance = @Importance , Notify = @Notify , Approved = @Approved , Signups = @Signups , MaxEnrollment = @MaxEnrollment , EnrollRoleID = @EnrollRoleID , EnrollFee = @EnrollFee , EnrollType = @EnrollType , PayPalAccount = @PayPalAccount , DetailPage = @DetailPage , DetailNewWin = @DetailNewWin , DetailURL = @DetailURL , 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 , CustomField1 = @CustomField1 , CustomField2 = @CustomField2 , EnrollListView = @EnrollListView , DisplayEndDate = @DisplayEndDate , AllDayEvent = @AllDayEvent , CultureName = @CultureName , OwnerID = @OwnerID , UpdatedByID = @UpdatedByID , UpdatedDate = GETUTCDATE() WHERE RecurMasterID = @RecurMasterID AND ModuleID = @ModuleID SELECT RecurMasterID , ModuleID , PortalID , RRULE , DTSTART , Duration , Until , EventName , EventDesc , Importance , Notify , Approved , Signups , MaxEnrollment , ( SELECT COUNT(*) FROM dbo.[Events] AS E INNER JOIN dbo.[EventsSignups] AS S ON E.EventID = S.EventID WHERE E.RecurMasterID = R.RecurMasterID AND E.Signups = 1 ) AS Enrolled , EnrollRoleID , EnrollFee , EnrollType , PayPalAccount , DetailPage , DetailNewWin , DetailURL , ImageURL , ImageType , ImageWidth , ImageHeight , ImageDisplay , Location , Category , Reminder , TimezoneOffset , SendReminder , ReminderTime , ReminderTimeMeasurement , ReminderFrom , CustomField1 , CustomField2 , EnrollListView , DisplayEndDate , AllDayEvent , CultureName , OwnerID , CreatedByID , CreatedDate , UpdatedByID , UpdatedDate FROM dbo.[EventsRecurMaster] R WHERE RecurMasterID = SCOPE_IDENTITY() OR RecurMasterID = @RecurMasterID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsModerateEvents' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:5760e527-fee0-448f-bbc9-bd4a2468b410 /*** EventsModerateEvents ***/ CREATE PROCEDURE dbo.[EventsModerateEvents] ( @ModuleID INT ) AS SET DATEFORMAT mdy SELECT EventID , ModuleID , EventDateBegin , EventDateEnd , EventTimeBegin , Duration , EventName , EventDesc , Importance , E.CreatedDate , CreatedBy = U.DisplayName , CreatedByID , 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 , Cancelled , TimeZoneOffset FROM dbo.[Events] E LEFT OUTER JOIN dbo.[Users] U ON E.CreatedByID = U.UserID WHERE Approved = 0 AND ModuleID = @ModuleID AND Cancelled = 0 ORDER BY EventDateBegin , EventDateEnd , ( SELECT ( DATEPART(hour, EventTimeBegin) * 10000 ) + ( DATEPART(minute, EventTimeBegin) * 100 ) + ( DATEPART(second, EventTimeBegin) ) ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsPPErrorLog' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:9a57cdec-a68b-4a38-93ec-bc1475490f3a CREATE TABLE dbo.[EventsPPErrorLog] ( [PayPalID] [int] NOT NULL IDENTITY(1, 1) , [SignupID] [int] NOT NULL , [CreateDate] [datetime] NOT NULL DEFAULT ( CONVERT([varchar], GETDATE(), ( 101 )) ) , [PayPalStatus] [nvarchar](50) NULL , [PayPalReason] [nvarchar](100) NULL , [PayPalTransID] [nvarchar](50) NULL , [PayPalPayerID] [nvarchar](50) NULL , [PayPalPayerStatus] [nvarchar](50) NULL , [PayPalRecieverEmail] [nvarchar](100) NULL , [PayPalUserEmail] [nvarchar](100) NULL , [PayPalPayerEmail] [nvarchar](100) NULL , [PayPalFirstName] [nvarchar](50) NULL , [PayPalLastName] [nvarchar](50) NULL , [PayPalAddress] [nvarchar](100) NULL , [PayPalCity] [nvarchar](50) NULL , [PayPalState] [nvarchar](25) NULL , [PayPalZip] [nvarchar](25) NULL , [PayPalCountry] [nvarchar](25) NULL , [PayPalCurrency] [nvarchar](25) NULL , [PayPalPaymentDate] [datetime] NULL , [PayPalAmount] [money] NULL , [PayPalFee] [money] NULL ) System.Data.SqlClient.SqlException (0x80131904): Table 'EventsPPErrorLog' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f7c14bc4-6ec8-4399-9a5d-7403cedaae30 ALTER TABLE dbo.[EventsPPErrorLog] ADD CONSTRAINT [PK_EventsPPErrorLog] PRIMARY KEY CLUSTERED ([PayPalID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsPPErrorLog_2' already exists on table 'dbo.EventsPPErrorLog'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:6dbe2266-c3e2-4629-b6e1-ab703f811afb CREATE NONCLUSTERED INDEX [IX_EventsPPErrorLog_2] ON dbo.[EventsPPErrorLog] ([SignupID]) System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsPPErrorLog' already exists on table 'dbo.EventsPPErrorLog'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3f0e3cc7-ec1c-475a-8e4e-d6ea60b1a190 CREATE NONCLUSTERED INDEX [IX_EventsPPErrorLog] ON dbo.[EventsPPErrorLog] ([CreateDate] DESC) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsPPErrorLogAdd' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3bae2d0f-10dd-4e48-87e0-882d2602bfb6 /*** EventsPPErrorLogAdd ***/ CREATE PROCEDURE dbo.[EventsPPErrorLogAdd] ( @SignupID INT , @PayPalStatus NVARCHAR(50) , @PayPalReason NVARCHAR(100) , @PayPalTransID NVARCHAR(50) , @PayPalPayerID NVARCHAR(50) , @PayPalPayerStatus NVARCHAR(50) , @PayPalRecieverEmail NVARCHAR(100) , @PayPalUserEmail NVARCHAR(100) , @PayPalPayerEmail NVARCHAR(100) , @PayPalFirstName NVARCHAR(50) , @PayPalLastName NVARCHAR(50) , @PayPalAddress NVARCHAR(100) , @PayPalCity NVARCHAR(25) , @PayPalState NVARCHAR(25) , @PayPalZip NVARCHAR(25) , @PayPalCountry NVARCHAR(25) , @PayPalCurrency NVARCHAR(25) , @PayPalPaymentDate DATETIME , @PayPalAmount MONEY , @PayPalFee MONEY ) AS SET DATEFORMAT mdy INSERT dbo.[EventsPPErrorLog] ( SignupID , PayPalStatus , PayPalReason , PayPalTransID , PayPalPayerID , PayPalPayerStatus , PayPalRecieverEmail , PayPalUserEmail , PayPalPayerEmail , PayPalFirstName , PayPalLastName , PayPalAddress , PayPalCity , PayPalState , PayPalZip , PayPalCountry , PayPalCurrency , PayPalPaymentDate , PayPalAmount , PayPalFee ) VALUES ( @SignupID , @PayPalStatus , @PayPalReason , @PayPalTransID , @PayPalPayerID , @PayPalPayerStatus , @PayPalRecieverEmail , @PayPalUserEmail , @PayPalPayerEmail , @PayPalFirstName , @PayPalLastName , @PayPalAddress , @PayPalCity , @PayPalState , @PayPalZip , @PayPalCountry , @PayPalCurrency , @PayPalPaymentDate , @PayPalAmount , @PayPalFee ) SELECT s.PayPalID , s.SignupID , CreateDate , PayPalStatus , PayPalReason , PayPalTransID , PayPalPayerID , PayPalPayerStatus , PayPalRecieverEmail , PayPalUserEmail , PayPalPayerEmail , PayPalFirstName , PayPalLastName , PayPalAddress , PayPalCity , PayPalState , PayPalZip , PayPalCountry , PayPalCurrency , PayPalPaymentDate , PayPalAmount , PayPalFee FROM dbo.[EventsPPErrorLog] s WHERE s.PayPalID = @@Identity System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsUpgrade' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:6727d3a3-b4ce-4fe4-b908-28674882d30e /*** EventsUpgrade ***/ CREATE PROCEDURE dbo.[EventsUpgrade] ( @Version VARCHAR(8) ) AS IF @Version = '04.00.02' BEGIN -- Copy over Moderators from ModuleSettings INSERT INTO dbo.[ModulePermission] ( RoleID , ModuleID , PermissionID , AllowAccess ) SELECT dbo.[Modulesettings].SettingValue AS RoleID , dbo.[Modulesettings].ModuleID , dbo.[Permission].PermissionID , -1 AS AllowAccess FROM dbo.[Modulesettings] INNER JOIN dbo.[Modules] ON dbo.[Modulesettings].ModuleID = dbo.[Modules].ModuleID INNER JOIN dbo.[ModuleDefinitions] ON dbo.[Modules].ModuleDefID = dbo.[ModuleDefinitions].ModuleDefID CROSS JOIN dbo.[Permission] WHERE ( dbo.[Modulesettings].SettingName = 'moderatorroleid' ) AND ( dbo.[Modulesettings].SettingValue <> '0' ) AND ( dbo.[ModuleDefinitions].FriendlyName = N'Events' ) AND ( dbo.[Permission].PermissionCode = 'EVENTS_MODULE' ) AND ( dbo.[Permission].PermissionKey = 'EVENTSMOD' ) -- Ensure Moderators have edit permissions INSERT INTO dbo.[ModulePermission] ( RoleID , ModuleID , PermissionID , AllowAccess ) SELECT MP1.RoleID , MP1.ModuleID , P3.PermissionID , -1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE ( P1.PermissionCode = 'Events_Module' ) AND ( P1.PermissionKey = 'EVENTSMOD' ) AND ( MP1.RoleID NOT IN ( SELECT MP2.RoleID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE ( P2.PermissionCode = 'SYSTEM_MODULE_DEFINITION' ) AND ( P2.PermissionKey = 'EDIT' ) AND ( MD2.FriendlyName = N'Events' ) AND ( M2.ModuleID = MP1.ModuleID ) ) ) AND ( P3.PermissionCode = 'SYSTEM_MODULE_DEFINITION' ) AND ( P3.PermissionKey = 'EDIT' ) -- Delete Moderator settings from ModuleSettings DELETE FROM dbo.[Modulesettings] FROM dbo.[Modulesettings] INNER JOIN dbo.[Modules] ON dbo.[Modulesettings].ModuleID = dbo.[Modules].ModuleID INNER JOIN dbo.[ModuleDefinitions] ON dbo.[Modules].ModuleDefID = dbo.[ModuleDefinitions].ModuleDefID WHERE ( dbo.[Modulesettings].SettingName = 'moderatorroleid' ) AND ( dbo.[ModuleDefinitions].FriendlyName = N'Events' ) END IF @Version = '04.01.00' BEGIN UPDATE dbo.[EventsNotification] SET EventID = E2.EventID FROM dbo.[EventsNotification] INNER JOIN dbo.[Events] AS E ON dbo.[EventsNotification].EventID = E.EventID LEFT OUTER JOIN dbo.[Events] AS E2 ON E.RecurMasterID = E2.RecurMasterID AND dbo.[EventsNotification].EventTimeBegin = E2.EventTimeBegin WHERE E2.EventTimeBegin IS NOT NULL UPDATE dbo.[EventsSignups] SET EventID = E2.EventID FROM dbo.[EventsSignups] INNER JOIN dbo.[Events] AS E ON dbo.[EventsSignups].EventID = E.EventID LEFT OUTER JOIN dbo.[Events] AS E2 ON E.RecurMasterID = E2.RecurMasterID AND dbo.[EventsSignups].EventTimeBegin = E2.EventTimeBegin WHERE E2.EventTimeBegin IS NOT NULL END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSignupsGetEventRecurMaster' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:36fa0ec2-7449-42c9-9780-20d5c3b7796f /*** EventsSignupsGetEventRecurMaster ***/ CREATE PROCEDURE dbo.EventsSignupsGetEventRecurMaster ( @RecurMasterID INT , @ModuleID INT ) AS SET DATEFORMAT mdy SELECT DISTINCT s.EventID , s.SignupID , s.ModuleID , s.Userid , s.Approved , --u.FirstName + ' ' + u.LastName as UserName, u.DisplayName AS UserName , u.Email , c.EventTimeBegin , c.Duration , c.EventName , c.Importance , c.Approved AS EventApproved , c.MaxEnrollment , ( SELECT SUM(NoEnrolees) 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 , NoEnrolees FROM dbo.EventsRecurMaster AS r INNER JOIN dbo.Events AS c ON r.RecurMasterID = c.RecurMasterID RIGHT OUTER JOIN dbo.EventsSignups AS s LEFT OUTER JOIN dbo.Users AS u ON s.UserID = u.UserID ON c.EventID = s.EventID LEFT OUTER JOIN dbo.EventsMaster AS m ON s.ModuleID = m.SubEventID WHERE r.RecurMasterID = @RecurMasterID AND ( s.ModuleID = @ModuleID OR m.ModuleID = @ModuleID ) ORDER BY c.EventTimeBegin , c.EventName , UserName System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSignupsGetUser' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a6de2e15-6e7f-4b4b-9602-32976467fea9 /*** EventsSignupsGetUser ***/ CREATE PROCEDURE dbo.EventsSignupsGetUser ( @EventID INT , @UserID INT , @ModuleID INT ) AS SET DATEFORMAT mdy SELECT DISTINCT s.EventID , s.SignupID , s.ModuleID , s.Userid , s.Approved , -- u.FirstName + ' ' + u.LastName as UserName, u.DisplayName AS USerName , u.Email , c.EventTimeBegin , c.Duration , c.EventName , c.Importance , c.Approved AS EventApproved , c.MaxEnrollment , ( SELECT SUM(NoEnrolees) 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 , NoEnrolees FROM dbo.EventsSignups s LEFT JOIN dbo.Users u ON s.UserID = u.UserID LEFT JOIN dbo.Events c ON s.EventID = c.EventID LEFT OUTER JOIN dbo.EventsMaster m ON s.ModuleID = m.SubEventID WHERE s.EventID = @EventID AND s.Userid = @UserID AND ( s.ModuleID = @ModuleID OR m.ModuleID = @ModuleID ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSignupsGet' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8fe8464f-f5d6-45d8-8615-556dbbb8ecb3 /*** EventsSignupsGet ***/ CREATE PROCEDURE dbo.EventsSignupsGet ( @SignupID INT , @ModuleID INT , @PPIPN BIT ) AS SET DATEFORMAT mdy SELECT DISTINCT s.EventID , s.SignupID , s.ModuleID , s.Userid , s.Approved , --u.FirstName + ' ' + u.LastName as UserName,# u.DisplayName AS UserName , u.Email , c.EventTimeBegin , c.Duration , c.EventName , c.Importance , c.Approved AS EventApproved , c.MaxEnrollment , ( SELECT SUM(NoEnrolees) 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 , NoEnrolees FROM dbo.EventsSignups s LEFT JOIN dbo.Users u ON s.UserID = u.UserID LEFT JOIN dbo.Events c ON s.EventID = c.EventID LEFT OUTER JOIN dbo.EventsMaster m ON s.ModuleID = m.SubEventID WHERE s.SignupID = @SignupID AND ( s.ModuleID = @ModuleID OR m.ModuleID = @ModuleID OR @PPIPN <> 0 ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSignupsGetEvent' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8fe8464f-f5d6-45d8-8615-556dbbb8ecb3 /*** EventsSignupsGetEvent ***/ CREATE PROCEDURE dbo.EventsSignupsGetEvent ( @EventID INT , @ModuleID INT ) AS SET DATEFORMAT mdy SELECT DISTINCT s.EventID , s.SignupID , s.ModuleID , s.Userid , s.Approved , --u.FirstName + ' ' + u.LastName as UserName, u.DisplayName AS UserName , u.Email , c.EventTimeBegin , c.Duration , c.EventName , c.Importance , c.Approved AS EventApproved , c.MaxEnrollment , ( SELECT SUM(NoEnrolees) 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 , NoEnrolees FROM dbo.EventsSignups s LEFT JOIN dbo.Users u ON s.UserID = u.UserID LEFT JOIN dbo.Events c ON s.EventID = c.EventID LEFT OUTER JOIN dbo.EventsMaster m ON s.ModuleID = m.SubEventID WHERE s.EventID = @EventID AND ( s.ModuleID = @ModuleID OR m.ModuleID = @ModuleID ) ORDER BY c.EventTimeBegin , c.EventName , UserName System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSignupsSave' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a6de2e15-6e7f-4b4b-9602-32976467fea9 /*** EventsSignupsSave ***/ CREATE PROCEDURE dbo.[EventsSignupsSave] ( @EventID INT , @SignupID INT , @ModuleID INT , @UserID INT , @Approved INT , @PayPalStatus NVARCHAR(50) , @PayPalReason NVARCHAR(100) , @PayPalTransID NVARCHAR(50) , @PayPalPayerID NVARCHAR(50) , @PayPalPayerStatus NVARCHAR(50) , @PayPalRecieverEmail NVARCHAR(100) , @PayPalUserEmail NVARCHAR(100) , @PayPalPayerEmail NVARCHAR(100) , @PayPalFirstName NVARCHAR(50) , @PayPalLastName NVARCHAR(50) , @PayPalAddress NVARCHAR(100) , @PayPalCity NVARCHAR(25) , @PayPalState NVARCHAR(25) , @PayPalZip NVARCHAR(25) , @PayPalCountry NVARCHAR(25) , @PayPalCurrency NVARCHAR(25) , @PayPalPaymentDate DATETIME , @PayPalAmount MONEY , @PayPalFee MONEY , @NoEnrolees 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 , NoEnrolees ) VALUES ( @EventID , @ModuleID , @UserID , @Approved , @PayPalStatus , @PayPalReason , @PayPalTransID , @PayPalPayerID , @PayPalPayerStatus , @PayPalRecieverEmail , @PayPalUserEmail , @PayPalPayerEmail , @PayPalFirstName , @PayPalLastName , @PayPalAddress , @PayPalCity , @PayPalState , @PayPalZip , @PayPalCountry , @PayPalCurrency , @PayPalPaymentDate , @PayPalAmount , @PayPalFee , @NoEnrolees ) ELSE UPDATE dbo.[EventsSignups] SET EventID = @EventID , 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 , NoEnrolees = @NoEnrolees WHERE SignupID = @SignupID AND ModuleID = @ModuleID SELECT s.EventID , s.SignupID , s.ModuleID , s.Userid , s.Approved , u.DisplayName AS UserName , u.Email , c.EventTimeBegin , c.Duration , c.EventName , c.Importance , c.Approved AS EventApproved , c.MaxEnrollment , ( SELECT SUM(NoEnrolees) 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 , NoEnrolees 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 c.EventTimeBegin , c.EventName , UserName System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsRecurMasterGet' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:36fa0ec2-7449-42c9-9780-20d5c3b7796f /* EventsRecurMasterGet */ CREATE PROCEDURE dbo.[EventsRecurMasterGet] ( @RecurMasterID INT , @ModuleID INT ) AS SELECT RecurMasterID , ModuleID , PortalID , RRULE , DTSTART , Duration , Until , EventName , EventDesc , Importance , Notify , Approved , Signups , MaxEnrollment , ( SELECT SUM(NoEnrolees) FROM dbo.[Events] AS E INNER JOIN dbo.[EventsSignups] AS S ON E.EventID = S.EventID WHERE E.RecurMasterID = R.RecurMasterID AND E.Signups = 1 ) AS Enrolled , EnrollRoleID , EnrollFee , EnrollType , PayPalAccount , DetailPage , DetailNewWin , DetailURL , ImageURL , ImageType , ImageWidth , ImageHeight , ImageDisplay , Location , Category , Reminder , TimezoneOffset , SendReminder , ReminderTime , ReminderTimeMeasurement , ReminderFrom , CustomField1 , CustomField2 , EnrollListView , DisplayEndDate , AllDayEvent , CultureName , OwnerID , CreatedByID , CreatedDate , UpdatedByID , UpdatedDate FROM dbo.[EventsRecurMaster] R WHERE RecurMasterID = @RecurMasterID AND ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsCleanupExpired' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:6727d3a3-b4ce-4fe4-b908-28674882d30e /*** EventsCleanupExpired ***/ CREATE PROCEDURE dbo.EventsCleanupExpired ( @PortalID INT , @ModuleID INT , @ExpireTime DATETIME ) AS UPDATE dbo.Events SET Cancelled = -1 , LastUpdatedAt = GETUTCDATE() WHERE PortalID = @PortalID AND ModuleID = @ModuleID AND DATEADD(minute, Duration, EventTimeBegin) < DATEADD(minute, TimezoneOffset, @ExpireTime) DELETE dbo.EventsRecurMaster WHERE PortalID = @PortalID AND ModuleID = @ModuleID AND 0 = ( SELECT COUNT(EventID) FROM dbo.Events WHERE dbo.Events.RecurMasterID = dbo.EventsRecurMaster.RecurMasterID AND dbo.Events.Cancelled = 0 ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsNotificationSave' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3bae2d0f-10dd-4e48-87e0-882d2602bfb6 /*** EventsNotificationSave ***/ CREATE PROCEDURE dbo.EventsNotificationSave ( @NotificationID INT , @EventID INT , @PortalAliasID INT , @UserEmail NVARCHAR(50) , @NotificationSent BIT , @NotifyByDateTime DATETIME , @EventTimeBegin DATETIME , @NotifyLanguage NVARCHAR(10) , @ModuleID INT , @TabID INT ) AS SET DATEFORMAT mdy IF @NotificationID = -1 OR @NotificationID IS NULL INSERT dbo.EventsNotification ( EventID , PortalAliasID , UserEmail , NotificationSent , NotifyByDateTime , EventTimeBegin , NotifyLanguage , ModuleID , TabID ) VALUES ( @EventID , @PortalAliasID , @UserEmail , @NotificationSent , @NotifyByDateTime , @EventTimeBegin , @NotifyLanguage , @ModuleID , @TabID ) ELSE UPDATE dbo.EventsNotification SET EventID = @EventID , PortalAliasID = @PortalAliasID , UserEmail = @UserEmail , NotificationSent = @NotificationSent , NotifyByDateTime = @NotifyByDateTime , EventTimeBegin = @EventTimeBegin , NotifyLanguage = @NotifyLanguage , TabID = @TabID WHERE NotificationID = @NotificationID AND ModuleID = @ModuleID SELECT * FROM dbo.EventsNotification WHERE NotificationID = SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsNotificationGet' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:3f0e3cc7-ec1c-475a-8e4e-d6ea60b1a190 /*** EventsNotificationGet ***/ CREATE PROCEDURE dbo.EventsNotificationGet ( @EventID INT , @UserEmail NVARCHAR(50) , @ModuleID INT ) AS SELECT DISTINCT NotificationID , EventID , PortalAliasID , UserEmail , NotificationSent , NotifyByDateTime , EventTimeBegin , NotifyLanguage , n.ModuleID , n.TabID FROM dbo.EventsNotification n LEFT OUTER JOIN dbo.EventsMaster m ON n.ModuleID = m.SubEventID WHERE EventID = @EventID AND UserEmail = @UserEmail AND ( n.ModuleID = @ModuleID OR m.ModuleID = @ModuleID ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsNotificationsToSend' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:6dbe2266-c3e2-4629-b6e1-ab703f811afb /*** EventsNotificationToSend ***/ CREATE PROCEDURE dbo.EventsNotificationsToSend ( @NotifyTime DATETIME ) AS SELECT n.NotificationID , n.EventID , n.PortalAliasID , n.UserEmail , n.NotificationSent , n.NotifyByDateTime , n.EventTimeBegin , n.NotifyLanguage , e.TimezoneOffset , n.ModuleID , n.TabID FROM dbo.[EventsNotification] AS n INNER JOIN dbo.[Events] AS e ON n.EventID = e.EventID AND n.NotifyByDateTime <= DATEADD(minute, e.TimezoneOffset, @NotifyTime) WHERE ( n.NotificationSent = 0 ) ORDER BY n.NotifyByDateTime System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsGet' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f7c14bc4-6ec8-4399-9a5d-7403cedaae30 /**** EventsGet ****/ CREATE PROCEDURE dbo.[EventsGet] ( @EventID INT , @ModuleID INT ) AS SET DATEFORMAT mdy CREATE TABLE #RealModuleID ( EventID INT , ModuleID INT ) INSERT INTO #RealModuleID ( EventID , ModuleID ) SELECT DISTINCT e.EventID , e.ModuleID FROM dbo.[Events] e LEFT OUTER JOIN dbo.[EventsMaster] m ON e.ModuleID = m.SubEventID WHERE EventID = @EventID AND ( e.ModuleID = @ModuleID OR m.ModuleID = @ModuleID ) 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 , E.CreatedByID , E.Every , E.Period , E.RepeatType , E.Notify , E.Approved , E.Signups , E.MaxEnrollment , ( SELECT SUM(NoEnrolees) FROM dbo.[EventsSignups] WHERE EventID = E.EventID AND E.Signups = 1 ) AS Enrolled , ( SELECT COUNT(*) FROM dbo.[Events] AS E2 WHERE E2.RecurMasterID = E.RecurMasterID AND E2.Cancelled = 0 AND E2.Approved = 1 ) AS NoOfRecurrences , ( SELECT MAX(EventDateBegin) FROM dbo.[Events] AS E2 WHERE E2.RecurMasterID = E.RecurMasterID AND E2.Cancelled = 0 AND E2.Approved = 1 ) AS LastRecurrence , E.EnrollRoleID , E.EnrollFee , E.EnrollType , E.PayPalAccount , E.Cancelled , E.DetailPage , E.DetailNewWin , E.DetailURL , 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 , r.RRULE , RMOwnerID = r.OwnerID , 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.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 EventID = @EventID AND e.ModuleID = ( SELECT ModuleID FROM #RealModuleID WHERE EventID = @EventID ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsGetRecurrences' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:9a57cdec-a68b-4a38-93ec-bc1475490f3a /*** 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 , 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 System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsModerateSignups' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:5760e527-fee0-448f-bbc9-bd4a2468b410 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 (0x80131904): There is already an object named 'EventsNotificationDelete' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d1cce6c6-fdbe-4a99-a21c-1118f2895f89 CREATE PROCEDURE dbo.EventsNotificationDelete ( @DeleteDateTime DATETIME ) AS DELETE dbo.EventsNotification WHERE NotifyBydateTime <= @DeleteDateTime AND NotificationSent != 0 System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsMasterGet' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:fd93db57-b604-4c21-915c-57a63ea11fd0 /*** EventsMasterGet ***/ CREATE PROCEDURE dbo.EventsMasterGet ( @ModuleID INT , @SubEventID INT ) AS SELECT @ModuleID AS ModuleID , b.PortalID , 0 AS MasterID , a.ModuleID AS SubEventID 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 b.PortalID , a.ModuleID ORDER BY b.PortalID , a.ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsMasterAssignedModules' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:4333c4c2-d5c6-4183-855c-a455286ae3e7 /*** EventsMasterAssignedModules ***/ CREATE PROCEDURE dbo.EventsMasterAssignedModules ( @ModuleID INT ) AS SELECT a.ModuleID AS ModuleID , 0 AS PortalID , a.MasterID , a.SubEventID AS SubEventID FROM dbo.EventsMaster a LEFT JOIN dbo.TabModules t ON a.SubEventID = t.ModuleID WHERE a.ModuleID = @ModuleID AND t.IsDeleted = 0 GROUP BY a.MasterID , a.ModuleID , a.SubEventID ORDER BY a.MasterID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsMasterAvailableModules' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:f00e9a4e-4c35-4891-8d9b-c7ab5368e624 /*** EventsMasterAvailableModules ***/ CREATE PROCEDURE dbo.EventsMasterAvailableModules ( @PortalID INT , @ModuleID INT ) AS SELECT @ModuleID AS ModuleID , c.PortalID , 0 AS MasterID , a.ModuleID AS SubEventID 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 AND t.IsDeleted = 0 GROUP BY c.PortalID , a.ModuleID ORDER BY c.PortalID , a.ModuleID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSave' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:79b60b4c-21ad-4421-ab24-7a9e58d4557a /* EventsSave */ CREATE PROCEDURE dbo.[EventsSave] ( @PortalID INT , @EventID INT , @RecurMasterID INT , @ModuleID INT , @EventTimeBegin DATETIME , @Duration INT , @EventName NVARCHAR(100) , @EventDesc NTEXT , @Importance INT , @CreatedByID INT , @Notify NVARCHAR(2048) , @Approved BIT , @Signups BIT , @MaxEnrollment INT , @EnrollRoleID INT , @EnrollFee MONEY , @EnrollType VARCHAR(10) , @PayPalAccount NVARCHAR(100) , @Cancelled BIT , @DetailPage BIT , @DetailNewWin BIT , @DetailURL NVARCHAR(100) , @ImageURL NVARCHAR(100) , @ImageType VARCHAR(1) , @ImageWidth INT , @ImageHeight INT , @ImageDisplay BIT , @Location INT , @Category INT , @Reminder NVARCHAR(2048) , @TimezoneOffset INT , @SendReminder BIT , @ReminderTime INT , @ReminderTimeMeasurement VARCHAR(2) , @ReminderFrom NVARCHAR(100) , @SearchSubmitted BIT , @CustomField1 NVARCHAR(100) , @CustomField2 NVARCHAR(100) , @EnrollListView BIT , @DisplayEndDate BIT , @AllDayEvent BIT , @OwnerID INT , @LastUpdatedID INT , @OriginalDateBegin DATETIME , @NewEventEmailSent BIT , @SaveOnly BIT ) AS SET DATEFORMAT mdy IF @Location = -1 SELECT @Location = NULL IF @Category = -1 SELECT @Category = NULL IF @EnrollRoleID = -1 SELECT @EnrollRoleID = NULL IF @ImageURL = N'' SELECT @ImageURL = NULL IF @ImageType = '' SELECT @ImageType = NULL IF @DetailURL = N'' SELECT @DetailURL = NULL IF @EventID = -1 OR @EventID IS NULL INSERT dbo.[Events] ( PortalID , RecurMasterID , ModuleID , EventTimeBegin , Duration , EventName , EventDesc , Importance , CreatedByID , Notify , Approved , Signups , MaxEnrollment , EnrollRoleID , EnrollFee , EnrollType , PayPalAccount , Cancelled , DetailPage , DetailNewWin , DetailURL , ImageURL , ImageType , ImageWidth , ImageHeight , ImageDisplay , Location , Category , Reminder , TimezoneOffset , SendReminder , ReminderTime , ReminderTimeMeasurement , ReminderFrom , SearchSubmitted , CustomField1 , CustomField2 , EnrollListView , DisplayEndDate , AllDayEvent , OwnerID , LastUpdatedAt , LastUpdatedID , OriginalDateBegin , NewEventEmailSent ) VALUES ( @PortalID , @RecurMasterID , @ModuleID , @EventTimeBegin , @Duration , @EventName , @EventDesc , @Importance , @CreatedByID , @Notify , @Approved , @Signups , @MaxEnrollment , @EnrollRoleID , @EnrollFee , @EnrollType , @PayPalAccount , @Cancelled , @DetailPage , @DetailNewWin , @DetailURL , @ImageURL , @ImageType , @ImageWidth , @ImageHeight , @ImageDisplay , @Location , @Category , @Reminder , @TimezoneOffset , @SendReminder , @ReminderTime , @ReminderTimeMeasurement , @ReminderFrom , @SearchSubmitted , @CustomField1 , @CustomField2 , @EnrollListView , @DisplayEndDate , @AllDayEvent , @OwnerID , GETUTCDATE() , @LastUpdatedID , @OriginalDateBegin , @NewEventEmailSent ) ELSE UPDATE dbo.[Events] SET PortalID = @PortalID , RecurMasterID = @RecurMasterID , EventTimeBegin = @EventTimeBegin , Duration = @Duration , EventName = @EventName , EventDesc = @EventDesc , Importance = @Importance , Notify = @Notify , Approved = @Approved , Signups = @Signups , MaxEnrollment = @MaxEnrollment , EnrollRoleID = @EnrollRoleID , EnrollFee = @EnrollFee , EnrollType = @EnrollType , PayPalAccount = @PayPalAccount , Cancelled = @Cancelled , DetailPage = @DetailPage , DetailNewWin = @DetailNewWin , DetailURL = @DetailURL , 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 , CustomField1 = @CustomField1 , CustomField2 = @CustomField2 , EnrollListView = @EnrollListView , DisplayEndDate = @DisplayEndDate , AllDayEvent = @AllDayEvent , OwnerID = @OwnerID , LastUpdatedAt = GETUTCDATE() , LastUpdatedID = @LastUpdatedID , OriginalDateBegin = @OriginalDateBegin , NewEventEmailSent = @NewEventEmailSent WHERE EventID = @EventID AND ModuleID = @ModuleID IF @SaveOnly = 0 SELECT E.PortalID , EventID , E.RecurMasterID , E.ModuleID , E.EventDateBegin , E.EventDateEnd , E.EventTimeBegin , E.Duration , E.EventName , E.EventDesc , E.Importance , E.CreatedDate , CreatedBy = U.DisplayName , E.CreatedByID , 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 , ( SELECT COUNT(*) FROM dbo.[Events] AS E2 WHERE E2.RecurMasterID = E.RecurMasterID AND E2.Cancelled = 0 AND E2.Approved = 1 ) AS NoOfRecurrences , ( SELECT MAX(EventDateBegin) FROM dbo.[Events] AS E2 WHERE E2.RecurMasterID = E.RecurMasterID AND E2.Cancelled = 0 AND E2.Approved = 1 ) AS LastRecurrence , E.EnrollRoleID , E.EnrollFee , E.EnrollType , E.PayPalAccount , E.Cancelled , E.DetailPage , E.DetailNewWin , E.DetailURL , E.ImageURL , E.ImageType , E.ImageWidth , E.ImageHeight , E.ImageDisplay , c.Location , c.LocationName , c.MapURL , b.Category , b.CategoryName , b.Color , b.FontColor , E.Reminder , E.TimezoneOffset , E.SendReminder , E.ReminderTime , E.ReminderTimeMeasurement , E.ReminderFrom , E.CustomField1 , E.CustomField2 , E.EnrollListView , E.DisplayEndDate , E.AllDayEvent , E.OwnerID , OwnerName = O.DisplayName , E.LastUpdatedAt , LastUpdatedBy = L.DisplayName , E.LastUpdatedID , r.RRULE , RMOwnerID = r.OwnerID , 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.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 EventID = SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSignupsMyEnrollments' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:10677dc8-0917-45da-a9bb-48ba2f557001 /** EventsSignupsMyEnrollments **/ CREATE PROCEDURE dbo.EventsSignupsMyEnrollments ( @ModuleID INT , @UserID INT ) AS SET DATEFORMAT mdy SELECT DISTINCT s.EventID , s.SignupID , s.ModuleID , s.Userid , s.Approved , u.displayName AS UserName , u.Email , c.EventTimeBegin , DATEADD(mi, c.Duration, c.EventTimeBegin) AS EventTimeEnd , c.EventName , c.Importance , c.Approved AS EventApproved , c.MaxEnrollment , ( SELECT SUM(NoEnrolees) 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 , NoEnrolees FROM dbo.EventsSignups s LEFT JOIN dbo.Users u ON s.UserID = u.UserID LEFT JOIN dbo.Events c ON s.EventID = c.EventID LEFT OUTER JOIN dbo.EventsMaster e ON s.ModuleID = e.SubEventID WHERE s.Userid = @UserID AND ( s.ModuleID = @ModuleID OR e.ModuleID = @ModuleID ) ORDER BY c.EventTimeBegin DESC System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsGetByRange' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:fe73b241-acfe-4655-bf7f-d7122b55ed5b /**** EventsGetByRange ****/ CREATE PROCEDURE dbo.[EventsGetByRange] ( @ModuleIDs NVARCHAR(1024) , @BeginDate DATETIME , @EndDate DATETIME , @CategoryID INT ) AS CREATE TABLE #EventIDs ( EventID INT , NoOfRecurrences INT , LastRecurrence DATETIME ) INSERT INTO #EventIDs ( EventID , NoOfRecurrences , LastRecurrence ) SELECT DISTINCT e.EventID , COUNT(E2.EventID) AS NoOfRecurrences , MAX(E2.EventTimeBegin) AS LastRecurrence FROM dbo.[Events] E LEFT OUTER JOIN dbo.[EventsMaster] M ON E.ModuleID = M.SubEventID LEFT JOIN dbo.[Events] AS E2 ON E.RecurMasterID = E2.RecurMasterID WHERE ( ( E.EventTimeBegin < DATEADD(DAY, 1, @EndDate) AND DATEADD(minute, E.Duration, E.EventTimeBegin) >= @BeginDate ) OR ( E.EventTimeBegin >= @BeginDate AND E.EventTimeBegin < DATEADD(DAY, 1, @EndDate) ) ) AND E.Approved = 1 AND E.Cancelled = 0 AND ( E.ModuleID IN ( SELECT * FROM dbo.[SplitIDs](@ModuleIDs) ) ) GROUP BY E.EventID 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 , E.CreatedByID , E.Every , E.Period , E.RepeatType , E.Notify , E.approved , E.Signups , E.MaxEnrollment , ( SELECT SUM(NoEnrolees) FROM dbo.[EventsSignups] WHERE EventID = E.EventID AND E.Signups = 1 ) AS Enrolled , ET.NoOfRecurrences , ET.LastRecurrence , E.EnrollRoleID , E.EnrollFee , E.EnrollType , E.PayPalAccount , E.Cancelled , E.DetailPage , E.DetailNewWin , E.DetailURL , 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 , 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.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 LEFT JOIN #EventIDs ET ON E.EventID = ET.EventID WHERE E.EventID IN ( SELECT EventID FROM #EventIDs ) AND ( e.Category = @CategoryID OR @CategoryID = -1 ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsDelete' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:898a4dbd-a720-4d42-906d-3f4cba3bb9d8 CREATE PROCEDURE dbo.EventsDelete ( @EventID INT , @ModuleID INT ) AS DELETE FROM dbo.Events FROM dbo.Events LEFT OUTER JOIN dbo.EventsMaster ON dbo.Events.ModuleID = dbo.EventsMaster.SubEventID WHERE EventID = @EventID AND ( dbo.Events.ModuleID = @ModuleID OR dbo.EventsMaster.ModuleID = @ModuleID ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsSignupsDelete' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:28404fe4-c7e2-42b2-90be-411d77a43777 CREATE PROCEDURE dbo.EventsSignupsDelete ( @SignupID INT , @ModuleID INT ) AS DELETE FROM dbo.EventsSignups FROM dbo.EventsSignups LEFT OUTER JOIN dbo.EventsMaster ON dbo.EventsSignups.ModuleID = dbo.EventsMaster.SubEventID WHERE SignupID = @SignupID AND ( dbo.EventsSignups.ModuleID = @ModuleID OR dbo.EventsMaster.ModuleID = @ModuleID ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'EventsCategoryDelete' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:c0b525fb-d4fc-470b-a1fe-7d24e7adc991 /*** EventsCategoryDelete ***/ CREATE PROCEDURE dbo.EventsCategoryDelete ( @Category INT , @PortalID INT ) AS UPDATE dbo.EventsRecurMaster SET Category = NULL WHERE Category = @Category AND PortalID = @PortalID UPDATE dbo.Events SET Category = NULL WHERE Category = @Category AND PortalID = @PortalID DELETE dbo.EventsCategory WHERE Category = @Category AND PortalID = @PortalID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'IX_EventsMaster' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:6ce5cafa-406e-4a1e-a100-458ed51ad6e6 ALTER TABLE dbo.[EventsMaster] ADD CONSTRAINT [IX_EventsMaster] UNIQUE NONCLUSTERED ([MasterID], [SubEventID]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'IX_EventsNotification_2' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:85bebc84-4296-4ab6-9052-ebc42f2911ac ALTER TABLE dbo.[EventsNotification] ADD CONSTRAINT [IX_EventsNotification_2] UNIQUE NONCLUSTERED ([EventID], [UserEmail], [EventTimeBegin]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'IX_EventsSignups' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:1e37d7b2-158f-4f7b-a042-60ef1741d060 ALTER TABLE dbo.[EventsSignups] ADD CONSTRAINT [IX_EventsSignups] UNIQUE NONCLUSTERED ([ModuleID], [EventID], [UserID]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsNotification_Events' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:28388733-4597-479c-b438-38b23588aa23 ALTER TABLE dbo.[EventsNotification] WITH NOCHECK ADD CONSTRAINT [FK_EventsNotification_Events] FOREIGN KEY ([EventID]) REFERENCES dbo.[Events] ([EventID]) ON DELETE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_Events_EventsLocation' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:af0ea0f1-1dab-45ad-aa39-3d4d6e2899c5 ALTER TABLE dbo.[Events] WITH NOCHECK ADD CONSTRAINT [FK_Events_EventsLocation] FOREIGN KEY ([Location]) REFERENCES dbo.[EventsLocation] ([Location]) ALTER TABLE dbo.[Events] WITH NOCHECK ADD CONSTRAINT [FK_Events_EventsCategory] FOREIGN KEY ([Category]) REFERENCES dbo.[EventsCategory] ([Category]) ALTER TABLE dbo.[Events] WITH NOCHECK ADD CONSTRAINT [FK_Events_EventsRecurMaster] FOREIGN KEY ([RecurMasterID]) REFERENCES dbo.[EventsRecurMaster] ([RecurMasterID]) ON DELETE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsRecurMaster_EventsCategory' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d805e602-7a26-4435-b109-75d9ccf170dd ALTER TABLE dbo.[EventsRecurMaster] WITH NOCHECK ADD CONSTRAINT [FK_EventsRecurMaster_EventsCategory] FOREIGN KEY ([Category]) REFERENCES dbo.[EventsCategory] ([Category]) ALTER TABLE dbo.[EventsRecurMaster] WITH NOCHECK ADD CONSTRAINT [FK_EventsRecurMaster_EventsLocation] FOREIGN KEY ([Location]) REFERENCES dbo.[EventsLocation] ([Location]) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsPPErrorLog_EventsSignups' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:02f233e7-f6db-4fef-a577-c75754643a7c ALTER TABLE dbo.[EventsPPErrorLog] WITH NOCHECK ADD CONSTRAINT [FK_EventsPPErrorLog_EventsSignups] FOREIGN KEY ([SignupID]) REFERENCES dbo.[EventsSignups] ([SignupID]) ON DELETE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsSignups_Events' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:c666a5e5-a6b1-4747-8b18-4dec2a0694ba ALTER TABLE dbo.[EventsSignups] ADD CONSTRAINT [FK_EventsSignups_Events] FOREIGN KEY ([EventID]) REFERENCES dbo.[Events] ([EventID]) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsCategory_Portals' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:2c68b38e-5f13-4c6e-9239-8382fedaf321 ALTER TABLE dbo.[EventsCategory] ADD CONSTRAINT [FK_EventsCategory_Portals] FOREIGN KEY ([PortalID]) REFERENCES dbo.[Portals] ([PortalID]) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsLocation_Portals' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a7516f93-06e1-4837-8c4c-99a99205a316 ALTER TABLE dbo.[EventsLocation] ADD CONSTRAINT [FK_EventsLocation_Portals] FOREIGN KEY ([PortalID]) REFERENCES dbo.[Portals] ([PortalID]) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsMaster_Modules' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:bca511bb-d005-4fc3-b8c6-fe7f5b95947f ALTER TABLE dbo.[EventsMaster] ADD CONSTRAINT [FK_EventsMaster_Modules] FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsRecurMaster_Modules' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:0be8498e-fb0d-413e-b2d0-3e1e20856439 ALTER TABLE dbo.[EventsRecurMaster] ADD CONSTRAINT [FK_EventsRecurMaster_Modules] FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_EventsSubscription_Modules' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d07bcfaa-c87b-474f-b0b1-c2825d15a25c ALTER TABLE dbo.[EventsSubscription] ADD CONSTRAINT [FK_EventsSubscription_Modules] FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE ALTER TABLE dbo.[EventsSubscription] ADD CONSTRAINT [FK_EventsSubscription_Users] FOREIGN KEY ([UserID]) REFERENCES dbo.[Users] ([UserID]) ON DELETE CASCADE
Info End Sql execution: Install.05.02.04.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Events
Info Deleted temporary install folder
EndJob Installation Failed


Return
 
 Page 3 of 7
Previous1234...7Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsA serious event: DNN Events 06.01.01 BETA is available!A serious event: DNN Events 06.01.01 BETA is available!


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