# Why this user keeps showing in review tab without accepted button?

**URL:** https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845
**Category:** Support
**Created:** [7월 2, 2019, 12:52오전 UTC](https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845 "2019-07-02T00:52:15Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Phuong\_SuSu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/phuong_susu/32/148042_2.png) [@Phuong\_SuSu](https://meta.discourse.org/u/Phuong_SuSu)
#### Post date: [7월 2, 2019, 12:52오전 UTC](https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845/1 "2019-07-02T00:52:15Z")

</div>

Hello,

A user may register while I switching approval options in admin settings.  
Now I get a funny situation 🙂

Her account was actived, the system shows that she was also approved by (noone)  
then her account keeps showing in the review tab with only… a delete account button.  
And in the review notifications menu, I always got (1) there…

 ![35%20AM](https://global.discourse-cdn.com/meta/original/3X/3/4/343ca85770fb067d0f3c58eb673a7afd6f97ed2f.png) ![00%20AM](https://global.discourse-cdn.com/meta/original/3X/6/b/6b2aba66f7e7dd767f0851c2dcf701cdba6a8a99.png)

What should I do ???

---

<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: [7월 2, 2019, 7:23오후 UTC](https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845/2 "2019-07-02T19:23:56Z")

</div>

Could you temporarily enable `must_approve_users`, approve them, then disable it again?

---

<div class="post-metadata">

### Author: ![Phuong\_SuSu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/phuong_susu/32/148042_2.png) [@Phuong\_SuSu](https://meta.discourse.org/u/Phuong_SuSu)
#### Post date: [7월 2, 2019, 7:37오후 UTC](https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845/3 "2019-07-02T19:37:06Z")

</div>

I enable or disable the that mode many times, the result is the same, no “approve” button could be found (although other users are normal, except this user)  
I think I need to update in the database somewhere, do you have any suggestion?

---

<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: [7월 3, 2019, 3:47오후 UTC](https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845/4 "2019-07-03T15:47:14Z")

</div>

Ah I think I understand the problem now. The user was created, but the associated reviewable record was not marked as approved.

To fix this you will need the id of the reviewable item. You can get this by clicking on the date on the reviewable item, and the url will look like `/review/1234` - `1234` is the number you want.

Then you can open a rails console:

`rails c`

And type this:

`Reviewable.find(1234).update_column(:status, 1)`

If you find accessing the database easier, the query would be this:

`UPDATE reviewables SET status = 1 WHERE id = 1234`

---

<div class="post-metadata">

### Author: ![Phuong\_SuSu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/phuong_susu/32/148042_2.png) [@Phuong\_SuSu](https://meta.discourse.org/u/Phuong_SuSu)
#### Post date: [7월 3, 2019, 4:49오후 UTC](https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845/5 "2019-07-03T16:49:33Z")

</div>

You are the hero!  
I opened a rails console and enter the first command, the problem is gone 😃

 ![28%20PM](https://global.discourse-cdn.com/meta/original/3X/8/4/8409f34995a5070d19cbf4b2cc02179f7e5a62fb.png)

A quick question, how to accessing database like the second command?  
I used the “[Data Explorer](https://meta.discourse.org/t/32566?silent=true) Plugin” but it seemed just query the database, cannot update it.

I’m new to Discourse ^^!

---

<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: [7월 3, 2019, 4:51오후 UTC](https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845/6 "2019-07-03T16:51:54Z")

</div>

It depends how you’ve installed discourse, but you can do `rails dbconsole` in the docker container and it should connect you to the database.

---

<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: [8월 2, 2019, 4:52오후 UTC](https://meta.discourse.org/t/why-this-user-keeps-showing-in-review-tab-without-accepted-button/121845/7 "2019-08-02T16:52:07Z")

</div>

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