Link to home
Start Free TrialLog in
Avatar of benharel
benharel

asked on

SQL Delete error in Dotnetnuke

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.
Avatar of rmm2001
rmm2001
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of rbgCODE
rbgCODE
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial