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 …

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) 11월 28, 2021, 11:29오전 51

이 쿼리로 삭제하려는 게시글들을 가져올 수 있나요?

글		댓글	조회수
Purge/clean/delete deleted topics from database Product Support	4	476	7월 5, 2025
I am getting 502 error while trying to delete topics created by specific user Product Support	18	1351	6월 12, 2023
Administrative Bulk Operations Self-Hosting configuring , reference	9	14780	6월 12, 2026
Clean up old topics Product Support	4	659	2월 2, 2023
Help Wiping all Posts from a Forum Product Support	18	2382	8월 26, 2020

삭제된 게시물을 일괄적으로 영구 삭제할 수 있나요?

Related topics