FIX: Sometimes queued post would have a string for a category

FIX: Sometimes queued post would have a string for a category

In this case, don’t migrate the old queued post category

diff --git a/db/migrate/20190111170824_migrate_reviewable_queued_posts.rb b/db/migrate/20190111170824_migrate_reviewable_queued_posts.rb
index c673777..b83b116 100644
--- a/db/migrate/20190111170824_migrate_reviewable_queued_posts.rb
+++ b/db/migrate/20190111170824_migrate_reviewable_queued_posts.rb
@@ -17,7 +17,7 @@ class MigrateReviewableQueuedPosts < ActiveRecord::Migration[5.2]
         user_id,
         true,
         topic_id,
-        nullif(post_options->>'category', '')::int,
+        NULLIF(REGEXP_REPLACE(post_options->>'category', '[^0-9]+', '', 'g'), '')::int,
         json_build_object(
           'old_queued_post_id', id,
           'raw', raw

GitHub sha: 13c6bf54

This commit has been mentioned on Discourse Meta. There might be relevant details there: