Last modified: 2007-03-20 04:02:54 UTC
Fix errant group by clause in SpecialListusers.php:
A database error has occurred Query: SELECT 'Listusers' as type, 2 AS
namespace, user_name AS title, user_name as value, user_id,
COUNT(ug_group) as numgroups FROM mwuser LEFT JOIN user_groups ON
user_id=ug_user GROUP BY user_name ORDER BY value LIMIT 50 OFFSET 0
Function: Error: 1 ERROR: column "mwuser.user_id" must appear in the
GROUP BY clause or be used in an aggregate function
Created attachment 2299 [details]
Fix the group by issues, also clean up the SQL a little bit.
Patch applied, subversion 16348.
"Fix" this bug again without testing it on MySQL and I'll remove your svn
access. This is the second time we've had severe performance problems on
Wikimedia because of this kind of postgresql compatibility patch.
*** Bug 7399 has been marked as a duplicate of this bug. ***
Fixed in version 16348: made special exception for MySQL's behavior.
*** Bug 9345 has been marked as a duplicate of this bug. ***