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.