• Welcome to Simple Machines Community Forum. Please login or sign up.
January 29, 2022, 09:04:01 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


[3157] Top Topic Starters incorrectly sorted

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

Previous topic - Next topic

MegaByte

February 18, 2009, 01:13:06 AM Last Edit: March 14, 2009, 01:41:52 PM by SleePy
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
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

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: