You are reading a single comment by @Velocio 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 = 0which would lead to aCOALESCEnot triggering the NULL condition. I've simplified this by removing the extra columns, removing some JOINs and simply callinghas_unreadon the item itself.It was, in essence, an old optimisation that was no longer needed.
Velocio
Yup. I've followed the 'wanted' sub forum and all new items turn up in following but aren't marked as new. However, if I click through into wanted then the same thread is now marked as new.