This project is read-only.

deleting and editing user details

Feb 22, 2010 at 1:40 AM

hi

i am trying to delete certain user who is no more working under us and editing other user details such as email address and all slickticket does not let me do it is there a way out there that can help me to do that. while deleting i recieve this error

 

Error deleting
The delete statement conflicted with the reference constraint "fk__tickets__submitt__1367e606". the conflict occurred in database "slickticket", table "dbo.tickets", column 'submitter'. the statement has been terminated.
i am thinking that it might be ticket that these user has been log in and already fix and close but that shouldn't stop me of deleting them though

Feb 22, 2010 at 8:15 AM

That is because it would break a relation in the table.  Just because he is gone doesn't mean that all his tickets and information should be gone, it would break the integrity of the database.  If you really want to delete him, you would need to change all references for him in the DB to someone else so he is not referenced anywhere, then you can delete him.