Author: swickert
Description:
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}
Version: 1.9.x
Severity: normal
OS: Linux
Platform: PC