Lemmy @lemmy.ml Baron Von J @lemmy.ml 1y ago

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

Discover the magic of the internet at Imgur, a community powered entertainment destination. Lift your spirits with funny jokes, trending memes, entertaining gifs, inspiring stories, viral videos, and so much more from users like baronvonj.

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?

8 comments

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.
- thanks, that appears to have worked.
Also, as a mod, how can I see who are the subscribers to the community?
- 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.
  
  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.

8 comments