Just deleted over 800 users from my database that joined in the last few hours from obviously fake emails and botted usernames. Make sure to either close registration or have some sort of safety check in place because things are getting hairy out here.

  • RGB@lemmyfi.comOP
    link
    fedilink
    English
    arrow-up
    2
    ·
    1 year ago

    You have to delete them from local_users and person tables. Be careful with person table to not delete entries from users outside your Instance. It worked for me and fixed the user count in my sidebar.

    • kev@mcr.town
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 year ago

      Cool. I think I’m going to give it a few days in case I deleted someone I didn’t want to. If I hear no complaints (I’m pretty sure I’m the only real local user on my instance anyway 😂) I’ll delete out the db. Thanks!

      • RGB@lemmyfi.comOP
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

        No problem! Hopefully others that had this problem can fix their instance too. Since we don’t know when the spam accounts will become active and start posting or if that spam attack was just to mess with us.