XF 2.2 My Aproval Queue has 7 thousand items on it, how to bulk get rid of it?

[mauzao9]

As the title asks, there's a proper over the top amount of accounts/etc on the approval queue and it's outright impossible to deal with this one by one.

If someone would be so kind as to point how could I deal with this, even if I could just execute a query on the DB to clear this because I'm not sure how to proceed.

Thanks

 

[Old Nick]

It's paid but efficient.

Approval queue tools

Mar 4, 2021

Allows mass updating of approval queue content.

• AndyB
• Add-ons [2.x]

 

[mauzao9]

It's paid but efficient.

Approval queue tools

Mar 4, 2021

Allows mass updating of approval queue content.

• AndyB
• Add-ons [2.x]

That's useful. I also just found a DB query that clears that table and that sorted me up

 

[jeb35]

My question to you would be how did it get so many?

 

[KensonPlays]

It's paid but efficient.

Approval queue tools

Mar 4, 2021

Allows mass updating of approval queue content.

• AndyB
• Add-ons [2.x]

Andy's add-on sub is well worth it though, imo. 35 bucks for hundreds of single-purpose add-ons? Great deal.

 

[mauzao9]

My question to you would be how did it get so many?

The forum was left quiet for about almost 3 years, the anti-spam stuff did block the bots but put them in the approval queue, I wasn't really bothered until I ran into not being able to do a bulk action on it heh