Author: amos.shapira

Description:
Using the Debian Etch ("Testing" as of today) package for Mediawiki 1.7.1
(debian revision 9), Postgres version 8.1.8-1, PHP 5.2.0-8, browser is iceweasel
2.0.0.2 (Debian's compilation of Firefox 2.0.0.2).

Installed using instructions found in meta.wikimedia.org/­wiki/Help:Installation

Browsing to the Special:Listusers as a logged in user I got the following error:

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/share/mediawiki1.7/includes/Database.php(604):
DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT 'Listuse...',
'', false)
#1 /usr/share/mediawiki1.7/includes/QueryPage.php(319): Database->query('SELECT
'Listuse...')
#2 /usr/share/mediawiki1.7/includes/SpecialListusers.php(232):
QueryPage->doQuery(0, 50)
#3 /usr/share/mediawiki1.7/includes/SpecialPage.php(511):
wfSpecialListusers(NULL, Object(SpecialPage))
#4 /usr/share/mediawiki1.7/includes/SpecialPage.php(372): SpecialPage->execute(NULL)
#5 /usr/share/mediawiki1.7/includes/Wiki.php(156):
SpecialPage->executePath(Object(Title))
#6 /usr/share/mediawiki1.7/includes/Wiki.php(47):
MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage),
Object(WebRequest))
#7 /usr/share/mediawiki1.7/index.php(123): MediaWiki->initialize(Object(Title),
Object(OutputPage), Object(User), Object(WebRequest))
#8 {main}

Version: 1.7.x
Severity: major
OS: Linux
Platform: PC