mchase1
  • Posts: 9
  • Joined: 09/06/2008
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
  • Posts: 2544
  • Joined: 09/10/2004
Try again now.
mchase1
  • Posts: 9
  • Joined: 09/06/2008
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
  • Posts: 2544
  • Joined: 09/10/2004
Take a look in the Admin->Event Log for the error -- copy and paste the details of the error here.
mchase1
  • Posts: 9
  • Joined: 09/06/2008
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
  • Posts: 2544
  • Joined: 09/10/2004
Consider an upgrade to v1.9.1.8.
mchase1
  • Posts: 9
  • Joined: 09/06/2008
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
  • Posts: 2544
  • Joined: 09/10/2004
What do you mean "without stepping on the database"? The new version supports upgrading of course.
Users browsing this topic
  •  guest
Forum Jump  
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.

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