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

delete users

Discussion in 'Installation, Upgrade, and Import Support' started by JackieeXP, Aug 29, 2012.

  1. JackieeXP

    JackieeXP Member

    how do i delete all users or select more then 1 at a time? i have like 400 fake users
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    If they are in the moderation queue then you can use this:


    Otherwise there is no mass pruning feature for users.

    You can put users into moderation for bulk processing with a query like this:

    UPDATE xf_user
    SET user_state = 'moderated'
    WHERE user_id > 100;
    In the above query it moves all users greater than user_id 100. That would setup all of those newest users for deletion in the moderation queue.
    borbole likes this.
  3. fronix

    fronix Member

    I'm curious why there is no feature like that, I'm right now having that problem however it's with all my users. I'm setting up an old database but I don't want all the users only the settings now importing it didn't work at all so only solution was to import the old and delete the users. Now the problem here is that I have over 12 000 users in this database..
  4. c5mt

    c5mt Member

    Not sure if i am too late to reply
    instead of a query i think its better to use batch update admin.php?users/batch-update
    move a whole user group to another or delete all users within specific user group
  5. rainmotorsports

    rainmotorsports Well-Known Member

    You are only late by 2 years lol. Features that didn't exist back then.
  6. c5mt

    c5mt Member

    LOL googled and came here as i needed to delete users and there is still no way to mass select on any page
    however all users can be deleted from batch update this is how i done

Share This Page