Sorting forum message list by "Last message" (="updated_on") does not work correctly
I noticed this bug on the official Redmine forum itself, in particular on
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
in position three, that message was last updated 6 days ago (2013-03-27).
At position 6 of the list, there is
which was lasted updated 17 days ago (2013-03-17).
And then it has in position 11
which was lasted updated 5 days ago (2013-03-28)
Clearly something is wrong. Note that there are many more similar examples.
#2 Updated by Anonymous over 5 years ago
But #12243 is closed, while the problem is still present. So it seems a bit odd to me that this issue now is getting closed. Shouldn't it be kept open (possible renamed to something like "sorting redmine.org forums by 'last updated' date is broken" until the actual issue is resolved on redmine.org, too? Ideally, resolution would not just mean "we wait until all messages visible on the first page of the forum overview are sorted"), but rather would also cover fixing the updated_on column for older messages. This should be doable, as all the information can be recovered from the messages in each thread, shouldn't it? So I guess a relatively simple script should do it, and I am sure other redmine admins would love to have such a script, too, in order to fix their incorrect data in the repository, too.