[@LegendBegins] Interesting. You just helped uncover a fundamental bug.

Found it on page 4 of the Casual Roleplay forum:

[img]https://dl.dropboxusercontent.com/spa/quq37nq1583x0lf/0smyfkc1.png[/img]

And this is how it displays in the Free Roleplay forum:

[img]https://dl.dropboxusercontent.com/spa/quq37nq1583x0lf/ykkj1ir9.png[/img]

(Thinking out loud) Looking at the code, it sorts topics by:

[pre]ORDER BY (t.moved_at OR t.latest_post_at) DESCENDING[/pre]
But that's wrong. That logic will prevent a moved topic from ever getting bumped to the top.

It should instead be:

[pre]ORDER BY MAX(t.moved_at, t.latest_post_at) DESCENDING[/pre]
That way the forum takes the most recent of the two timestamps.

#willfix - Created an issue: https://github.com/danneu/guild/issues/71

Apparently this has been broken since I built the move-topic system months ago. :lol