Thanks a lot for this really good tutorial.
I was trying for a long time to connect to the database, but because I use docker the first time, I didn’t know how?
But there is a little thing that could destroy the whole Lemmy instance.
The very first command, which deletes all users without a verified email, could delete the admin account, too, because the really first user, which gets created on a freshly installed instance doesn’t need a verification.
To avoid this, I’ve set the flag of the account, which had my email address in it to ‘t’. Attention! The very first admin account doesn’t have person_id 1. In my case it was 2 (and I don’t even know why?):
UPDATE local_user SET email_verified='t' WHERE person_id=2
After that I could execute the purge command without problems:
DELETE FROM local_user WHERE email_verified = 'f';
Request for other tutorials
I am not a fan of ghost data or clutter my server with junk data and try to keep it as tidy as possible, but lemmy is a little bit messy if it’s about this.
After I set up an instance, I tried all functionality believing I can easily remove everything (that would be the intuitive way), but that wasn’t the case.
Now I have useless posts and comments, I can’t purge from my instance. I only could delete them as a user, but now I see them with a red trash bin beside the post title or with the comment “deleted by user”.
A tutorial on how to purge deleted posts and comments would be very useful. I don’t even know where posts are saved. Taking a look into the table “post” shows a lot of posts of other people, but I can’t find them on my instance (I am currently the only one posting on my instance). What exactly is going on there? And is it save to delete those, too? Any way to avoid it in the future or is this somehow important?
And there is another problem!
After I’ve created testaccounts and purged them with the command above, I tried to register with the same name, but the website said:
user_already_existsSo the users haven’t been purged correctly.
I tried to restart all docker containers, but nothing changed, the user still exists.