Can’t find a post even ID is known

Product Support

AI-generated summary

jagster is trying to find a post with ID 18289, but it’s not showing up in the database even with a SELECT query. CocoQuark suggests that the post may have been hard-deleted, which would remove it from the database, and points to a similar discussion for an explanation. jagster confirms that they have manually hard-deleted posts in the past and wonders why these deleted posts are left behind when the topic is removed. Hard deletion of posts is rare, as posts are normally soft-deleted, and jagster is curious about the process.

1

I was fixing deprecated Font Awesome icons, but one gave this:

A terminal output showing a successful remapping of posts using the 'discourse-microsoft-auth' plugin, with a warning about a failed remapping attempt, followed by a confirmation of the number of posts remapped. (Captioned by AI)
A terminal output showing a successful remapping of posts using the 'discourse-microsoft-auth' plugin, with a warning about a failed remapping attempt, followed by a confirmation of the number of posts remapped. (Captioned by AI)2360×506 133 KB

I tried finding it using this:

SELECT *
FROM posts
WHERE id = 18289
AND deleted_at IS NOT NULL

But it couldn’t find anything.

Any guesses why? And should remap show topic_id too?

I can live even if I never find that one, but it annoys me because I don’t understand what happened. I’m quite sure I’ve never used icon task in a post, so my imagination says it could be some ancient kanban-post, but it should still be able to find it, right?

2

Yes:

An answer for a similar output can be found here:

Posts are normally soft-deleted unless the hidden setting is enabled, so I’m not sure what actions can hard-delete a post so it is removed from the database. But the explanation makes sense anyway.

3

I’ve done a hard delete manually every now and then, if I’m really bored.

Yeah, that sounds like a valid explanation.

I’m just wondering why those posts are left behind when the topic itself is vanished into the void.