[Mediawiki-l] internal error when updating an image

Dieter Bigalke db.wiki at bigalke.de
Wed Jan 23 10:44:14 UTC 2008


Emmanuel Dreyfus schrieb:
> 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 at netbsd.org
> 
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Emmanuel,

look at http://bugzilla.wikimedia.org/show_bug.cgi?id=12365

Dieter



More information about the MediaWiki-l mailing list