I’ve a topic in our database with an category_id which category someone has deleted. I can open this topic directly with it’s id: url: …/t/3 in table topics the id = 3 has category = 4. But this category is deleted and not in table categories. Many of this lost topics I could delete. But this one …

[圖片] JammyDodger: How was this category deleted in the first place? Good question. It was done some years ago by an other admin. Meanwhile I deleted this topic direct in rails console with: result = ActiveRecord::Base.lease_connection.exec_delete('DELETE FROM topics WHERE id = 3') After th…

[圖片] steinjer: in table topics the id = 3 has category = 4. I think that’s the About topic for the General category?. Normally the about topics would be undeletable in the UI. Is there a reason you want to delete this one completely?

cause this category isn’t more available, but which is more important: link to all categories in sidebar doesn’t work anymore. If I try open …/categories I get errormessage: “Error Something went wrong.” and in browser console errormessage is shown: Uncaught TypeError: i is null reason binary.…

It sounds like someone deleted the category when it has topics in it somehow? That’s not supposed to happen. I think you’ll need to do something like rails c c=Category.last; # or some other way to get a category) Topic.where(category_id: 4).update_all(category_id: c.id)

If your General category was deleted safely through the UI then it’s expected that the About topic would be soft deleted like you’re seeing. It shouldn’t cause any issues. :thinking: I think there may be something else at play. Is there any more detail about that error in your /logs page?

[圖片] pfaffman: Topic.where(category_id: 4).update_all(category_id: c.id) This seems not to work: discourse(prod)> Topic.where(category_id: 4).update_all(category_id: 20) => 0 discourse(prod)> Topic.where(id: 3).update_all(category_id: 20) => 0 And in Data Explorer I get: Select id, closed…

Hmm. I thought your broken topic had category_id of 4. [圖片] steinjer: in table topics the id = 3 has category = 4. That was my best guess. If you have a budget you might ask for help in Marketplace . I think you’ll need someone to get into rails to see if they can figure it out.

Marketplace is always an option, especially if it’s urgent. :heart: Though a bit more detail here might help jimmy up a community response. :crossed_fingers: You both seem confident that the root cause is this topic. If data explorer can find it then you should be able to find it in the rails cons…

yes, in ruby console I can see that topic: result = ActiveRecord::Base.lease_connection.exec_query('SELECT id, category_id FROM topics WHERE id = 3') result.rows => [[3, 4]] but in Topic is nothing Topic.where(id: 3) => []

[圖片] JammyDodger: If you can find it then you should be able to use post_destroyer on it and delete it from there? as you can see, finding is possible. But I have no idea of the Ruby syntax to delete exactly this one table entry.

Hmm. :thinking: It is unusual to be able to find it one way and not the other. The rails console can be a bit of a sharp knife so it’d be best to figure out what exactly has gone wrong just to minimise any accidents/knock on effects. How was this category deleted in the first place? (Just in case…

无法删除没有类别的主题

支持

JammyDodger 2025年五月28日 11:25 13

这是否也解决了你侧边栏中那个不正常的分类链接？

有趣的是，它明明已经正常运行了好几年，现在才出现问题。

如果你弄清楚了其中的联系，请告诉我。

話題		回覆	觀看
Can't delete this category because it has 1 topic Support	11	1338	2021年二月2日
I can't delete a category or topic description Support	27	2261	2018年九月11日
Cannot delete system created topic Support	13	1318	2019年九月14日
Not being able to delete topic blocks category deletion Support	11	447	2024年五月21日
Undelete A Category? (Or the "about this category" topic that was under it) Support	3	592	2021年三月20日

无法删除没有类别的主题

相關主題