"136 / 137 user waiting for approval"

[Moin]

I get those messages too. When I enabled approval, not all existing users were automatically approved. ("must approve users" notifications are incorrectly triggered by old users - #4 by Moin). So I could find them with Data Explorer and approve them manually from their profile admin page. (But 136 are a lot for manual approval!)

There are also these bug reports:

Notification claims X users for approval, but none are found

I found this topic while searching before filing a bug report, so adding to it. TL;DR the query for the notification is wrong because it counts rejected users as well. Notification: 16 users waiting for approval, click the link, see only 2. The query used for the notification is this puts AdminUserIndexQuery.new(query: "pending", stats: false).find_users_query.to_sql SELECT "users".* FROM "users" WHERE (suspended_till IS NULL OR suspended_till <= '2023-11-13 11:05:23.225614') AND "users".…

Two users waiting for approval but not in RQ- where are they?

We use the same signup process for all new users, using Wordpress as the OAuth provider and requiring manual approval on Discourse. 99% of the time it works. But two users over the past weeks are hiding somewhere. Discourse sends notifications that they are pending approval, but there are not on the Review Queue, no matter how I filter. Discourse must know where they are, since it’s sending notifications. How can I find them? [image] [image]