My goal was to delete a topic from the DB due to legal reasons. so I ran the command: root@he-ps09-superstars:/var/www/discourse# echo “Topic.destroy(id)” | rails c The topic was deleted :+1: The category still thinks there is 1 topic and I cannot delete the category.

What other tables cross index the topic id? Did you delete those rows as well? What other tables cross index fields in those other tables? Did you delete those rows? rinse - repeat - until all are deleted. IMHO it is much safer and a lot simpler to “delete” a topic using the UI than to delete i…

[صورة] Mittineague: What other tables cross index the topic id? I am not touching postgres. I am letting the code do its work As per @sam at: https://meta.discourse.org/t/how-to-permanent-delete-a-topic-from-database-with-his-posts/15073/2?u=vikaskedia this may nuke dependent objects.

[صورة] Mittineague: but hahaha !! that post was written in 2014 i think there might have been improvments after that .. Someone posted questionable content .. hence just a soft delete just does not work. Though I completely get @codinghorror point that there should not be hard delete in the…

استخدام topic.destroy(id) لحذف المحتوى غير القانوني

مطور

Mittineague (Mittineague) 30 مارس 2018، 6:45م 4

Yes, but
https://meta.discourse.org/t/how-to-permanent-delete-a-topic-from-database-with-his-posts/15073/4?u=mittineague

الموضوع		الردود	مرات العرض
Can't delete topic without category Support	13	348	28 مايو 2025
The proper way to completely delete hundred of topics via rails? Support	10	5706	6 يوليو 2018
Delete deleted-posts permanently in bulk? Support	58	7181	9 ديسمبر 2021
Can't delete this category because it has 1 topic Support	11	1374	2 فبراير 2021
Delete posts if topics are getting hard deleted Support	1	473	31 ديسمبر 2020

استخدام topic.destroy(id) لحذف المحتوى غير القانوني

الموضوعات ذات الصلة