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…

If I am not mistaken there is a field called deleted_at If it is deleted, then there should be a date time Stamp. If it is not deleted then is null Maybe look for the entry that is <> Null and delete

[画像] IAmGav: Maybe look for the entry that is <> Null and delete Thanks Gav, but the ones that I am targeting aren’t marked as deleted. Rather, their Topic has been deleted and then destroy_all’d.

I was playing around with this and i notice that part of your query was not returning the response you need. SELECT topic_id from posts does not return an integer, but it returned a string [image] This might be the cause that your db still contains orphaned posts.

[画像] IAmGav: does not return an integer, but it returned a string I think that you are seeing Data Explorer automagically converting the integer into URL, which it does when the label is topic_id. When I run this query in Data Explorer , all of the posts that I am attempting to identify are c…

Well, thanks to @pfaffman I have identified the relevant posts using this: Post.find_by_sql("select id from posts where topic_id not in (select id from topics)") I get this output: [1] pry(main)> Post.find_by_sql(“select id from posts where topic_id not in (select id from topics)”) => [#<Post:0…

I think this will do it posts= Post.find_by_sql("select id from posts where topic_id not in (select id from topics)") posts.destroy_all Or you could add the .destroy_all to your find_by_sql

I’ve tried that. The data seems to be returned as an array with some post identifier and an ID (see Delete deleted-posts permanently in bulk? - #45 by nathank ). This is the error I get when I either add .destroy_all or use the posts= that you suggest: [2] pry(main)> posts.destroy_all NoMethodErr…

Oh. Then maybe see if p=posts.first Is a post_id. If t that’s it then you can x=Post.find(p) x.destroy Then you could loop through those. I think you’d need to wrap your query in something to get it to be an array of posts rather than post ids.

Thanks Jay. This is what I get: [3] pry(main)> p= [3] pry(main)* posts.first => #<Post:0x0000563a24cab908 id: 150> [4] pry(main)> x=Post.find(p) ArgumentError: You are passing an instance of ActiveRecord::Base to find. Please pass the id of the object by calling .id. from /var/www/discourse/v…

What did that do? I can’t imagine that rails changed.

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

サポート

pfaffman (Jay Pfaffman) 2021 年 11 月 28 日午前 11:29 51

それが破棄したい投稿を返しますか？

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

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

関連トピック