Hello
I want to update an image stored in mediawiki. In order to do that, I
upload the new version, using the same file name the image was previously
known.
mediawiki fires an internal error, with all the details below.
This is mediawiki-1.11.0, php-5.2.5, postgresql-8.2.6. Any hint?
--- cut here ---
Erreur interne
A database error has occurred Query: INSERT INTO oldimage (oi_name,oi_archive_name,oi_size,oi_width,oi_height,oi_bits,oi_timestamp,oi_description,oi_user,oi_user_text,oi_metadata,oi_media_type,oi_major_mime,oi_minor_mime,oi_sha1) SELECT img_name,'20080123094112!Test.jpg',img_size,img_width,img_height,img_bits,img_timestamp,img_description,img_user,img_user_text,img_metadata,img_media_type,img_major_mime,img_minor_mime,img_sha1 FROM image WHERE img_name = 'Test.jpg' Function: LocalFile::recordUpload2 Error: 1 ERROR: column "oi_metadata" is of type bytea but expression is of type text LINE 1: ...,oi_timestamp,oi_description,oi_user,oi_user_text,oi_metadat... ^ HINT: You will need to rewrite or cast the expression.
Backtrace:
#0 /usr/local/src/mediawiki-1.11.0/includes/Database.php(779): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'INSERT INTO ol...', 'LocalFile::reco...', false)
#1 /usr/local/src/mediawiki-1.11.0/includes/Database.php(1845): Database->query('INSERT INTO ol...', 'LocalFile::reco...')
#2 /usr/local/src/mediawiki-1.11.0/includes/filerepo/LocalFile.php(746): Database->insertSelect('oldimage', 'image', Array, Array, 'LocalFile::reco...')
#3 /usr/local/src/mediawiki-1.11.0/includes/filerepo/LocalFile.php(642): LocalFile->recordUpload2('20080123094112!...', 'Photo de Bertra...', 'Photo de Bertra...', Array, false)
#4 /usr/local/src/mediawiki-1.11.0/includes/SpecialUpload.php(436): LocalFile->upload('/tmp/php25707k', 'Photo de Bertra...', 'Photo de Bertra...', 1, Array)
#5 /usr/local/src/mediawiki-1.11.0/includes/SpecialUpload.php(248): UploadForm->processUpload()
#6 /usr/local/src/mediawiki-1.11.0/includes/SpecialUpload.php(14): UploadForm->execute()
#7 /usr/local/src/mediawiki-1.11.0/includes/SpecialPage.php(653): wfSpecialUpload(NULL, Object(SpecialPage))
#8 /usr/local/src/mediawiki-1.11.0/includes/SpecialPage.php(459): SpecialPage->execute(NULL)
#9 /usr/local/src/mediawiki-1.11.0/includes/Wiki.php(201): SpecialPage::executePath(Object(Title))
#10 /usr/local/src/mediawiki-1.11.0/includes/Wiki.php(45): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#11 /usr/local/src/mediawiki-1.11.0/index.php(89): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest))
#12 {main}
--- cut here ---
--
Emmanuel Dreyfus
manu(a)netbsd.org