Last modified: 2010-05-15 15:48:34 UTC
Just installed the latest stable MediaWiki 1.9.0, using PostgreSQL 8.1.4 on Linux. When I click on the "Related changes" link in the sidebar (from the main page, probably elsewhere as well), I get the following error: Internal error A database error has occurred Query: SELECT /* wfSpecialRecentchangeslinked */ rc_id, rc_cur_id, rc_namespace, rc_title, rc_user, rc_comment, rc_user_text, rc_this_oldid, rc_last_oldid, rc_timestamp, rc_minor, rc_bot, rc_new, rc_patrolled, rc_type, rc_old_len, rc_new_len ,wl_user FROM pagelinks, recentchanges LEFT OUTER JOIN watchlist ON wl_user=2 AND wl_title=rc_title AND wl_namespace=rc_namespace WHERE rc_timestamp > '2007-01-05 19:11:13 GMT' AND pl_namespace=rc_namespace AND pl_title=rc_title AND pl_from=1 GROUP BY rc_cur_id,rc_namespace,rc_title, rc_user,rc_comment,rc_user_text,rc_timestamp,rc_minor, rc_new, rc_id, rc_this_oldid, rc_last_oldid, rc_bot, rc_patrolled, rc_type ,wl_user ORDER BY rc_timestamp DESC LIMIT 50 Function: wfSpecialRecentchangeslinked Error: 1 ERROR: column "recentchanges.rc_old_len" must appear in the GROUP BY clause or be used in an aggregate function Backtrace: #0 /srv/www/htdocs/wiki/includes/Database.php(666): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT /* wfSpe...', 'wfSpecialRecent...', false) #1 /srv/www/htdocs/wiki/includes/SpecialRecentchangeslinked.php(142): Database->query('SELECT /* wfSpe...', 'wfSpecialRecent...') #2 /srv/www/htdocs/wiki/includes/SpecialPage.php(625): wfSpecialRecentchangeslinked('Main_Page', Object(UnlistedSpecialPage)) #3 /srv/www/htdocs/wiki/includes/SpecialPage.php(431): SpecialPage->execute('Main_Page') #4 /srv/www/htdocs/wiki/includes/Wiki.php(183): SpecialPage::executePath(Object(Title)) #5 /srv/www/htdocs/wiki/includes/Wiki.php(47): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest)) #6 /srv/www/htdocs/wiki/index.php(47): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest)) #7 {main}
Thanks for the report: fixed in r19177.