[3157] Top Topic Starters incorrectly sorted

Started by MegaByte, February 18, 2009, 01:13:06 AM

Previous topic - Next topic

MegaByte

Earlier today, I upgraded a forum from SMF 2.0b4 MySQL to 2.0 RC1 PostgreSQL.

For some reason, the Top Topic Starters list on the Stats page is not sorted by number of topics.  Instead, it's sorted by User ID.

http://www.nintendoworldreport.com/forums/index.php?action=stats

karlbenson

Thx, I added it to the tracker.
http://dev.simplemachines.org/mantis/view.php?id=3157

Appears to be an issue with PostGresql, and orderby when used with a group by clause.

MegaByte

It looks like this got fixed, but what exactly was the fix, so that I can apply it to my boards?

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

MegaByte

Thanks... though that didn't actually work for me.  Were there perhaps changes to the database functions?

EnricoR

Worked for me, thanks. (Though I don't think those stats are that important.)

Advertisement: