Last modified: 2012-08-04 20:48:43 UTC
When performing a lookup to find the IPs of a given user, the following database error occurs: A database error has occurred Query: SELECT cuc_ip,cuc_ip_hex, COUNT(*) AS count, MIN(cuc_timestamp) AS first, MAX(cuc_timestamp) AS last FROM cu_changes WHERE cuc_user = 1 GROUP BY cuc_ip ORDER BY last DESC Function: CheckUser::doUserIPsRequest Error: 1 ERROR: column "cu_changes.cuc_ip_hex" must appear in the GROUP BY clause or be used in an aggregate function Backtrace: #0 /home/wiki/includes/db/Database.php(562): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT cuc_ip,c...', 'CheckUser::doUs...', false) #1 /home/wiki/extensions/CheckUser/CheckUser_body.php(658): Database->query('SELECT cuc_ip,c...', 'CheckUser::doUs...') #2 /home/wiki/extensions/CheckUser/CheckUser_body.php(83): CheckUser->doUserIPsRequest('OverlordQ', 'Test') #3 /home/wiki/includes/SpecialPage.php(533): CheckUser->execute(NULL) #4 /home/wiki/includes/Wiki.php(224): SpecialPage::executePath(Object(Title)) #5 /home/wiki/includes/Wiki.php(55): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest)) #6 /home/wiki/index.php(92): MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest)) #7 {main}
Fixed in r36408