this post was submitted on 20 Jun 2023
68 points (98.6% liked)
Lemmy
12557 readers
2 users here now
Everything about Lemmy; bugs, gripes, praises, and advocacy.
For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.
founded 4 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Thank you for proactively contacting me regarding this @sunaurus@lemm.ee. I've had this issue on my https://feddi.no instance, but I have added a captcha and registration applications now. Hopefully it will alleviate some of the problem.
All of the bots accounts seems to have a number in their email so I manually looked through the list of users in
email_verification
that contained numbers in the email to look for false positives:select * from email_verification where email ~ '[0-9]+';
before running
delete from local_user where id in (select local_user_id from email_verification);
to delete the users.
By suggestion from @sunaurus@lemm.ee I updated
site_aggregates
to reflect the new users count on the instance:UPDATE site_aggregates SET users = (SELECT count(*) FROM local_user) WHERE site_id = 1;
.