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

Delete User and his Posts

Discussion in 'Troubleshooting and Problems' started by 007, Sep 24, 2011.

  1. 007

    007 Member

    Hi,

    Please help me on this issue.

    I have a user which asks for a complete deletion and wipe out of his account and posts.

    I do not find an option for "mass-delete".
    The only way I can figure out is to delete annual post after post after post.

    Thx for your ideas!

    Thorsten
     
    erich37 likes this.
  2. Mikey

    Mikey Well-Known Member

    I suppose you could run an SQL query (in phpmyadmin) to delete all posts by that userid in the database, but that would most likely affect caches and stuff would need to be rebuilt.

    So.. before using this query I would wait to see if someone responds with a better answer.. (note.. i haven't even looked in the xenforo ACP for an answer)

    Code:
    DELETE * FROM xf_post WHERE user_id = 'CHANGEME'
    again.. please take a backup before doing this.. and also be VERY careful when performing queries on the database. One typo and you could erase the whole post table, not good.
     
  3. Brogan

    Brogan XenForo Moderator Staff Member

    An easier way to do it is to temporarily remove the criteria from the Spam Cleaner and run it against them.
    You can then delete the user via the ACP.

    Be aware though that any posted content and Likes will remain.
    There is no way to remove this.
    You can mitigate this somewhat by doing a username change and cache rebuild before deleting the user.

    Don't forget to reset the Spam Cleaner criteria.
     

Share This Page