I'm using mediawiki 1.12.0 with postgres on suse 10.1 and I'm getting the following Internal Error when I try to revert an image or any other uploaded file to a previous revision:
A database error has occurred Query: SELECT oi_size,oi_width,oi_height,oi_bits,oi_media_type,o i_major_mime,oi_minor_mime,oi_metadata,oi_timestam p,oi_sha1,oi_user,oi_user_text,oi_description,oi_a rchive_name FROM oldimage WHERE oi_name = 'sample1.png' AND (oi_timestamp <= '20090210135833!Bats_US.png') ORDER BY oi_timestamp DESC LIMIT 1 Function: OldLocalFile::loadFromDB Error: 1 ERROR: invalid input syntax for type timestamp with time zone: "20090210135833!sample1.png"
#0 /opt/wiki/mediawiki-1.12.0/includes/Database.php(799): DatabasePostgres->reportQueryError('ERROR: invalid...', 1, 'SELECT oi_size...', 'OldLocalFile::l...', false)
#1 /opt/wiki/mediawiki-1.12.0/includes/Database.php(1244): Database->query('SELECT oi_size...', 'OldLocalFile::l...')
#2 /opt/wiki/mediawiki-1.12.0/includes/Database.php(1263): Database->select('oldimage', Array, Array, 'OldLocalFile::l...', Array)
#3 /opt/wiki/mediawiki-1.12.0/includes/filerepo/OldLocalFile.php(170): Database->selectRow('oldimage', Array, Array, 'OldLocalFile::l...', Array)
#4 /opt/wiki/mediawiki-1.12.0/includes/filerepo/LocalFile.php(248): OldLocalFile->loadFromDB()
#5 /opt/wiki/mediawiki-1.12.0/includes/filerepo/LocalFile.php(449): LocalFile->load()
#6 /opt/wiki/mediawiki-1.12.0/includes/filerepo/FileRepo.php(90): LocalFile->exists()
#7 /opt/wiki/mediawiki-1.12.0/includes/filerepo/RepoGroup.php(66): FileRepo->findFile(Object(Title), '20090210135833!...')
#8 /opt/wiki/mediawiki-1.12.0/includes/GlobalFunctions.php(2318): RepoGroup->findFile(Object(Title), '20090210135833!...')
#9 /opt/wiki/mediawiki-1.12.0/includes/FileRevertForm.php(137): wfFindFile(Object(Title), '20090210135833!...')
#10 /opt/wiki/mediawiki-1.12.0/includes/FileRevertForm.php(58): FileRevertForm->haveOldVersion()
#11 /opt/wiki/mediawiki-1.12.0/includes/ImagePage.php(498): FileRevertForm->execute()
#12 /opt/wiki/mediawiki-1.12.0/includes/Wiki.php(404): ImagePage->revert()
#13 /opt/wiki/mediawiki-1.12.0/includes/Wiki.php(48): MediaWiki->performAction(Object(OutputPage), Object(ImagePage), Object(Title), Object(User), Object(WebRequest))
#14 /opt/wiki/mediawiki-1.12.0/index.php(90): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest))
#15 /opt/wiki/mediawiki-1.12.0/index.php5(1): require('/opt/wiki/media...')
#16 {main}
Anyone have any ideas and what I can do, to try and solve this problem.


Reply With Quote
Bookmarks