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?

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.

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.

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

docker exec -it postgres bash

After executing this command and executing psql, I got this error:

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

omg... why would you work for a company like this? Working with shitty technology all day could lead to depression.

Always those pathetic people overwhelmed by their own lives...

I am European, so that's a spoiler: It's Atlantica

It says "Is Donald Trump the sixth monster" and I think they are referring to dictators on this planet or something similar.

I don't get it! Are people too stupid to write an email nowadays?