mchase1
  •  mchase1
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
2008-06-10T09:50:48Z
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
Sponsor
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2008-06-10T14:03:55Z
mchase1
  •  mchase1
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
2008-06-10T16:11:00Z
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
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2008-06-10T19:07:23Z
Take a look in the Admin->Event Log for the error -- copy and paste the details of the error here.
mchase1
  •  mchase1
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
2008-06-10T20:21:59Z
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)
-----------------------------
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2008-06-11T00:21:44Z
Consider an upgrade to v1.9.1.8.
mchase1
  •  mchase1
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
2008-06-11T06:45:08Z
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
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2008-06-11T14:10:16Z
What do you mean "without stepping on the database"? The new version supports upgrading of course.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved