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…

Hmmm. Odd. I just tried it and had similar results. NULLs until back to April 3 I was thinking that was around when I last upgraded, and since I always do a db:migrate after I update that maybe that was what was needed. But no joy. Then I worried that maybe something broke with the upgrade. So …

I’m pretty sure I’m ready to call this a bug. I’ve been trying to find out where last_visited_at is updated so far I have found: The spec successfully tests a call to TopicUser::track_visit updates the value. TopicUser::change - change in notification level watching/tracking etc) TopicUser::updat…

I just ran this SELECT * from topic_users WHERE last_visited_at IS NULL AND ( last_read_post_number > 0 OR highest_seen_post_number > 0 ) ORDER BY id DESC The few results were odd but not totally unexpected. Members were Watching the category when they visited the topics, The top…

[image] DeanMarkTaylor: There are no calls to TopicUser::track_visit outside of the spec. Well actually… app/controllers/topics_controller.rb main topic_id = params[:topic_id].to_i enabled = ActiveModel::Type::Boolean.new.cast(params[:enabled]) …

[image] DeanMarkTaylor: There are no calls to TopicUser::track_visit outside of the spec. [image] sam: Well actually… [image] sam: This seems to be working fine for me. That code was added after the time of my report / investigation: https://github.com/discourse/discourse/commi…

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

Development

DeanMarkTaylor (Dean Taylor) July 25, 2016, 2:02pm 6

That code was added after the time of my report / investigation:
https://github.com/discourse/discourse/commit/6137bb46d31f0bb3ef3a4488c68a17a750ddb84e

Topic		Replies	Views
NULL first_visited_at dates in the topic_users table Development	5	2884	July 2, 2016
Last visit doesn't work for fixed topic list Bug	2	730	February 2, 2019
Already seen posts appearing above Last Visit line? Bug	5	883	January 9, 2025
Mysterious entries in topic_users table Bug	22	3969	May 16, 2016
Request from API doesn't update User#last_seen_at Product Support	8	989	April 15, 2019

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

Related topics