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(deleted_at: ...90.days.ago).limit(1000).destroy_all After that has completed, the following can be used to destroy all posts that have been orphaned from destroyed topics: Post.find_by_sql("select * from posts where topic_id not in (select id from topics)").each { |p| p.destroy } It’s worth noting that the above commands will not destroy deleted posts however, only deleted topics and their orphaned posts. To also destroy deleted posts older than 90 days, use the following, again repeating as necessary: Post.with_deleted.where(deleted_at: ...90.days.ago).limit(1000).destroy_all P.S. Out of interest, did you try destroy_all without limit(1000) and have problems or did you not try it without the limit?

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 phpbb. I could delete these topics, but since Discourse doesn’t really delete them but hide them, my phpbb import won’t re-import these messages. I can’t just re-import from scratch either because I did a lot of configuration since my import. Not only discourse admin config but also reorganized categories, moved hundreds of topics by keywords, filtered a lot of messages with reg…

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 Administrator warning SSH access to your server is required Removing all topics from a category can be necessary for various reasons, such as reorganizing content or clearing outdated discussions. This guide walks you through the steps to accomplish this task safely on a self-hosted Discourse server. …

[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?

Product Support

JammyDodger September 12, 2021, 8:22am 4

It’s not something I’ve done, but is this topic helpful:

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

Delete deleted-posts permanently in bulk?

Related topics