Last modified: 2014-11-19 17:07:17 UTC
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,... ^