XF 2.0 52,000 items in approval queue

[KevinMK]

I have a little less than 52000 threads in my approval queue. Any suggestions of how to mass delete this spam? Perhaps a sql query or a one time php script I can run?

 

[nocte]

You can use "Batch update threads" -> /admin.php?threads/batch-update

Select just "Moderated" threads and delete all of them.

Raw SQL is not a good idea IMHO..

Edit: If the spam threads are from just a few different accounts, then you can also search by user in order to not delete threads, that are not spam.

 

[KevinMK]

Hooray! Thank you.

 

[Kirby]

Any suggestions of how to mass delete this spam?

How do you know that all of those threads are Spam?

 

[KevinMK]

How do you know that all of those threads are Spam?

When your site goes from 1 new user a week, and 1-2 new threads per month, to 52,000 new threads in a month, you know.

 

[Kirby]

Actually you dont't, you can only assume so.

 

[jeb35]

The bigger question is why did you let it get to such a huge amount?

 

[KevinMK]

Thanks, lecture over guys. Move along.