As a community owner/mod, how do I approve a follow from a Mastodon user?

I created a community here, and then tried to follow it from my Mastodon account. On Mastodon it says the follow request is pending approval. But I don't see any way to approve it from here on lemmy.ml. Any suggestions?

7 points · 8 comments · view on lemmy.world

8 Comments

poVoq@slrpnk.net · 8 pts · 3y (1 reply)

I think that's somehow a bug. On Lemmy it also sometimes shows "pending subscription". Normally communities do not need approval and automatically allow all subscriptions.

Try cancelling the follow request and make a new one.

baronvonj@lemmy.ml · 4 pts · 3y

thanks, that appears to have worked.

baronvonj@lemmy.ml · 5 pts · 3y (5 replies)

Also, as a mod, how can I see who are the subscribers to the community?

beto@lemmy.studio · 5 pts · 3y (4 replies)

You can query your DB with something like:

$ docker exec -it lemmystudio_postgres_1 bash
# psql -U lemmy lemmy
lemmy=# SELECT person.actor_id, community.actor_id
FROM community_follower
JOIN person ON person_id = person.id
JOIN community ON community_id = community.id
ORDER BY person.actor_id;

This gives you the users and communities they're subscribed to.

baronvonj@lemmy.ml · 4 pts · 3y (3 replies)

Thanks, but I'm just a user here on lemmy.ml, so I don't have access to that. If it's not exposed in the UI at all I'll open an issue over in GitHub.

beto@lemmy.studio · 3 pts · 3y (2 replies)

Ah, I see! I thought you were an admin with access to the DB, sorry!

baronvonj@lemmy.ml · 4 pts · 3y (1 reply)

No worries, it was still a useful answer as an instance admin might find the post.

ptz@lemmy.ptznetwork.org · 4 pts · 3y

I found this post, and it was useful.