Page MenuHomePhabricator

"Related changes" link gets SQL error under PostgreSQL
Closed, ResolvedPublic

Description

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

Details

Reference
bz8613

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:34 PM
bzimport set Reference to bz8613.
bzimport added a subscriber: Unknown Object (MLST).

Thanks for the report: fixed in r19177.

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.