You are reading a single comment by @hamrack and its replies.
Click here to read the full conversation.
-
Fixed the
followed forum does not mark as "NEW"
bug.Turned out that the updates for followed forum marked the forum as
id = 0
which would lead to aCOALESCE
not triggering the NULL condition. I've simplified this by removing the extra columns, removing some JOINs and simply callinghas_unread
on the item itself.It was, in essence, an old optimisation that was no longer needed.
So these are all items that appear as a consequence of following a forum, those are the ones for which "NEW" is not showing?