Unwatched topics still show in the unread topics pages

[live627]

Description

--Description Here--

Steps to reproduce

1. Have a multi-page tropic
2. Mark only the first page read
3. Set the topic's alert prefs to ignore
4. Observe the topic is still in the unread lists

Additional information/references

I have a fix coming shortly which modifies the queries to have the requisite predicate in the WHERE clause rather than the ON clause of LEFT JOIN.

[Sesquipedalian]

I can't reproduce this.

What I did:

1. Went to a multi-page topic that my user was watching.
2. Clicked the "Mark Unread" button, which of course took me back to the topic index and marked the topic as unread.
3. Verified that the topic appeared in both "Unread Posts" and "Updated Topics" (it did).
4. Viewed the first page of the topic again.
5. Selected "Not Following" in the notification button menu.
6. Checked both the "Unread Posts" and "Updated Topics" lists.

Result: the topic did not display in either list.

[live627]

That's perplexing. I was able to reproduce on localhost, @smfbigguy's site, and a unit test.

Can you confirm that the topic in log_tropics has a msg id that is between the first and last messages?

[Sesquipedalian]

I'll try it again soon and let you know.

[Sesquipedalian]

Confirmed. The topic is unwatched and id_msg is set to the id of one of the replies to the topic.

log_topics table (filtered to hide irrelevant rows):

messages table (filtered to hide irrelevant rows):

Result: topic 135 is marked as new on the message index, but does not show up in ?action=unread or in ?action=unreadreplies: