Solved

SQL Delete error in Dotnetnuke

Posted on 2010-08-16
2
311 Views
Last Modified: 2013-11-19
critical error has occurred.
The DELETE statement conflicted with the REFERENCE constraint "FK_BK_StaffDirectory_PersonTitle_BK_StaffDirectory_Person". The conflict occurred in database "USR_BrooksKushman-DNN", table "dbo.BK_StaffDirectory_PersonTitle", column 'PersonId'. The statement has been terminated.
0
Comment
Question by:benharel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Expert Comment

by:rmm2001
ID: 33448666
Looks like what's happening is that you're trying to delete a row that has a key on it that other tables reference. My guess is that it's your StaffDirectory table. Delete the data out of there for your desired dataset first and then out of the BK_Staff_Directory_Personal_Title table
0
 
LVL 6

Accepted Solution

by:
rbgCODE earned 500 total points
ID: 33458770
You need to make sure that your deleted are running cascading so that if there is a parent child relationship that all child entries are deleted before the parent.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime is disastrous for companies and can lead to major hits on a brand, reputation, an…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question