Bulk delete from approval queue

[BankFodder]

We converted from vBulletin last year.

I suddenly discovered that we got over 17,000 posts all stacked up in the approval queue dating around 2007 onwards.

Anybody got any idea how I can bulk delete these please.

Thanks

[Miss_B]

18 minutes ago, BankFodder said:

We converted from vBulletin last year.

I suddenly discovered that we got over 17,000 posts all stacked up in the approval queue dating around 2007 onwards.

Anybody got any idea how I can bulk delete these please.

Thanks

If you go to your Mod CP, on the left site under HIDDEN CONTENT select Posts. There you will see an overview list with all the moderated posts. Select all rows per page and you can delete them all by clicking the Trash can icon for delete. Hope it helps.

P.s. It would be best imo, that before you do that, to make first a backup of your database. Hope it helps.

[BankFodder]

I'll have a look.  Thanks

[BankFodder]

I've had a look – and yes I understand what you have suggested – and in fact I knew that – but the problem is that there are over 700 pages and that means that you have to do do each page individually checking the "all" box at the top for every page.

I'm trying to find out if there is a way of doing the whole lot at one go.

[BankFodder]

Also, when you check "all" on a page and then go to the next page to check "all" again, the check marks from the first page will disappear. This means that you have to go through the whole process of clicking "all", then going to the delete procedure and then onto the next page and begin it all again – 797 times in our particular case!

I'm amazed that all the old deleted vBulletin data is still there even from 2006.

[Adriano Faria]

That’s what I did last year in a huge database for a client: https://invisioncommunity.com/forums/topic/451760-how-to-update-hidden-topics-and-posts-cache/

You can run a query To change the queue state   Instead of removing the posts. 

 

[Miss_B]

3 hours ago, BankFodder said:

I've had a look – and yes I understand what you have suggested – and in fact I knew that – but the problem is that there are over 700 pages and that means that you have to do do each page individually checking the "all" box at the top for every page.

I'm trying to find out if there is a way of doing the whole lot at one go.

You can run a sql query as well, although I would not recommend it doing it that way. Anyways, here is the query if you still want to do it.

DELETE FROM `forums_posts` WHERE queued = -1;

If you want to exclude the first post of the topic, i.e. the topic itself, run this query instead:

DELETE FROM `forums_posts` WHERE queued = -1 AND new_topic = 0;

And do not forget to make a backup of the db first. 

[BankFodder]

4 hours ago, Adriano Faria said:

That’s what I did last year in a huge database for a client: https://invisioncommunity.com/forums/topic/451760-how-to-update-hidden-topics-and-posts-cache/

You can run a query To change the queue state   Instead of removing the posts. 

 

 

4 hours ago, Miss_B said:

You can run a sql query as well, although I would not recommend it doing it that way. Anyways, here is the query if you still want to do it.

DELETE FROM `forums_posts` WHERE queued = -1;

If you want to exclude the first post of the topic, i.e. the topic itself, run this query instead:

DELETE FROM `forums_posts` WHERE queued = -1 AND new_topic = 0;

And do not forget to make a backup of the db first. 

Hmmmm .... thar' be dragons ....  !

 

Thanks for the responses - but I think that I'll leave it  

[MeMaBlue]

Hello, should i be able to see the box here at the right to be able to delete the hidden content ?

is that a permissions issue ? if yes, how can I find this permission to edit it?

i suddenly got a flood of smammers yesterday. 

 

[Marc]

There is no built in way to do this within the software unfortunately. The only way would be page by page, or external intervention as mentioned

[BankFodder]

This is something that I referred to several eons ago.

Apart from being an extremely useful feature, it would add consistency to the interface, which in some cases is sadly lacking .

How about including this in a forthcoming upgrade?

 

 

[Marc]

Feel free to post this up within our suggestions area. But in reality, these are very rare one off occasions (conversions and the likes, as on here). If they are something happening on a consistent basis, then the workflow of how you approve items should be looked into.