Page MenuHomePhabricator

Watchlist broken on PostgreSQL
Closed, ResolvedPublic

Description

Author: sven

Description:
Accessing the Special:Watchlist page leads to the following error:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input
syntax for type timestamp with time zone: "" in
/var/www/wiki.c3d2.de/htdocs/mediawiki/includes/DatabasePostgres.php on line 385
Interner Fehler

A database error has occurred Query: SELECT rc_namespace AS page_namespace,
rc_title AS page_title, rc_comment AS rev_comment, rc_cur_id AS page_id, rc_user
AS rev_user, rc_user_text AS rev_user_text, rc_timestamp AS rev_timestamp,
rc_minor AS rev_minor_edit, rc_this_oldid AS rev_id, rc_last_oldid, rc_id,
rc_patrolled, rc_new AS page_is_new,wl_notificationtimestamp FROM
watchlist,recentchanges,page WHERE wl_user=11 AND wl_namespace=rc_namespace AND
wl_title=rc_title AND rc_timestamp > '' AND rc_cur_id=page_id AND
rc_this_oldid=page_latest ORDER BY rc_timestamp DESC Function:
wfSpecialWatchlist Error: 1 ERROR: invalid input syntax for type timestamp with
time zone: ""

Backtrace:

#0 /var/www/wiki.c3d2.de/htdocs/mediawiki/includes/Database.php(658):
DatabasePostgres->reportQueryError('ERROR: invalid...', 1, 'SELECT?? rc_na...',
'wfSpecialWatchl...', false)
#1 /var/www/wiki.c3d2.de/htdocs/mediawiki/includes/SpecialWatchlist.php(307):
Database->query('SELECT?? rc_na...', 'wfSpecialWatchl...')
#2 /var/www/wiki.c3d2.de/htdocs/mediawiki/includes/SpecialPage.php(625):
wfSpecialWatchlist(NULL, Object(SpecialPage))
#3 /var/www/wiki.c3d2.de/htdocs/mediawiki/includes/SpecialPage.php(431):
SpecialPage->execute(NULL)
#4 /var/www/wiki.c3d2.de/htdocs/mediawiki/includes/Wiki.php(156):
SpecialPage::executePath(Object(Title))
#5 /var/www/wiki.c3d2.de/htdocs/mediawiki/includes/Wiki.php(47):
MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage),
Object(WebRequest))
#6 /var/www/wiki.c3d2.de/htdocs/mediawiki/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
bz8350

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:30 PM
bzimport set Reference to bz8350.
bzimport added a subscriber: Unknown Object (MLST).

sven wrote:

Fixes the Watchlist for PostgreSQL

Attached:

sven wrote:

sorry accidentally reopened it

Jdforrester-WMF subscribed.

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