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 ForumsEventsEventsDNN 6.0.2 with Events 5.2.1, Installation Failed DNN 6.0.2 with Events 5.2.1, Installation Failed
Previous
 
Next
New Post
1/8/2012 12:10 PM
 
manu


Joined: 6/5/2008
Posts: 10

Hello,

I get the exception bellow when trying to install Events5.2.1 on dnn6.0.2.

I have updated dnn6.0.2 to dnn6.1.2 and I got the same exception.

I tried to install it several times with no success. (All tables and procedures were dropped before each attempt)

Is there any fix for this issue?

Thanks

 

Install Package:: DNN_Events5

Info:: Created - Installation\04.01.00.SqlDataProvider

Info:: Executing 04.01.00.SqlDataProvider

Info:: Start Sql execution: 04.01.00.SqlDataProvider file

Info:: SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Introducing FOREIGN KEY constraint 'FK_EventsRecurMaster_Modules' on table 'EventsRecurMaster' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[FK_EventsRecurMaster_Modules]') AND OBJECTPROPERTY(id, N'IsConstraint') = 1) ALTER TABLE dnn_mywebsite_usr.[EventsRecurMaster] ADD CONSTRAINT [FK_EventsRecurMaster_Modules] FOREIGN KEY ( [ModuleID] ) REFERENCES dnn_mywebsite_usr.[Modules] ( [ModuleID] ) ON DELETE CASCADE

Info:: End Sql execution: 04.01.00.SqlDataProvider file

Info:: Finished Sql execution

Info:: Installation Failed - Script

Info:: Installation Failed - DNN_Events

Info:: Deleted temporary install folder

Info:: Installation Failed

Server Name: My-PC
 
New Post
1/8/2012 12:58 PM
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
It seems strange that your installation is starting with the 04.01.00 data provider. For a fresh install it should start with 03.01.00. This suggests that your previous install has not been completely removed, and may be causing the problem.

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
1/9/2012 10:57 AM
 
manu


Joined: 6/5/2008
Posts: 10

It doesn’t start with 04.01.00, The installation always stops with executing  04.01.00.SqlDataProvider

I tried it on three different dnn602 instalations, did the upgrade to dnn612, the events module installation always stops with executing  04.01.00.SqlDataProvider. I always executed the events uninstall script under host/sql, and deleted the files under the desktop modules, between trials.

I even tried events 522 beta.

 

Thanks,

Manuela

 

Install Package:: DNN_Events

Info:: Starting Installation

Info:: Starting Installation - DNN_Events

Info:: Starting Installation - Script

Info:: Begin Sql execution

Info:: Folder Created - C:\inetpub\wwwroot\MyWebsite\DesktopModules\Events\Installation

Info:: Created - Installation\03.01.00.SqlDataProvider

Info:: Executing 03.01.00.SqlDataProvider

Info:: Start Sql execution: 03.01.00.SqlDataProvider file

Info:: End Sql execution: 03.01.00.SqlDataProvider file

Info:: Created - Installation\03.02.00.SqlDataProvider

Info:: Executing 03.02.00.SqlDataProvider

Info:: Start Sql execution: 03.02.00.SqlDataProvider file

Info:: End Sql execution: 03.02.00.SqlDataProvider file

Info:: Created - Installation\03.03.00.SqlDataProvider

Info:: Executing 03.03.00.SqlDataProvider

Info:: Start Sql execution: 03.03.00.SqlDataProvider file

Info:: End Sql execution: 03.03.00.SqlDataProvider file

Info:: Created - Installation\03.03.01.SqlDataProvider

Info:: Executing 03.03.01.SqlDataProvider

Info:: Start Sql execution: 03.03.01.SqlDataProvider file

Info:: End Sql execution: 03.03.01.SqlDataProvider file

Info:: Created - Installation\03.03.02.SqlDataProvider

Info:: Executing 03.03.02.SqlDataProvider

Info:: Start Sql execution: 03.03.02.SqlDataProvider file

Info:: End Sql execution: 03.03.02.SqlDataProvider file

Info:: Created - Installation\03.03.03.SqlDataProvider

Info:: Executing 03.03.03.SqlDataProvider

Info:: Start Sql execution: 03.03.03.SqlDataProvider file

Info:: End Sql execution: 03.03.03.SqlDataProvider file

Info:: Created - Installation\03.03.05.SqlDataProvider

Info:: Executing 03.03.05.SqlDataProvider

Info:: Start Sql execution: 03.03.05.SqlDataProvider file

Info:: End Sql execution: 03.03.05.SqlDataProvider file

Info:: Created - Installation\03.03.07.SqlDataProvider

Info:: Executing 03.03.07.SqlDataProvider

Info:: Start Sql execution: 03.03.07.SqlDataProvider file

Info:: End Sql execution: 03.03.07.SqlDataProvider file

Info:: Created - Installation\03.03.08.SqlDataProvider

Info:: Executing 03.03.08.SqlDataProvider

Info:: Start Sql execution: 03.03.08.SqlDataProvider file

Info:: End Sql execution: 03.03.08.SqlDataProvider file

Info:: Created - Installation\04.00.00.SqlDataProvider

Info:: Executing 04.00.00.SqlDataProvider

Info:: Start Sql execution: 04.00.00.SqlDataProvider file

Info:: End Sql execution: 04.00.00.SqlDataProvider file

Info:: Created - Installation\04.00.01.SqlDataProvider

Info:: Executing 04.00.01.SqlDataProvider

Info:: Start Sql execution: 04.00.01.SqlDataProvider file

Info:: End Sql execution: 04.00.01.SqlDataProvider file

Info:: Created - Installation\04.00.02.SqlDataProvider

Info:: Executing 04.00.02.SqlDataProvider

Info:: Start Sql execution: 04.00.02.SqlDataProvider file

Info:: End Sql execution: 04.00.02.SqlDataProvider file

Info:: Created - Installation\04.01.00.SqlDataProvider

Info:: Executing 04.01.00.SqlDataProvider

Info:: Start Sql execution: 04.01.00.SqlDataProvider file

Info:: SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Introducing FOREIGN KEY constraint 'FK_EventsRecurMaster_Modules' on table 'EventsRecurMaster' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[FK_EventsRecurMaster_Modules]') AND OBJECTPROPERTY(id, N'IsConstraint') = 1) ALTER TABLE  MyObjectQualifier.[EventsRecurMaster] ADD CONSTRAINT [FK_EventsRecurMaster_Modules] FOREIGN KEY ( [ModuleID] ) REFERENCES  MyObjectQualifier.Modules] ( [ModuleID] ) ON DELETE CASCADE

Info:: End Sql execution: 04.01.00.SqlDataProvider file

Info:: Finished Sql execution

Info:: Installation Failed - Script

Info:: Installation Failed - DNN_Events

Info:: Deleted temporary install folder

Info:: Installation Failed

Server Name: My-PC
 
New Post
1/9/2012 12:30 PM
 
Roger Selwyn


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

I've just gone through and done a new install on a fresh DNN 6.1.2 setup, it worked fine. It may be worth investigating your datavase to see if you have any strange constraints or relationships on the Modules table that may be conflicting.

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
1/9/2012 12:52 PM
 
manu


Joined: 6/5/2008
Posts: 10

I tried it too on a fresh dnn 621 install and it works just fine. Unfortunately for my, the live site is on dnn602.

 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsDNN 6.0.2 with Events 5.2.1, Installation Failed DNN 6.0.2 with Events 5.2.1, Installation Failed


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