Posted by: mchase1 - Tuesday, 10 June 2008 11:50:48

I am using YAF 1.9.1.7 on godaddy. 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

Posted by: Jaben - Tuesday, 10 June 2008 16:03:55
Try again now.

Posted by: mchase1 - Tuesday, 10 June 2008 18:11:00
no, I still get the forum error message when I try to delete him. And he is still there. The dude will not die. Mike

Posted by: Jaben - Tuesday, 10 June 2008 21:07:23
Take a look in the Admin->Event Log for the error -- copy and paste the details of the error here.

Posted by: mchase1 - Tuesday, 10 June 2008 22:21:59

Here you go 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) -----------------------------

Posted by: Jaben - Wednesday, 11 June 2008 02:21:44
Consider an upgrade to v1.9.1.8.

Posted by: mchase1 - Wednesday, 11 June 2008 08:45:08
Same question I had in a previous post. Are there instructions for doing the upgrade without stepping on the database? I am using the godaddy version. Thanks, Mike

Posted by: Jaben - Wednesday, 11 June 2008 16:10:16
What do you mean "without stepping on the database"? The new version supports upgrading of course.