Calculated read time is high though there is only one post

sam · May 16, 2024, 7:18am

Oh my… this is a double bug:

lib/post_revisor.rb

45abb67f4


      
          def update_topic_word_counts
            DB.exec(
              "UPDATE topics
                            SET word_count = (
                              SELECT SUM(COALESCE(posts.word_count, 0))
                              FROM posts
                              WHERE posts.topic_id = :topic_id
                            )
                            WHERE topics.id = :topic_id",
              topic_id: @topic.id,
            )
          end

Post Revisor is not excluding posts with deleted_at not null

And Post Destroyer does nothing: discourse/lib/post_destroyer.rb at 45abb67f432bd009ca1bfef3e7735e632a4299fd · discourse/discourse · GitHub

So there is no workaround here even.

We will sort it out

Topic		Replies	Views
Unread count does not take removed posts into account Bug	2	653	February 7, 2022
Reply counts on topics with auto-deleting posts Bug	4	979	June 30, 2020
Number of unread replies is different than number of topic replies due to reply deletions UX	8	1261	March 14, 2024
Are post read counts per user accurate? Product Support	20	5583	November 27, 2017
Incorrect unread-post counter UX	2	623	May 12, 2022

Calculated read time is high though there is only one post

Related topics