1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Partial Fix [XF 1.4 B3] Can't Delete Orphaned Profile Posts

Discussion in 'Resolved Bug Reports' started by Kevin, Aug 24, 2014.

  1. Kevin

    Kevin Well-Known Member

    I installed XF 1.4 B3 tonight to one of my sites and realized that the /find-new/profile-posts was a great way of exposing some old spam accounts that I had not come across before (account was created, they post spam to their own profile posts, never come back again). Cleaning up the spam accounts was mostly easy but I ran into one issue: If the account had already been previously deleted, some had profile posts that still existed and were showing up on /find-new/profile-posts but I can't delete them.

    Since the account doesn't exist I can't use the 'spam' link on them. When I try the 'delete' link I get the generic "The requested member could not be found." error. When I try to select them in bulk and then delete the selected posts I get an unhandled error.

  2. Mike

    Mike XenForo Developer Staff Member

    Are these messages really old? Messages posted on a particular user's profile (status updates being on their own profile) are removed when the user is deleted so the profile post should have been removed.

    I'm not sure why you can even see this post as I would have expected the view check to fail, though I suppose the join would have still run -- this is the part I'll probably change.
  3. Kevin

    Kevin Well-Known Member

    Mike, yes, they are pretty old with the first that I see in the list going back to Jan 2013.

    If they were excluded from showing up on the new sidebar and /find-new/profile-posts, because the user account doesn't exist, then, even if I have to run a query manually to purge the orphaned posts, it'd be great since then the spam posts won't show to the visitors.
  4. Mike

    Mike XenForo Developer Staff Member

    Must have been an issue in a previous version that didn't remove them. They will no longer appear now.
    Kevin likes this.
  5. Kevin

    Kevin Well-Known Member

    Mike, the query change for 1.4 RC1 takes care of it, thanks. I'll manually purge them from DB.

Share This Page