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
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade errorUpgrade error
Previous
 
Next
New Post
4/30/2010 3:15 AM
 
Goran Ivanić

Joined: 9/22/2004
Posts: 70

I have upgrade from

05.03.01 to 05.04.01

and i have recieve error at 05.04.00 database upgrade  :

System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_PortalLocalization_Portals". The conflict occurred in database "mydb", table "dbo.Portals", column 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



/* Add Foreign Key to PortalLocalization Table */
/***********************************************/

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'FK_PortalLocalization_Portals') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
BEGIN
/* add key and cascade delete rule */
ALTER TABLE dbo.PortalLocalization
ADD CONSTRAINT FK_PortalLocalization_Portals
FOREIGN KEY ( PortalID ) REFERENCES dbo.Portals ( PortalID ) ON DELETE CASCADE
END

Upgrade was ended and site is working ok, but with this error !?!?
 
New Post
5/3/2010 11:19 PM
 
ShaneN

Joined: 1/9/2008
Posts: 98
It appears that this foreign key modification has been put in to cascade portal deletes to the PortalLocalization table and for referential integrity I had that error because PortalLocalization was still holding references to portals I already deleted which don't get deleted because this reference doesn't exist :-) so if you check your PortalLocalization table and delete out any portals in there that are being referenced that don't exist in your Portals table and than run IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'FK_PortalLocalization_Portals') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1) BEGIN /* add key and cascade delete rule */ ALTER TABLE dbo.PortalLocalization ADD CONSTRAINT FK_PortalLocalization_Portals FOREIGN KEY ( PortalID ) REFERENCES dbo.Portals ( PortalID ) ON DELETE CASCADE END again than you shouldn't have any problems and the referential integrity of stuff should be super
 
New Post
6/21/2010 9:03 AM
 
Timo Breumelhof


Timo Breumelhof's Avatar

www.40fingers.net
Joined: 2/9/2006
Posts: 4430
This will show you all portals to be removed from the PortalLocalization table

SELECT     PortalLocalization.PortalID, PortalLocalization.portalname
       from               PortalLocalization where
PortalLocalization.PortalID not in(select portalid from portals)
 
New Post
6/22/2010 2:25 AM
 
COSMOS4U

Joined: 1/16/2010
Posts: 3
I remove all the rows from PortalLocalization that this Select returns, but after the upgrade only 4 of the 22 portals are available. The PortalLocalization table and the portals tables have rows.... but for some reason the portals disappear from the Host->Portals. Also I see that the table PortalLocalization has not a Primary Key. When I try to add one, with the SQL Server Management Studio and try to go to Host->Portal an error apears. I think that I must remove some others rows too... not only these from the Select... Any ideas?
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Upgrade errorUpgrade error


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