Last modified: 2012-08-04 20:48:52 UTC
In DifferenceEngine.showDiffPage, a timestamp is passed as a database condition in TS_MW format. A database error has occurred Query: SELECT * FROM recentchanges WHERE rc_timestamp = '20080124171514' AND rc_this_oldid = '2' AND rc_last_oldid = '1' AND rc_patrolled = '0' Function: DifferenceEngine::showDiffPage Error: 1 ERROR: invalid input syntax for type timestamp with time zone: "20080124171514" Backtrace: #0 /srv/www/htdocs/wikidev/mediawiki-1.11.1/includes/Database.php(796): DatabasePostgres->reportQueryError('ERROR: invalid...', 1, 'SELECT * FROM...', 'DifferenceEngin...', false) #1 /srv/www/htdocs/wikidev/mediawiki-1.11.1/includes/Database.php(1241): Database->query('SELECT * FROM...', 'DifferenceEngin...') #2 /srv/www/htdocs/wikidev/mediawiki-1.11.1/includes/RecentChange.php(100): Database->select('recentchanges', '*', Array, 'DifferenceEngin...') #3 /srv/www/htdocs/wikidev/mediawiki-1.11.1/includes/DifferenceEngine.php(178): RecentChange::newFromConds(Array, 'DifferenceEngin...') #4 /srv/www/htdocs/wikidev/mediawiki-1.11.1/includes/Article.php(674): DifferenceEngine->showDiffPage(false) #5 /srv/www/htdocs/wikidev/mediawiki-1.11.1/includes/Wiki.php(383): Article->view() #6 /srv/www/htdocs/wikidev/mediawiki-1.11.1/includes/Wiki.php(48): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest)) #7 /srv/www/htdocs/wikidev/mediawiki-1.11.1/index.php(89): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest)) #8 {main}
Created attachment 4578 [details] patch against 1.11.1 Fixes for me on Postgres 8.1.9 and MediaWiki 1.11.1
This was fixed 4 months ago in r25696. 1.12 will behave correctly.
