Defect #13669
closed 
    
  Sorting forum message list by "Last message" (="updated_on") does not work correctly
0%
Description
I noticed this bug on the official Redmine forum itself, in particular on
  http://www.redmine.org/projects/redmine/boards/4?sort=updated_on%3Adesc
I.e. I am asking it to show me the messages according to the date they were last updated, in descending order. This way, the most recently message should be displayed first (well, except for sticky messages). But this does not work correctly. E.g. right now, it shows me
  http://www.redmine.org/boards/4/topics/37123
in position three, that message was last updated 6 days ago (2013-03-27).
At position 6 of the list, there is
  http://www.redmine.org/boards/4/topics/36894
which was lasted updated 17 days ago (2013-03-17).
And then it has in position 11
  http://www.redmine.org/boards/4/topics/36492
which was lasted updated 5 days ago (2013-03-28)
Clearly something is wrong. Note that there are many more similar examples.
Related issues