Page MenuHomePhabricator

Special:RecentChangesLinked fails with PostgreSQL
Closed, ResolvedPublic

Description

Author: nies.david

Description:
My system setting is: 1.13alpha (r35900), PHP 5.2.0, PostgreSQL 8.1.11.

Whenever I open "Special:RecentChangesLinked" for some page, I get the following internal error:

A database error has occurred Query: SELECT /* wfSpecialRecentchangeslinked */ rc_cur_id,rc_namespace,rc_title, rc_user,rc_comment,rc_user_text,rc_timestamp,rc_minor,rc_log_type,rc_log_action,rc_params,rc_deleted, rc_new, rc_id, rc_this_oldid, rc_last_oldid, rc_bot, rc_patrolled, rc_type, rc_old_len, rc_new_len,wl_user FROM pagelinks, recentchangesLEFT JOIN watchlist ON wl_user=1 AND wl_title=rc_title AND wl_namespace=rc_namespace WHERE rc_timestamp > '2008-05-29 16:24:22 GMT' AND pl_namespace=rc_namespace AND pl_title=rc_title AND pl_from=13 GROUP BY rc_cur_id,rc_namespace,rc_title, rc_user,rc_comment,rc_user_text,rc_timestamp,rc_minor,rc_log_type,rc_log_action,rc_params,rc_deleted, rc_new, rc_id, rc_this_oldid, rc_last_oldid, rc_bot, rc_patrolled, rc_type, rc_old_len, rc_new_len,wl_user ORDER BY rc_timestamp DESC LIMIT 50 Function: wfSpecialRecentchangeslinked Error: 1 ERROR: relation "recentchangesleft" does not exist
Backtrace:
#0 /home/david/www/david.theparticulars.org/htdocs/w/includes/Database.php(562): DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT /* wfSpe...', 'wfSpecialRecent...', false)
#1 /home/david/www/david.theparticulars.org/htdocs/w/includes/SpecialRecentchangeslinked.php(137): Database->query('SELECT /* wfSpe...', 'wfSpecialRecent...')
#2 [internal function]: wfSpecialRecentchangeslinked(NULL, Object(SpecialPage))
#3 /home/david/www/david.theparticulars.org/htdocs/w/includes/SpecialPage.php(747): call_user_func('wfSpecialRecent...', NULL, Object(SpecialPage))
#4 /home/david/www/david.theparticulars.org/htdocs/w/includes/SpecialPage.php(533): SpecialPage->execute(NULL)
#5 /home/david/www/david.theparticulars.org/htdocs/w/includes/Wiki.php(224): SpecialPage::executePath(Object(Title))
#6 /home/david/www/david.theparticulars.org/htdocs/w/includes/Wiki.php(55): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#7 /home/david/www/david.theparticulars.org/htdocs/w/index.php(92): MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
#8 {main}


Version: 1.13.x
Severity: normal

Details

Reference
bz14412

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, 10:08 PM
bzimport set Reference to bz14412.
bzimport added a subscriber: Unknown Object (MLST).

Fixed in r35940, thanks for the report.

Jdforrester-WMF subscribed.

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