https://bugzilla.wikimedia.org/show_bug.cgi?id=73568
Bug ID: 73568
Summary: column "mwuser.user_name" must appear in the GROUP BY
clause or be used in an aggregate function
Product: MediaWiki
Version: 1.23.3
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: pashev.i...@gmail.com
Web browser: ---
Mobile Platform: ---
Special:ActiveUsers page produces DB error with Postgresql backend:
A database query error has occurred. This may indicate a bug in the software.
Query:
SELECT user_name,user_id,COUNT(*) AS recentedits,qcc_title FROM
"querycachetwo","mwuser","recentchanges" WHERE qcc_type = 'activeusers' AND
qcc_namespace = '2' AND (user_name = qcc_title) AND (rc_user_text = qcc_title)
AND (rc_type != '5') AND (NOT EXISTS (SELECT 1 FROM "ipblocks" WHERE
(ipb_user=user_id) AND ipb_deleted = '1' )) GROUP BY qcc_title ORDER BY
qcc_title LIMIT 51
Function: IndexPager::buildQueryInfo (ActiveUsersPager)
Error: 42803 ERROR: column "mwuser.user_name" must appear in the GROUP BY
clause or be used in an aggregate function LINE 1: ...::buildQueryInfo
(ActiveUsersPager) 127.0.0.1 */ user_name,... ^
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
