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
Solved

SQL Delete error in Dotnetnuke

Posted on 2010-08-16
2
310 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

791 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