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…

I would do this in batches of say 10, building up to batches of 200 depending on how long it takes. Topic.where(category_id: XX).limit(20).destroy_all It does cascade all stuff it needs so it could take a while.

Hi, I’ve done this without setting a limit and it properly removed all the 5000 topics, but it didn’t seem to destroy all the posts from these topics as the posts table still had the same number of records. Plus, maybe there is a lot of related data in other table to take care of?

Interesting… we are missing a dependant destroy here, I am not sure why. app/models/topic.rb main infos.sort_by! { |i| -i[:width] * i[:height] } end def generate_thumbnails!(extra_sizes: []) return nil unl…

Thanks for your reply :slight_smile: Do you see any table which can contain potentially annoying residual data or do you think that would do the trick and it would be a safe enough method to definitively destroy my topics?

I can not guarantee anything :slight_smile: you are in uncharted territory so you will need to walk all the tables and audit it

[图片] Canapin: 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. Make sure you also delete the import_id custom fields on posts (topics?) if you want to ensure the importer re-import them.

Hi, Finally, I ended not having to delete my topics, I was able to do what I wanted to (not necessarily deleting them ; this could have been a solution but not the only one), see Importing from phpBB3 , Importing from phpBB3 and Importing from phpBB3

通过 Rails 完全删除数百个主题的正确方法？

支持

codinghorror (Jeff Atwood) 2018 年6 月 20 日 22:58 2

I’m not sure – this might also be performance intensive depending on how many weirdo Rails ActiveRecord things this causes to cascade through. Any thoughts @neil have you ever done this?

Can discourse delete archived posts automatically and accept registration without email?

话题		回复	浏览量
Delete deleted-posts permanently in bulk? Support	59	5825	2022 年1 月 8 日
Help Wiping all Posts from a Forum Support	18	2064	2020 年8 月 26 日
Updating topic count in categories after bulk delete & missing topics/posts Support	7	1653	2024 年6 月 8 日
Clean up old topics Support	4	544	2023 年2 月 2 日
Bulk delete all topics in a category Self-Hosting how-to	0	5906	2018 年9 月 23 日

通过 Rails 完全删除数百个主题的正确方法？

相关话题