No matter how many users are in the review queue, if there are any users in the queue, I get a message that always (yes always) says there are either 136 users or 137 users in the queue. Every. Single. Time. How do we fix this? [Selection_2023] [Selection_2024]

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: [image] Notification claims X users for approval, but none are found Bug 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".… [image] Two users waiting for approval but not in RQ- where are they? Bug 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]

Thanks for those pointers @Moin. With this SELECT "users".* FROM "users" WHERE (suspended_till IS NULL OR suspended_till <= '2023-11-13 11:05:23.225614') AND "users"."approved" = FALSE AND "users"."active" = TRUE ORDER BY users.created_at DESC,users.username I get 135 records. Choosing the oldest one somewhat at random, samirbehara, I come to this user, who has public activity. On the admin side of his account, I have the option to “Approve”, but I don’t understand why. [Selection_2025]

As I just told my dear colleague @ganncamp over Slack, I turned off these notifications on our instance this morning. [The image shows a text-based interface with a blank space for inputting a question or message. (Captioned by AI)] They really didn’t serve us any purpose. And still, it’s weird that it showed us so many (130+) when the review queue was so clearly not at that count.

I haven’t paid particularly close attention here, so I may be off base. [image] G Ann Campbell: On the admin side of his account, I have the option to “Approve”, but I don’t understand why. I think that they joined and you subsequently turned on “must approve users”. They had already joined and been a user who could post, but then you later required approval, which you have not given. I think your options are to approve or delete all 135 of them either in the UX or in Rails.

[image] Jay Pfaffman: I think that they joined and you subsequently turned on “must approve users”. Doesn’t that end up bulk approving the existing users? [image]Invite-registrations for existing users? When you enable must approve users, all existing users are approved automatically. discourse/config/initializers/014-track-setting-changes.rb at a564274ba277a834b8a3ab4c28b2c1022fd9521e · discourse/discourse · GitHub Maybe it works to temporarily enable that to use the automation to approve your users.

That seems a bit odd, since (if I can SQL properly) ours seem to have User as some of their target types? SELECT users.id as user_id, approved, target_type, target_id FROM users INNER JOIN reviewables ON users.id=reviewables.target_id WHERE approved = false ORDER BY user_id userid approved target_type target 39 false User 39 127 false Post 127 276 false Post 276 278 false Post 278 328 false User 328

[image] Firepup Sixfifty: Doesn’t that end up bulk approving the existing users? Isn’t this topic about the fact that it didn’t?

That’s on me, I skimmed a tad too much and missed that entirely I guess.

"136 / 137 user waiting for approval"

Product Support

Moin September 17, 2024, 10:37pm 7

Usually yes. But there is a bug, so for some users that doesn’t work.

Topic		Replies	Views
Two users waiting for approval but not in RQ- where are they? Bug	4	581	September 23, 2025
Notification claims X users for approval, but none are found Bug	25	1435	May 31, 2026
"must approve users" notifications are incorrectly triggered by old users Bug	3	783	April 20, 2024
Approval button on user's profile doesn't work Bug	11	573	September 1, 2026
System permanently thinks there are user approvals outstanding Product Support	2	174	May 25, 2026

"136 / 137 user waiting for approval"

Related topics