How to delete user?

Hi all,

I am trying to delete user.Then following error occurs.Please guide me what to do to remove this erro and to delete user successfully.

The DELETE statement conflicted with the REFERENCE constraint "FK_umbracoUser2app_umbracoUser". The conflict occurred in database "UmbracoCMS", table "dbo.umbracoUser2app", column 'user'.<br>The statement has been terminated. body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

Server Error in '/' Application.

The DELETE statement conflicted with the REFERENCE constraint "FK_umbracoUser2app_umbracoUser". The conflict occurred in database "UmbracoCMS", table "dbo.umbracoUser2app", column 'user'.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_umbracoUser2app_umbracoUser". The conflict occurred in database "UmbracoCMS", table "dbo.umbracoUser2app", column 'user'.
The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the 
current web request. Information regarding the origin and location of the 
exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_umbracoUser2app_umbracoUser". The conflict occurred in database "UmbracoCMS", table "dbo.umbracoUser2app", column 'user'.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857546
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735158
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +106
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) +21
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +53

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +137
   umbraco.BusinessLogic.User.delete() +121
   Createuser.Page_Load(Object sender, EventArgs e) +52
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Copy Link

skiltz 501 posts 701 karma points

Dec 26, 2009 @ 10:15

Go into the user in the control panel and untick all the "sections" the user has access to. I presume there is something in there that is not standard umbraco stuff. i.e a custom section

Copy Link

is working on a reply...

Flag this post as spam?

How to delete user?

Server Error in '/' Application.

The DELETE statement conflicted with the REFERENCE constraint "FK_umbracoUser2app_umbracoUser". The conflict occurred in database "UmbracoCMS", table "dbo.umbracoUser2app", column 'user'.The statement has been terminated.

The DELETE statement conflicted with the REFERENCE constraint "FK_umbracoUser2app_umbracoUser". The conflict occurred in database "UmbracoCMS", table "dbo.umbracoUser2app", column 'user'.
The statement has been terminated.