RSS feeder with same timestamps causes random sorts

Hi

unfortunately my search query was insufficient to find all the places where the ordering is undefined and MySQL does not show the behaviour you described (it always sorted the same). Anyway, try applying the following change: https://github.com/WoltLab/WCF…f99e2a727c9765e53c5e8c56a

If it solves your issue: Great. If not: I'll have to delve deeper …

Hi

Quote from tjk

It looks like it fixed the thread view, but it still happens on the hot threads widget, if you refresh it changes the order of the items listed on that widget.

that's not a bug. The order is dynamically calculated and might change between two refreshes.

Hi

Quote from tjk

Tim, why would it change on a forum with zero activity on it though?

hits are included in the calculation as well. While it might be possible that two threads will have the same score the chance of this happening is really small in a real forum (one second difference or one hit more or less and the score will change). The box is already pretty slow, sorting by more columns will bring next to zero benefit for a possible decrease in performance.

Quote from tjk

That refresh order should not change for hot threads when nothing is happening on the forums.

It should! Maybe not in your specific case (see explanation above), but: The "temperature" is calculate as the quotient between the hits and replies and a power of the age of the topic. Because of this non linear denominator newer threads will relatively lose temperature faster than older threads. The less mathematical reasoning behind this is, that older threads with sustained hits and replies are probably more interesting than newer threads that quickly gained attention for a very short time span, therefore newer threads will cool down faster.