I tried to copy some posts, but it looks like it is totally screwed up, now. Even higher ids show wrong content on some Mastodon instances, even if I am sure I only did a few tests with posts.

Only way to solve this (imho) is to reinstall Lemmy BUT use another subdomain.

What do you think? Will this work?

Thanks a lot for the solution, but it looks very complicated and I am afraid I can break something, like I did before and then I had to reinstall Lemmy, which led to even more issues.

But I found some additions to this problem, because some people got problems with bots.

What a big no-go, if you could lock out yourself as an admin.

That’s such a sloppy craftsmanship.

The problem if you deactivate federation is, that people think, they can post with their Mastodon account, but it fails.

But another problem is, that if you deactivate federation, all the federated content stays in the “all feed” and people might still post there. And federated communities show up to after deactivation. This is sloppy craftsmanship, again, and I could cry, if I see stuff like this, or did I just missed how to get rid of federated content after deactivating federation?

I tried to install lemmyBB, but the README is pretty broken and I couldn’t even find someone, who has this front-end running. I already opened an issue on github and it looks like lemmyBB only works with an older version of lemmy :/

Maybe I just copy my first posts, which got ghost data federated (from older installations), so the posts get a new id and people are able to post comments again (which can be seen by me). So at least one problem will be solved.

That sounds complicated and I am afraid something could break (again). The last days I tried to fix something in the db, which led to other problems.

Discourse

Not really a fan of Discourse. It has a lot of nonsense implemented, like a lot of achievements, which pollute the notifications and distracts from what you want to do. I find it as distracting, as the “all feed” of Lemmy, which shows everything a user of your instance touched, which is a weird concept imho.

Do you know a good programmed forum software? Because one of the reasons I chose Lemmy was, that it was content based, like a classical forum and that’s what I need.

But the second thing what I need is, to be able to access the posts/comments via an API, like REST to process them.

I am at a point where I will throw away the work of the last 3 weeks to get some useful software, because it looks like Lemmy will just create unnecessary work, which could have been avoided, if it would have been clean programmed.

I already checked phpBB, it doesn’t have a REST API :/

Sorry about my last post. After reading it again, it sounded rude.

Sorry! I am a little bit stressed right now, because I was working the last 2-3 weeks to set up a Lemmy instance, working every day on it and one issue after another appeared and now it even looks like that comments don’t even reach me, because they land in the void because of the reinstall problem.

I could cry!

Might it be a good idea to to just copy the post so it gets a higher ID, which wasn’t used before? Because the productive system is already running and has a lot of content and a new reinstall might even block more IDs.

At this point it sounds like you don’t know how federation work, otherwise you wouldn’t have different accounts.

What exactly was the issue with your verification system?

Currently the emails get out. At least I can see people creating accounts and posting stuff.

but if the user has any posts

They are unverified, they can’t have posts.

If the user has no posts you may need to delete from the database directly for now.

Do you know by any chance how to do this in a clean way, because I tried and there have been restovers.

Like normal people! :D

Go to another instance, if you find something interesting, copy the link and paste it to the search field of your instance. After that federation starts and you can post.

There must be at least one person doing this, because otherwise ALL wouldn’t contain anything from other instances.

But it’s a little bit sad, that you’ve never done this and only look at all. It means you watch only stuff other people on your instance have seen but you don’t get further.

Yes, that’s exactly what I described with the issue, that a lot of other features will be deactivated too, because there is only one button for everything.

But if you know it: How exactly do I deactivate the “All Feed” to not pollute my server and avoid distractions to the users, but let them comment on external posts, without having the complete post on my instance and let external people comment on posts on my instance?

Thanks for your help.

Well, it is playing around with the db 😀 … and it could even destroy the whole instance if people don’t see the warning I’ve posted there.

I found a solution here

A warning to people who have the same problem:

On the website there is a command, which will purge all unverified account. If your admin account wasn’t verified, it will be purged, too.

Thanks a lot for your help :)

I found a solution here

A warning to people who have the same problem:

On the website there is a command, which will purge all unverified account. If your admin account wasn’t verified, it will be purged, too.

Thanks a lot for your help :)

psql -U postgres

No luck with this comman :(

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "postgres" does not exist

But is it the right docker container? The name of the container I try to connect is lemmymydomaintld_postgres_1

Seems pretty hard to delete a user this way. Do you know an easier way by any chance?

How exactly? The recommendations of other people here didn’t work.

EDIT: Found a solution. Check other posts to see how it works.

After executing docker exec -it lemmymydomain_postgres_1 psql

I’ve got the error:

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist