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…

[画像] IAmGav: (currently hidden for some reason) Ah, that might be my stumbling block. I was looking for can_permanently_delete in the admin settings and couldn’t see it.

The site setting is hidden because we do not encourage its use. That was developed for the cases when some sensitive information was posted and it must be scrubbed from the database completely. One more thing, that operation is not a bulk operation anyway. Since it is a hidden site setting, the onl…

[画像] RGJ: Post.with_deleted.where(‘deleted_at is not null’).update_all(raw: ‘This post has been deleted’, cooked: ‘This post has been deleted’) This is almost exactly what I need! Thank you. How would I do the syntax so that it only covers all posts deleted before xxxx date?

That would be Post.with_deleted.where("deleted_at < 'YYYY-mm-dd'").update_all(...)

Can you let us know how to enable it from the console?

Here’s the instructions: [画像] Enable setting to allow admins to permanently delete data Self-Hosting As of 2.8.0.beta7: Security Release, Fast Edits, Topic Bookmarks, and more there is a hidden site setting to allow admins to permanently delete data. To enable it, you’d s…

[画像] JammyDodger: can_permanently_delete Feature Enabled from console but how i can delete deleted-posts ??? all posts present in deleted-posts

I really am no expert on this, but it seems like there’s enough snippets of information in this topic to create the code you’re looking for. The topic I linked at the start has the warnings from the creators in about this being uncharted territory, and you do it at your own risk. But they also prov…

In order to delete the old posts on our forum, I used this. It is the result of combining The proper way to completely delete hundred of topics via rails? and @RGJ ’s suggestions. I chose to do this in the end, as I really wanted to remove the data from the database to protect the privacy of users. …

I imagen that your ./launcher cleanup afterwards also free’d up some space :slight_smile:

削除済み投稿を一括で完全に削除する？

サポート

JammyDodger 2021 年 10 月 21 日午後 2:50 35

手順はこちらです：

トピック		返信	表示
Purge/clean/delete deleted topics from database Support	4	313	2025 年 7 月 5 日
Administrative Bulk Operations Self-Hosting configuring , reference	8	14133	2026 年 2 月 25 日
I am getting 502 error while trying to delete topics created by specific user Support	20	1104	2023 年 6 月 12 日
Clean up old topics Support	4	549	2023 年 2 月 2 日
Help Wiping all Posts from a Forum Support	18	2067	2020 年 8 月 26 日

削除済み投稿を一括で完全に削除する？

関連トピック