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