Post count bug
-
Not sure if this has been posted before. See if you can spot it...
-
67 posts have been moved out of that thread (to date.)
I'm guessing something, somewhere, is still including them in the unread count....
And no - I don't recall it being mentioned before.
-
..... were any toppics jeffed from that topic? i can't recall any but i think that would explain why there are more unread posts in the topic than are actually in the topic.
EDIT: 'd by @PJH
-
Phew, good to know it is a real bug. I thought maybe I was just WAY behind on my reading
-
I'm guessing something, somewhere, is still including them in the unread count....
Likely by subtracting the first unread post id from the last post it in the topic.
-
Likely by subtracting the first unread post id from the last post it in the topic.
That seems far too simple for Discourse - they must at least multiply the difference by two, add 24, multiply the result by 5, subtract 120 then divide that by 10....
-
actually i think it just stores the number of unread in some user data table (because that number is different for everyone) and just +1's it on post.
and forgets t -x it when moving x posts out of the topic.
which is odd because it does remember to +x it on moving x posts into the topic.
-
I think you're correct if by data table you mean wooden table. It prints out and OCRs every number used in any calculation.
-
does it rotate the printout by a semirandom amount before OCRing the printout?
what about crumpling it a little bit? does it do that?
-
Of course. It's inevitable when the process works like this:
-
which is odd because it does remember to +x it on moving x posts into the topic.
YMBNH
Filed under: Discoursistency
-
-
Attendance accalia 25 Backup Date: 2015-07-30 03:47:20
``` username | start_range | end_range | days accalia | 2014-08-22 | 2015-07-29 | 342 accalia | 2014-06-16 | 2014-06-17 | 2 accalia | 2014-06-03 | 2014-06-04 | 2 accalia | 2014-05-29 | 2014-05-29 | 1 ```Query
``` WITH StartingPoints AS ( SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum FROM user_visits AS A WHERE NOT EXISTS ( SELECT * FROM user_visits AS B WHERE B.visited_at = A.visited_at - INTERVAL '1 day' AND B.user_id = A.user_id ) ), EndingPoints AS ( SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum FROM user_visits AS A WHERE NOT EXISTS ( SELECT * FROM user_visits AS B WHERE B.visited_at = A.visited_at + INTERVAL '1 day' AND B.user_id = A.user_id ) ) SELECT u.username, S.visited_at AS start_range, E.visited_at AS end_range, (E.visited_at - S.visited_at + 1) AS Days FROM StartingPoints AS S JOIN EndingPoints AS E ON E.rownum = S.rownum JOIN users u ON u.id=S.user_id AND u.username ILIKE $1::varchar ORDER BY u.id ASC, S.visited_at DESC LIMIT $2::int ```
-
Don't you have enough whoosh s already?
-
/me shrugs
Given my habit for the obscure joke, particularly those that rely on knowing something while subverting expectations by seeming to not know that same something... i just throw the things out back on the pile. NFC how many i've got now.
Why, you want to rummage through the pile for something to take home?
-
Why, you want to rummage through the pile for something to take home?
Actually, I'd rather have a special snowflake badge.
-
I think i'm fresh out of those, but feel free to have a rummage and if you can find one you can have it.
-
were any toppics jeffed from that topic?
No topics have been jeffed out of that topic. But, as @PJH mentioned, 67 posts have been jeffed from that topic.
-
i asked about toppics, not topics! :-P
-
i asked about toppics, not topics! :-P
It's hard to tell what you mean with all the @accalias you leave lying around. ;)
-
@racperouk doesn't seem to mind.