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