Lemmy Support

4660 readers

24 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago

MODERATORS

dessalines@lemmy.ml

E-Mail verification on, captcha on, hunker down (lemmyfi.com)

submitted 1 year ago by RGB@lemmyfi.com to c/lemmy_support@lemmy.ml

5 comments fedilink hide all child comments

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.

you are viewing a single comment's thread
view the rest of the comments

[–] RGB@lemmyfi.com 0 points 1 year ago (1 children)

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 1 points 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!