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
    link
    fedilink
    English
    511 months 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.

    • @baronvonjOP
      link
      English
      411 months 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.

      • Beto
        link
        fedilink
        English
        311 months ago

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

        • @baronvonjOP
          link
          English
          411 months ago

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

          • PTZ
            link
            fedilink
            English
            411 months ago

            I found this post, and it was useful.