this post was submitted on 19 Jun 2023
3 points (100.0% liked)
Lemmy Support
4652 readers
1 users here now
Support / questions about Lemmy.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
My modlog got spammed today by some script banning a lot of people for spam automatically. It's getting wild. This was inevitable with the growth of Lemmy as a platform though.
Mine too I see now. You can only ban a user when they have posted something right ? There is no list for admins of all users registered ? Maybe I'll do it direct in the database..
Just did that for my instance. Luckily it's fairly easy. Since there were no human registrations after those bots I just looked up the lowest bot id in the
local_user
table which was9
and then useddelete from person where id in (select person_id from local_user where id >= 9);
. Thanks to the references and triggers on the table, the rest of the database was also cleaned up by that, including thelocal_user
table.For me it were the last 30 or something entries in local_user. They all didn’t have email_verified. I access the db through Postico. Also removed all other older accounts that didn’t verify their email address