Last modified: 2006-12-31 15:44:10 UTC
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}
Created attachment 2917 [details] Fixes the Watchlist for PostgreSQL
Applied in r18475, thanks.
sorry accidentally reopened it