this post was submitted on 19 Jun 2023
2 points (100.0% liked)

/0

1560 readers
1 users here now

Meta community. Discuss about this lemmy instance or lemmy in general.

Service Uptime view

founded 1 year ago
MODERATORS
 

If you create a community and you invite a mod from another instance, and that mod edits that community description, then that community's local url will break. By local url I mean the one where you go to https:instance.tld/c/community_name. The community will also not appear in "local communities".

However the "remote" url will work. This is the one which is formatted like https://instance.tld/c/community_name@instance.tld

You can currently (19/06/2023) see this effect in !piracy@lemmy.ml (See working version)

The fix is pretty simple, you just need to set the "local" field in your postgresql DB to true. It's a single command inside your postgresql

update community set local='t' where actor_id='https://instance.tld/c/community_name';

If you don't know how to enter your postgresql DB in docker, this is the command

docker exec -it <postgres-container-name> psql -U <db user> -d <db name>

So for example, if I wanted to fix https://lemmy.dbzer0.com/c/flashcarts, I would write:

update community set local='t' where actor_id='https://lemmy.dbzer0.com/c/flashcarts';

Obviously try to avoid remote mods editing community descriptions if you can help it.

you are viewing a single comment's thread
view the rest of the comments
[–] db0@lemmy.dbzer0.com 1 points 1 year ago (1 children)

Then it's like very difficult to find. I searched two different ways for it on github

[–] poVoq 1 points 1 year ago (1 children)
[–] obosob@feddit.uk 1 points 1 year ago