https://bugzilla.wikimedia.org/show_bug.cgi?id=71530

            Bug ID: 71530
           Summary: Invalid GROUP BY in SpecialActiveusers
           Product: MediaWiki
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Special pages
          Assignee: [email protected]
          Reporter: [email protected]
       Web browser: ---
   Mobile Platform: ---

When using a database that requires non-aggregated columns in the GROUP BY
(e.g. Postgres), SpecialActiveusers fails because the user_name and user_id
columns are brought back unaggregatged, but do not appear in the GROUP BY. The
solution is to change SpecialActiveusers.php, inside of getQueryInfo, the
abovementioned columns should be added to the GROUP BY array. Alternatively, if
this is suboptimal for MySQL, the list of grouped columns should be conditional
based on the implicitGroupby property of the database (see for example
WikiPage.php).

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to