I've got about 390 threads that showed up in the moderation queue today... (out of no where) and I want to approve them all at once... does anyone know of a query to do it manually or a way to do it all at once in the web ui?
I came up with some queries for you. Backup first!
WHERE content_type = 'thread'
SET discussion_state = 'visible'
WHERE discussion_state = 'moderated'
Run these two queries in sequence to approve all currently moderated threads. I tested this and it appears to work. But it doesn't update the Moderation Queue number shown in the screenshot above. I can't figure out how to update that number.