Feedback on the new Review Queue

I’ve just merged in the Review Queue that has been in development for the last few months. We’ve been running it on our servers for a while and it’s passed through the hands of several developers so it’s in a good place to start testing with those Discourse users who follow the tests-passed branch.

Here are the notes from the commit:

This is a large refactor that merges all types of reviewable items in core Discourse (Users, Queued Posts and Flags) into one consolidated review queue.

New Features

  • One convenient place to review all content
  • Reviewable items are scored behind the scenes and the highest priority items are shown first. Staff members and higher trust level users produce higher priority items.
  • You can filter the review queue by status, priority, reviewable type, category and user
  • The API for reviewables returns the list of actions that can be performed on an item, which means the front end application can be simpler and not duplicate all the logic.
  • Data structures are built to enable non-staff level moderation of items in the near future

Software Design Notes

The Reviewable model uses single table inheritance (STI), and each type of reviewable must declare a subclass, serializer and ember component. Three types currently exist: ReviewableQueuedPost, ReviewableUser and ReviewableFlaggedPost. Developers are encouraged to look at how other reviewable items are implemented and build their own.

Post Actions (such as flags) must now be created using the PostActionCreator service object. It has a much friendlier API now and returns a result object which will return the associated reviewable.

Backwards Compatibility

REST API is maintained with the old endpoints, however deprecation warnings are logged. Third party code that is pointed at the old APIs should be updated to the new review queue API. All of the Ember.js/front end code for the old user approval / flagging interface / queued posts is removed.

In a future release we will remove the old APIs and backwards compatibility.

Please use this topic for feedback and bug reports. I’ll try to address things as quickly as possible!


After upgrading from Discourse 2.3.0 beta 5 to beta 6 I now have 14 new notifications in the new /review page, all regarding users that need to be approved.
Those users are either user accounts we rejected weeks ago or banned users, though.
If I clikc on the “Reject” button I get an error message “Sorry, an error has occurred” (see picture below).

TLDR version, I have 14 notifications about already rejected/banned users and I cannot find a way to get rid of them :slight_smile:



could you look at /logs and see if you have any relevant error that could help us debug the failure please ?


So the error popping up is almost certainly that the users have posts so they can’t be deleted. I think I realise the bug in my migration now, where I was creating reviewables for users who were not approved. I think perhaps banning someone is setting them as unapproved, so they showed up again.

I’ll take a look and see how I can improve it.


Looks like we’re also missing a admin.flags.user_percentage.summary translation as a hover description on the percentage:


Aye! Here you go… This is what I see by clicking on one of the “Reject” buttons.

This is the Info text related to the first warning

create_errors_json called with unrecognized type: #<Reviewable::PerformResult:0x00007fd1d233e4a0 @status=:failed, @reviewable=#<ReviewableUser id: 15, type: "ReviewableUser", status: 0, created_by_id: -1, reviewable_by_moderator: true, reviewable_by_group_id: nil, claimed_by_id: nil, category_id: nil, topic_id: nil, score: 1.0, potential_spam: false, target_id: 2685, target_type: "User", target_created_by_id: nil, payload: nil, version: 5, latest_score: nil, created_at: "2016-09-27 19:25:30", updated_at: "2016-09-27 19:25:30">, @transition_to=nil>

and this is from the second one…

Uncaught [object Object]
Line: 9
Column: 11652
Window Location:

If you need the backtrace let me know (lots of text)


I believe this commit will fix the inability to reject users who have posts:


This fixes the missing translations. Good catch @featheredtoast because it made me realise those components were admin only at the same time, which I also fixed:


UX Comment

I thought I’d seen this complaint elsewhere, but I can’t find it. I just did a g+ import and there are 1300 users in the approval queue with entries like this:


From this it’s impossible to tell why the user needs approval, and worse, the only way to find out seems to be to select the username and do a search. Is there a reason not to have the username link to their profile? Or, better, provide something about the user to know what to do about it?

And also, I presume that “Reject” rejects the user and does Something Bad. How does one clear this and say that the user is OK?

Help! How do I fix this?

My inclination is to just remove them all from the approval queue. But I don’t know how to do that because in the user record I see:

 approved: true,
 approved_by_id: -1,
 approved_at: Fri, 29 Mar 2019 18:26:49 UTC +00:00,

So I guess this approval must be in some other table?

EDIT: This sounds a little like Needs Approval feature (Nothing to Approve) and SSO user unnecessary approval with 403 error.


@pfaffman can you help me track this down? You said you did an import, but was it before you ran database migrations? Was must_approve_users set to true?


I updated from the latest a few weeks ago to just now, site is not loading (the Oops message) and shows this in the logs a lot:

Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR:  relation "queued_posts" does not exist
LINE 8:                WHERE a.attrelid = '"queued_posts"'::regclass
:               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
                     c.collname, col_description(a.attrelid, a.attnum) AS comment
                FROM pg_attribute a
                LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
                LEFT JOIN pg_type t ON a.atttypid = t.oid
                LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
               WHERE a.attrelid = '"queued_posts"'::regclass
                 AND a.attnum > 0 AND NOT a.attisdropped
               ORDER BY a.attnum
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:110:in `async_exec'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:110:in `async_exec'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `block (2 levels) in query'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `block in permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `yield_shares'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `permit_concurrent_loads'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `block in query'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `block (2 levels) in log'
/usr/local/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `block in log'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `instrument'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `log'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `query'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `column_definitions'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `columns'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `columns'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `columns_hash'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `load_schema!'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `load_schema!'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `load_schema!'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `block in load_schema'
/usr/local/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `load_schema'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `attribute_types'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `type_for_attribute'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `type'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `build'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `block in expand_from_hash'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `each'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `flat_map'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `expand_from_hash'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `build_from_hash'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `build'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `where!'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `where'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `where'
/var/www/discourse/app/models/queued_post.rb:39:in `new_posts'
/var/www/discourse/app/models/queued_post.rb:43:in `new_count'
/var/www/discourse/app/serializers/current_user_serializer.rb:192:in `post_queue_new_count'
(eval):34:in `_fast_attributes'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/active_model_serializers-0.8.4/lib/active_model/serializer.rb:456:in `attributes'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/active_model_serializers-0.8.4/lib/active_model/serializer.rb:480:in `_serializable_hash'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/active_model_serializers-0.8.4/lib/active_model/serializer.rb:359:in `serializable_hash'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/active_model_serializers-0.8.4/lib/active_model/serializer.rb:347:in `as_json'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `encode'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `encode'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `to_json'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/active_model_serializers-0.8.4/lib/active_model/serializer.rb:331:in `to_json'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/multi_json-1.13.1/lib/multi_json/adapters/oj.rb:40:in `dump'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/multi_json-1.13.1/lib/multi_json/adapters/oj.rb:40:in `dump'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/multi_json-1.13.1/lib/multi_json/adapter.rb:25:in `dump'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/multi_json-1.13.1/lib/multi_json.rb:139:in `dump'
/var/www/discourse/app/controllers/application_controller.rb:539:in `preload_current_user_data'
/var/www/discourse/app/controllers/application_controller.rb:354:in `preload_json'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `block in make_lambda'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `block (2 levels) in halting'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `block (2 levels) in <module:Callbacks>'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `block in halting'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `block in invoke_before'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `each'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `invoke_before'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `process_action'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `process_action'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `block in process_action'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `block in instrument'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `instrument'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `instrument'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `process_action'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `process_action'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activerecord- `process_action'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `process'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionview- `process'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-mini-profiler-1.0.2/lib/mini_profiler/profiling_methods.rb:78:in `block in profile_method'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `serve'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `block in <class:Constraints>'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `serve'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `block in serve'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `each'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `serve'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-protection-2.0.5/lib/rack/protection/frame_options.rb:31:in `call'
/var/www/discourse/lib/middleware/omniauth_bypass_middleware.rb:32:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/tempfile_reaper.rb:15:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/conditional_get.rb:25:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/head.rb:12:in `call'
/var/www/discourse/lib/content_security_policy/middleware.rb:12:in `call'
/var/www/discourse/lib/middleware/anonymous_cache.rb:216:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/session/abstract/id.rb:232:in `context'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/session/abstract/id.rb:226:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `block in call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/activesupport- `run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/logster-2.1.2/lib/logster/middleware/reporter.rb:30:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/railties- `call_app'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/railties- `call'
/var/www/discourse/config/initializers/100-quiet_logger.rb:16:in `call'
/var/www/discourse/config/initializers/100-silence_logger.rb:29:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `call'
/var/www/discourse/lib/middleware/enforce_hostname.rb:17:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/method_override.rb:22:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/actionpack- `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/sendfile.rb:111:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-mini-profiler-1.0.2/lib/mini_profiler/profiler.rb:171:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/message_bus-2.2.0/lib/message_bus/rack/middleware.rb:57:in `call'
/var/www/discourse/lib/middleware/request_tracker.rb:163:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/railties- `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/railties- `public_send'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/railties- `method_missing'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/urlmap.rb:68:in `block in call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/urlmap.rb:53:in `each'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/rack-2.0.6/lib/rack/urlmap.rb:53:in `call'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/unicorn-5.4.1/lib/unicorn/http_server.rb:606:in `process_client'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/unicorn-5.4.1/lib/unicorn/http_server.rb:701:in `worker_loop'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/unicorn-5.4.1/lib/unicorn/http_server.rb:549:in `spawn_missing_workers'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/unicorn-5.4.1/lib/unicorn/http_server.rb:142:in `start'
/var/www/discourse/vendor/bundle/ruby/2.5.0/gems/unicorn-5.4.1/bin/unicorn:126:in `<top (required)>'
/var/www/discourse/vendor/bundle/ruby/2.5.0/bin/unicorn:23:in `load'
/var/www/discourse/vendor/bundle/ruby/2.5.0/bin/unicorn:23:in `<main>'

Was there an error with the upgrade? The file app/models/queued_post.rb does not exist anymore and that error message indicates it’s still being used.


Nothing reported, everything seemed successful. I’m doing a full rebuild from the console right now to see if that fixes it.

It already should handle the PerformResult because it has an errors property. In fact there’s a test for this:


A full rebuild fixed it, that was fun. ^.^;


Some constructive feedback

There are some gamebreaking problems with this as it stands now, ill run through them here.

  • When i click on a flagged comment, it does not jump directly to the comment in question in the thread. I have to use the search feature to locate the comment that got flagged. This is very stressful on mobile, and tedious overall.

  • When a post gets deleted by the system, i lose the ability to go to the thread in question. I prefer to read the thread as it is, and not through the flag menu.

    This also made things even more complicated when i as unable to mark it as “Not Spam”, and got prompted with this error:
    The way we solved this was to ignore the flag, then locate the deleted thread and un-delete it manually. I dont know if this manual workflow was possible from the beginning, but having the ability to go to the thread in question would certainly be helpful regardless.

  • I dont know if this is intentional or not, but when a flag is “ignored”, i thought that was only supposed to affect that one person, leaving the flag to be death with by someone else. Please correct me if im wrong. Currently, if someone ignores a flag, it gets ignored for everyone. If this is intentional, then look past this point, however, if its ment to only ignore for you, then thats not working properly.

That being said, i love this update as a whole. Just a few minor things to patch up!


Thanks for the feedback. For the Internal Server Error, could you check /logs and tell us what the actual error was?

1 Like

Am i able to do that as a regular moderator? If so, where do i enter the /logs command. Pardon, im relatively new, started at the end of last year.

edit: Im in the logs now, but i dont know what to look for.

It’s a bit tricky to explain, but you’ll want the error that happened right when you clicked “Not Spam”. You might be able to find it by timestamp. When you’re viewing it, you should see the path similar to /review/(some number)/perform/not_spam.json with an error message.


Alright i have to go, but i’ll try to recreate the scenario once i get home with a new account. If i cant figure it out then i’ll see if Bart can look into it.