XF 2.2 How can I delete quickly all approval queue?

[Dkf]

There are more than thousand approval queue wait admin to approve in my forum.
How can I delete quickly all approval queue?
I want to use MySQL command to drop these data (delete). Can you guide me?

 

[AndyB]

You might like this add-on:

https://xenforo.com/community/resources/approval-queue-tools.8288/

 

[jeb35]

Why did you let that get so high? That has to be months of neglecting the forum.

 

[eL_]

That's a HUGE number!

 

[Dkf]

Why did you let that get so high? That has to be months of neglecting the forum.

I migrated to XF from Vbulletin yesterday.
I didn't see this on VB.

 

[eL_]

I migrated to XF from Vbulletin yesterday.
I didn't see this on VB.

Well, I suppose the best option is @AndyB add-on.
BTW... welcome to the best forum platform

 

[Dkf]

I used this command

mysql> UPDATE xf_post SET message_state = 'visible' WHERE message_state = 'moderated';
Query OK, 5544 rows affected (1 min 56,60 sec)
Rows matched: 5544 Changed: 5544 Warnings: 0


But the counter on the site has not changed. How to update it?

 

[Hoffi]

You may need to rebuild caches.

/admin.php?tools/rebuild

 

[Dkf]

You may need to rebuild caches.

/admin.php?tools/rebuild

Which one?

"user caches"?

 

[NikitOS]

@Dkf, there can be not only posts in the approval queue, but also users, threads, etc. Please provide the result of this request to determine if there is anything other than posts:

SELECT DISTINCT content_type FROM xf_approval_queue

In any case, you can clear the xf_approval_queue table to clear the approval queue:

TRUNCATE xf_approval_queue

However, if there was something other than posts in the approval queue, additional manipulations may be required.