NULL first_visited_at dates in the topic_users table

[DeanMarkTaylor (Dean Taylor)]

Issues around last_visited_at also reported / detailed here:

Is `topic_users.last_visited_at` supposed to be updated on every visit?

Am I completely misunderstanding entirely what these values are for? I’ve been using Data Explorer to review activity and noted that topic_users.last_visited_at didn’t seem to be updating / showing topics I have recently visited. Is topic_users.last_visited_at supposed to be updated on every visit to a topic? Here is the Query I was using with Data Explorer. -- [params] -- int :user_id = 1 SELECT topic_id, last_visited_at, first_visited_at from topic_users WHERE user_id = :u…

Specifically on April 7th I concluded the table is not updated correctly.
I’m unsure if there have been any code updates in this area since.

I didn’t report it in the bug category because there is nowhere in Discourse code base where this was an actual “problem”…
… however data is stored in an inconsistent manor for other plugins and custom users reports to be ran against.