Post count bug


  • Notification Spam Recipient

    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.


  • SockDev

    ..... 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: :hanzo:'d by @PJH


  • Notification Spam Recipient

    Phew, good to know it is a real bug. I thought maybe I was just WAY behind on my reading



  • @PJH said:

    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.



  • @boomzilla said:

    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....


  • SockDev

    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.


  • SockDev

    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:


  • Discourse touched me in a no-no place

    @accalia said:

    which is odd because it does remember to +x it on moving x posts into the topic.

    YMBNH

    Filed under: Discoursistency


  • SockDev

    @antiquarian said:

    YMBNH

    hmm.... am i?

    @shadowmod attendance



  • Attendance accalia 25
    Backup Date: 2015-07-30 03:47:20
    
    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 ```
    ``` 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 ``` <!-- Posted by SockBot 0.16 "Hazardous Hera" (+419:525d63e) on behalf of &#x40;PJH -->

  • Discourse touched me in a no-no place

    Don't you have enough whoosh :badger:s already?


  • SockDev

    /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?


  • Discourse touched me in a no-no place

    @accalia said:

    Why, you want to rummage through the pile for something to take home?

    Actually, I'd rather have a special snowflake badge.


  • SockDev

    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.


  • mod

    @accalia said:

    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.


  • SockDev

    i asked about toppics, not topics! :-P


  • mod

    @accalia said:

    i asked about toppics, not topics! :-P

    It's hard to tell what you mean with all the @accalias you leave lying around. ;)


  • SockDev

    @racperouk doesn't seem to mind.


Log in to reply
 

Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.