As shown, the most recent comment is found at the bottom.

alt text

Not only that, the comments in my inbox from top to bottom have the timestamps (currently)

  1. yesterday
  2. yesterday
  3. 9 hours ago
  4. 9 hours ago
  5. 9 hours ago
  6. 5 mins ago
  7. 20 mins ago
  8. 2 hours ago
  9. 19 hours ago
  10. 16 hours ago
  11. 16 hours ago
  12. 13 hours ago
  13. 13 hours ago
  14. 13 hours ago
  15. 12 hours ago
  16. 12 hours ago

It seems like it is ORDER BY CAST(timestamp AS STRING) DESC.

  • I'd already flagged this internally, but: I'm glad it wasn't just my imagination ;p – Marc Gravell Sep 25 '10 at 10:18
  • Apparently right now it's listing newest comments at the bottom. – Jeff Mercado Sep 25 '10 at 11:32
  • @Jeff: Not necessarily. Your recent comment which I found 40 seconds after is shown at the 2nd place because 40 seconds is the largest string before yesterday. i.imgur.com/lalZd.png – kennytm Sep 25 '10 at 11:36
  • Ah, that was just an artifact of a comment being made 1 minute ago at the time. I saw your comment to me third from the bottom. A couple minutes later, it moved up. :) – Jeff Mercado Sep 25 '10 at 11:44
  • @Jeff: Yeah, I have no idea what order they're actually in, but they're not in any obvious most-recent-first or least-recent-first. I have comments from 20 seconds ago bracketed by comments from yesterday. – T.J. Crowder Sep 25 '10 at 15:26

As noted here, the underlying bug was that inbox items were being sorted by their relative timestamps (as strings) rather than by their actual creation dates.

The last build has fixed this error.

  • Just letting you know I just experienced something similar (see below). – Lev Levitsky May 14 '12 at 13:17

I'd like to bump this because I just experienced the same problem. A new comment was very far down the inbox list. At the same time, an older comment that I had read before was highlighted as if it was new.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .