Approval button on user's profile doesn't work

Contribute Bug
5

I think the problem might be that the user has been reviewed before. I am not sure it’s possible to review the same user again. So far I haven’t been able to reproduce this.

I still wasn’t able to reproduce this. But I found out that the user who doesn’t appear in the review queue had been flagged as suspect_user after they signed up in December. At that time must_approve_users was disabled on my forum. So I acted on them back then. I am not sure if disagreed means I selected to keep the user. But when I tried to reproduce now the only other option was to delete the user. Not sure how status = 2 happened.
When I enabled must_approve_users a few weeks ago, the user was not automatically approved because there was a reviewable with the user_id as the target_id. That makes sense.

But I still have no clue how I ended up with a user I didn’t approve, but also didn’t delete when they were flagged.

reviewable status status reason context created_at
264 disagreed 2 suspect_user NULL 2025-12-18T14:16:28.322Z
query 
SELECT
    rs.reviewable_id,
    CASE
      WHEN rs.status = 0 THEN 'pending'
      WHEN rs.status = 1 THEN 'agreed'
      WHEN rs.status = 2 THEN 'disagreed'
      WHEN rs.status = 3 THEN 'ignored'
    END as status,
    rs.status as status_id,
    rs.reason,
    rs.context,
    rs.created_at
FROM reviewable_scores rs
JOIN reviewables r
ON rs.reviewable_id = r.id
JOIN users u
ON r.target_id = u.id
WHERE u.approved = false
AND u.active = true
1 Like