Hidden 9 yrs ago Post by LegendBegins
Raw
OP
Avatar of LegendBegins

LegendBegins

Moderator Online

Could a mod move the thread "Myriad Reality" from the Free Roleplay Forum to the Casual Forum? We've determined that finding individuals with the level of skill required is not conducive in that environment, but we've had this thread too long to just start a new one.
Hidden 9 yrs ago Post by Meth Quokka
Raw
Avatar of Meth Quokka

Meth Quokka This Was Nutter's Idea

Member Seen 2 yrs ago

Moved. If you have any issues, let me know.
Hidden 9 yrs ago Post by LegendBegins
Raw
OP
Avatar of LegendBegins

LegendBegins

Moderator Online

Moved. If you have any issues, let me know.


Thank you very much; we appreciate the help.
Hidden 9 yrs ago Post by LegendBegins
Raw
OP
Avatar of LegendBegins

LegendBegins

Moderator Online

@Kangaroo
Actually, there is an issue. While the thread shows up on the "Latest post by: " on the home screen, it doesn't appear in the Casual Thread List.
Hidden 9 yrs ago 9 yrs ago Post by Mahz
Raw
Avatar of Mahz

Mahz ¯\_(ツ)_/¯

Admin Seen 2 mos ago

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

Found it on page 4 of the Casual Roleplay forum:



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



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

ORDER BY (t.moved_at OR t.latest_post_at) DESCENDING

But that's wrong. That logic will prevent a moved topic from ever getting bumped to the top.

It should instead be:

ORDER BY MAX(t.moved_at, t.latest_post_at) DESCENDING

That way the forum takes the most recent of the two timestamps.

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

Apparently this has been broken since I built the move-topic system months ago.
Hidden 9 yrs ago Post by LegendBegins
Raw
OP
Avatar of LegendBegins

LegendBegins

Moderator Online

@Mahz
Interesting; I'm glad we found that, then. Thank you.
↑ Top
© 2007-2024
BBCode Cheatsheet