Author: pashev.igor

Description:
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,... ^

Version: 1.23.3
Severity: normal