Dear Team, Please help me out to resolve this! We have too many deleted-posts and we need to delete that permanently but in bulk! [image]

Excellent, glad to hear that did the job for you. So for the sake of combining the answers, one can use the following in the Rails console to destroy all topics that were deleted more than 90 days ago, repeating as many times as necessary if there are more than 1000 topics: Topic.with_deleted.where…

A deleted topic is exactly what it is, a deleted topic. No further action is required and only admins can view such topics. You directly delete an already deleted topic.

i dont want in deleted topics list i want to clear them from DB. so if any command or any way to delete those??

It’s not something I’ve done, but is this topic helpful: [image] The proper way to completely delete hundred of topics via rails? Support Hi. I would like to delete ALL topics from a single category (~5000 topics) in order to re-import these topics from …

Not Useful :frowning: please help me if anything found?

maybe this can help you [image] Bulk delete all topics in a category Self-Hosting bookmark This guide provides instructions on how to bulk delete all topics within a category on a self-hosted Discourse instance. person_raising_hand Required user level: System…

[image] not showing deleted-posts category ??

[image] rahulMasal: deleted-posts Do you have a category with the slug deleted-posts? The posts in your screenshot look like they are probably in categories that have different slugs. [image] [image]

If I delete Category wise then all POSTS will delete which not in deleted-posts! so can you help me to delete deleted-posts from DB.

I’m trying to find a way to do this too. After much searching here on Meta, and a lot of trial and failure, I am now quite confused about it all. Can we indeed permanently purge deleted posts from the database? How?

if you can delete a category, then you can delete deleted posts. rebuilding my test app now to install data explorer :slight_smile:

Delete deleted-posts permanently in bulk?

Support

IAmGav (Gavin Perch) September 12, 2021, 9:21am 6

maybe this can help you

Topic		Replies	Views
Purge/clean/delete deleted topics from database Support	4	350	July 5, 2025
I am getting 502 error while trying to delete topics created by specific user Support	18	1161	June 12, 2023
Administrative Bulk Operations Self-Hosting configuring , reference	9	14354	June 12, 2026
Clean up old topics Support	4	573	February 2, 2023
Help Wiping all Posts from a Forum Support	18	2090	August 26, 2020

Delete deleted-posts permanently in bulk?

Related topics