Bulk removal of soft deleted threads/posts

[makaiguy]

Have had my mods set up to be able to soft delete only. Unfortunately we're running out of our allotted db room. We're actively researching new servers, but in the meanwhile, would like to free up the space taken by the soft deleted posts.

Is there an easy way to bulk remove these soft deletions?

[OTWA]

In the ACP you should be able to use prune and select the thread state..

Thread State

Visible
Awaiting Moderation
Deleted
Any

That should do it for you.

[makaiguy]

[smacking forehead]

Geez, never thought to look in the obvious place. Figured it was gonna take some sort of manually-entered query. Thanks a ton!