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?

  • Beto@lemmy.studio
    link
    fedilink
    English
    arrow-up
    5
    ·
    1 year ago

    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.