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?

  • BetoA
    link
    English
    51 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.

    • Baron Von JOP
      link
      fedilink
      English
      41 year ago

      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.

      • BetoA
        link
        English
        31 year ago

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

        • Baron Von JOP
          link
          fedilink
          English
          41 year ago

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

          • PTZ
            link
            fedilink
            English
            41 year ago

            I found this post, and it was useful.