I have a registered user that was originally approved, has a mask of member, shows up on the member list and shows up when I do an admin user search for member.

However I can not delete him.

I can edit his profile. I can even change his password. I can not edit his email.

However, everytime I try to delete him from the data base

I get the forum error page.

I have not had this problem with other users.

Any thoughts?

thanks

mike

when I try to delete him.

And he is still there. The dude will

not die.

Mike

6/10/2008 7:08 PM in .Net SqlClient Data Provider

The DELETE statement conflicted with the REFERENCE constraint "FK_yaf_UserPMessage_yaf_PMessage". The conflict occurred in database "sto0815907213127", table "dbo.yaf_UserPMessage", column 'PMessageID'.

The DELETE statement conflicted with the REFERENCE constraint "FK_yaf_PMessage_yaf_User1". The conflict occurred in database "sto0815907213127", table "dbo.yaf_PMessage", column 'FromUserID'.

The statement has been terminated.

The statement has been terminated.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at yaf.DB.ExecuteNonQuery(SqlCommand cmd)

at yaf.DB.user_delete(Object UserID)

at yaf.pages.admin.users.UserList_ItemCommand(Object source, RepeaterCommandEventArgs e)

at System.Web.UI.WebControls.Repeater.OnItemCommand(RepeaterCommandEventArgs e)

at System.Web.UI.WebControls.Repeater.OnBubbleEvent(Object sender, EventArgs e)

at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)

at System.Web.UI.WebControls.RepeaterItem.OnBubbleEvent(Object source, EventArgs e)

at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)

at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)

at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)

at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

-----------------------------

upgrade without stepping on the database? I am using the godaddy version.

Thanks,

Mike