Last modified: 2010-05-15 15:41:08 UTC
When accessing the Listusers special page (/wiki/index.php/Special:Listusers) an interal error appears with the following: 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 "user" 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 "user.user_id" must appear in the GROUP BY clause or be used in an aggregate function Backtrace: #0 /usr/local/mediawiki/includes/Database.php(604): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT 'Listuse...', '', false) #1 /usr/local/mediawiki/includes/QueryPage.php(319): Database->query('SELECT 'Listuse...') #2 /usr/local/mediawiki/includes/SpecialListusers.php(232): QueryPage->doQuery(0, 50) #3 /usr/local/mediawiki/includes/SpecialPage.php(511): wfSpecialListusers(NULL, Object(SpecialPage)) #4 /usr/local/mediawiki/includes/SpecialPage.php(372): SpecialPage->execute(NULL) #5 /usr/local/mediawiki/includes/Wiki.php(156): SpecialPage->executePath(Object(Title)) #6 /usr/local/mediawiki/includes/Wiki.php(47): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object (WebRequest)) #7 /usr/local/mediawiki/index.php(123): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object (WebRequest)) #8 {main}
Forgot the versions stuff: MediaWiki: 1.7.1 PHP: 5.1.6 (apache) PostgreSQL: PostgreSQL 8.1.3 on powerpc-apple-darwin8.6.0, compiled by GCC powerpc-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5247)
*** This bug has been marked as a duplicate of 7186 ***
