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?

  • poVoq
    link
    fedilink
    English
    810 months ago

    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.

    • @baronvonjOP
      link
      English
      410 months ago

      thanks, that appears to have worked.

  • @baronvonjOP
    link
    English
    510 months ago

    Also, as a mod, how can I see who are the subscribers to the community?

    • Beto
      link
      fedilink
      English
      510 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
        410 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
          310 months ago

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

          • @baronvonjOP
            link
            English
            410 months ago

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

            • PTZ
              link
              fedilink
              English
              410 months ago

              I found this post, and it was useful.