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

[image] 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

La bonne façon de supprimer complètement des centaines de sujets via Rails ?

Soutien

codinghorror (Jeff Atwood) Juin 20, 2018, 10: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?

Sujet		Réponses	Vues
Delete deleted-posts permanently in bulk? Support	59	5825	Janvier 8, 2022
Help Wiping all Posts from a Forum Support	18	2064	Août 26, 2020
Updating topic count in categories after bulk delete & missing topics/posts Support	7	1653	Juin 8, 2024
Clean up old topics Support	4	544	Février 2, 2023
Bulk delete all topics in a category Self-Hosting how-to	0	5906	Septembre 23, 2018

La bonne façon de supprimer complètement des centaines de sujets via Rails ?

Sujets connexes