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

XF 1.1 Permanent delete of all posts made by a user

Discussion in 'Troubleshooting and Problems' started by Floren, Apr 12, 2012.

  1. Floren

    Floren Well-Known Member

    I had recently a request from a user to delete all his posts. We are talking of 10,000 posts, the Spam Cleaner simply crashed. Even if I've set the InnoDB wait time to 600, I had to reboot the server in order to make it responsive.

    Can I just run few MySQL queries to delete the data from post and thread tables, then rebuilt the indices?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yes and no. There are many joined records in other tables that are hard to account for when running manual queries. You can end up with orphaned records in the database which isn't necessarily a problem, but it's not a clean solution.

    Ideally XenForo needs batch processing for tasks like this.
     
  3. Floris

    Floris Guest

    On topic: We run into this almost weekly. We resolved it with a plugin that does batching through xenforo, by putting a limit in the source code and run every 15 minutes to not stress the site.

    Off topic: I hate it that people sometimes do this. I usually put in my site that contributed content becomes our property and we do not remove it; to think twice before posting.
     
  4. RobParker

    RobParker Well-Known Member

    I agree with Floris, surely removing 10K posts is going to seriously mess up the threads he contributed to?

    A much better approach would be a policy one, where you don't have to agree to removing them.
     
  5. Floris

    Floris Guest

    Sometimes choosing to do that just to get rid of a user and repurpose your time to focus on something worth doing, versus ignoring the person and eventually showing up in small claims court to get your right, and invest money and time and effort .. The user will loose, in almost all cases (especially in Europe).
     
  6. dojo

    dojo Active Member

    @Floris: good tip. Have it in your rules that once they submit the content, they are not allowed to have it removed. I can't mess up my entire content just cause x, after 4 years (or whatever) since being an active member (and getting traffic to their site, since I allow links in signatures) decides to leave and slam the door. Had such an issue in 2004, learned my lesson :D
     
  7. Floris

    Floris Guest

    Don't forget to mention that since they're the author they're responsible for their posts. You don't want to be liable for their stupidity.
     
    Teddy Scott and dojo like this.

Share This Page