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: [图片] 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 [图片] 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 ??

[图片] 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:

批量永久删除已删除的帖子？

产品支持

itsbhanusharma (Bhanu Sharma) 2021 年9 月 12 日 07:21 2

已删除的主题就是字面意思：一个被删除的主题。无需进一步操作，只有管理员可以查看此类主题。您正在直接删除一个已经被删除的主题。

As an admin, can I see the posts that I deleted?

话题		回复	浏览量
Purge/clean/delete deleted topics from database Product Support	4	506	2025 年7 月 5 日
I am getting 502 error while trying to delete topics created by specific user Product Support	18	1373	2023 年6 月 12 日
Administrative Bulk Operations Self-Hosting configuring , reference	9	14850	2026 年6 月 12 日
Clean up old topics Product Support	4	676	2023 年2 月 2 日
Help Wiping all Posts from a Forum Product Support	18	2446	2020 年8 月 26 日

批量永久删除已删除的帖子？

相关话题