XF 2.2 How can I delete quickly all approval queue?

[USCSS_Nostromo]

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!

 

[USCSS_Nostromo]

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

 

[USCSS_Nostromo]

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

 

[USCSS_Nostromo]

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.

 

[crondoc]

One handy way of not messing with SQL in case you mess up the table dependencies is to use jQuery is to mass-check or uncheck the boxes you want on the page. Xenforo 2 as far as I can make out doesn't have a "reject all" or similar button to mass approve/reject new signups.

I use Google Chrome so when you are viewing your approval queue press shift+control+i and the developer console will open.
Click on "Console".
Paste in lines like this (changing as appropriate for your scenario)

// this line below will check all the "reject" radio buttons on every VISIBLE user:
$('input[type="radio"][value="reject"]').prop('checked', true);

// this line will uncheck ALL the "Notify user if action was taken" check boxes
$('input[type="checkbox"]').prop('checked', false);

I'm not sure how to show ALL users on one page but if you have a few hundred signups you want to get rid of you can just do this a few times. Saves time manually checking/unchecking a radio button for each user.

I love Xenforo but there is a lack of simple mass admin options like this for edge scenarios.

 

[Jeff Ripley]

One handy way of not messing with SQL in case you mess up the table dependencies is to use jQuery is to mass-check or uncheck the boxes you want on the page. Xenforo 2 as far as I can make out doesn't have a "reject all" or similar button to mass approve/reject new signups.

I use Google Chrome so when you are viewing your approval queue press shift+control+i and the developer console will open.
Click on "Console".
Paste in lines like this (changing as appropriate for your scenario)

// this line below will check all the "reject" radio buttons on every VISIBLE user:
$('input[type="radio"][value="reject"]').prop('checked', true);

// this line will uncheck ALL the "Notify user if action was taken" check boxes
$('input[type="checkbox"]').prop('checked', false);

I'm not sure how to show ALL users on one page but if you have a few hundred signups you want to get rid of you can just do this a few times. Saves time manually checking/unchecking a radio button for each user.

I love Xenforo but there is a lack of simple mass admin options like this for edge scenarios.

Hi Crondoc,

that worked well and saved messing about with sql queries.