# Review queue filled with "pending" users not clearing after disabling "must approve users" site setting

**URL:** https://meta.discourse.org/t/review-queue-filled-with-pending-users-not-clearing-after-disabling-must-approve-users-site-setting/116641
**Category:** Support
**Created:** [May 2, 2019, 3:41am UTC](https://meta.discourse.org/t/review-queue-filled-with-pending-users-not-clearing-after-disabling-must-approve-users-site-setting/116641 "2019-05-02T03:41:04Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![\_andy](https://avatars.discourse-cdn.com/v4/letter/_/6f9a4e/32.png) [@\_andy](https://meta.discourse.org/u/_andy)
#### Post date: [May 2, 2019, 3:41am UTC](https://meta.discourse.org/t/review-queue-filled-with-pending-users-not-clearing-after-disabling-must-approve-users-site-setting/116641/1 "2019-05-02T03:41:04Z")

</div>

On v2.3.0.beta9 +10

I have about 12,000 items waiting in the review queue, all of which are users from a vbulletin import. When the data was imported about a month ago the review queue didn’t exist as discourse was a few versions behind.

Between importing and upgrading versions, `must approve users` in the site settings was enabled for testing the platform internally with my team. Eventually we turned this setting off before reopening to the public.

**Problem:** I have 12,000 imported users who “need review” when disabling the site setting should have dequeued them. Is there any way I can clear the queue en masse without having to redundantly approve them by hand?

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [May 2, 2019, 4:49am UTC](https://meta.discourse.org/t/review-queue-filled-with-pending-users-not-clearing-after-disabling-must-approve-users-site-setting/116641/2 "2019-05-02T04:49:03Z")

</div>

I believe @eviltrout can advise you on this.

---

<div class="post-metadata">

### Author: ![eviltrout](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/eviltrout/32/5275_2.png) [@eviltrout](https://meta.discourse.org/u/eviltrout)
#### Post date: [May 2, 2019, 3:25pm UTC](https://meta.discourse.org/t/review-queue-filled-with-pending-users-not-clearing-after-disabling-must-approve-users-site-setting/116641/3 "2019-05-02T15:25:46Z")

</div>

It depends if you want to keep the history around of the reviewable or not.

The nuclear option if you don’t care about history is to open a rails console and do this:

```ruby
ReviewableUser.pending.delete_all

```

If you want to approve them you can do this:

```ruby
ReviewableUser.pending.each { |r| r.perform(Discourse.system_user, :approve_user) }

```

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [June 1, 2019, 3:29pm UTC](https://meta.discourse.org/t/review-queue-filled-with-pending-users-not-clearing-after-disabling-must-approve-users-site-setting/116641/4 "2019-06-01T15:29:27Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.