Last modified: 2012-08-04 20:48:48 UTC
After upgarede MediaWiki from 1.10.1 to 1.11.0 System description: OS: Fedora Core 6 MediaWiki: 1.11.0 PHP: 5.1.6 (apache2handler) PostgreSQL: PostgreSQL 8.1.10 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-13) Log error: Internal error A database error has occurred Query: INSERT INTO filearchive (fa_storage_group,fa_storage_key,fa_deleted_user,fa_deleted_timestamp,fa_deleted_reason,fa_deleted,fa_name,fa_archive_name,fa_size,fa_width,fa_height,fa_metadata,fa_bits,fa_media_type,fa_major_mime,fa_minor_mime,fa_description,fa_user,fa_user_text,fa_timestamp) SELECT 'deleted',IF(img_sha1='', '', CONCAT(img_sha1,'.jpg')),'1','2007-10-26 04:40:53 GMT','',0,img_name,NULL,img_size,img_width,img_height,img_metadata,img_bits,img_media_type,img_major_mime,img_minor_mime,img_description,img_user,img_user_text,img_timestamp FROM image WHERE img_name = 'Awards-bf2.JPG' Function: LocalFileDeleteBatch::doDBInserts Error: 1 ERROR: function concat(text, "unknown") not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. Backtrace: #0 /var/www/wiki/includes/Database.php(779): DatabasePostgres->reportQueryError('ERROR: ???????...', 1, 'INSERT INTO fi...', 'LocalFileDelete...', false) #1 /var/www/wiki/includes/Database.php(1845): Database->query('INSERT INTO fi...', 'LocalFileDelete...') #2 /var/www/wiki/includes/filerepo/LocalFile.php(1216): Database->insertSelect('filearchive', 'image', Array, Array, 'LocalFileDelete...') #3 /var/www/wiki/includes/filerepo/LocalFile.php(1297): LocalFileDeleteBatch->doDBInserts() #4 /var/www/wiki/includes/filerepo/LocalFile.php(873): LocalFileDeleteBatch->execute() #5 /var/www/wiki/includes/FileDeleteForm.php(75): LocalFile->delete('') #6 /var/www/wiki/includes/ImagePage.php(491): FileDeleteForm->execute() #7 /var/www/wiki/includes/Wiki.php(397): ImagePage->delete() #8 /var/www/wiki/includes/Wiki.php(48): MediaWiki->performAction(Object(OutputPage), Object(ImagePage), Object(Title), Object(User), Object(WebRequest)) #9 /var/www/wiki/index.php(89): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest)) #10 {main} P.P.S. Sorry for my English. (Ntive - Russian)
Did you run maintenance/update.php ?
Yes. I am complaince with instruction http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.11
Sorry. Yes. I followed instruction: http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.11 And this is the result: [pas@gate maintenance]$ php update.php MediaWiki 1.11.0 Updater Going to run database updates for wikkibd Depending on the size of your database this may take a while! Abort with control-c in the next five seconds...0 ... sequence log_log_id_seq already exists ... sequence pr_id_val already exists ... table mediawiki_version already exists ... table mwuser already exists ... table pagecontent already exists ... table querycachetwo already exists ... table page_restrictions already exists ... table profiling already exists ... table redirect already exists ... obsolete archive2 not present ... column archive.ar_len already exists ... add column archive.ar_page_id ... add column image.img_sha1 ... column ipblocks.ipb_anon_only already exists ... add column ipblocks.ipb_block_email ... column ipblocks.ipb_create_account already exists ... column ipblocks.ipb_deleted already exists ... column ipblocks.ipb_enable_autoblock already exists ... column filearchive.fa_deleted already exists ... column logging.log_deleted already exists ... column logging.log_id already exists ... column logging.log_params already exists ... column mwuser.user_editcount already exists ... column mwuser.user_newpass_time already exists ... add column oldimage.oi_deleted ... add column oldimage.oi_metadata ... add column oldimage.oi_media_type ... add column oldimage.oi_major_mime ... add column oldimage.oi_minor_mime ... add column oldimage.oi_sha1 ... column page_restrictions.pr_id already exists ... column recentchanges.rc_deleted already exists ... column recentchanges.rc_log_action already exists ... column recentchanges.rc_log_type already exists ... column recentchanges.rc_logid already exists ... column recentchanges.rc_new_len already exists ... column recentchanges.rc_old_len already exists ... column recentchanges.rc_params already exists ... column revision.rev_len already exists ... image.img_size is already int4 ... image.img_width is already int4 ... image.img_height is already int4 ... ipblocks.ipb_address is already text ... math.math_inputhash is already bytea ... math.math_outputhash is already bytea ... oldimage.oi_size is already int4 ... oldimage.oi_width is already int4 ... oldimage.oi_height is already int4 ... user_newtalk.user_ip is already text create index archive_user_text create index img_sha1 create index oi_sha1 ... index rev_text_id_idx on revision already exists ... obsolete pagelink_unique index not present ... already have current pagelink_unique index ... revision_rev_user_fkey is already ON DELETE RESTRICT ... archive.ar_deleted already exists Done.
Temporary solution - downgrade from 1.11.0 to 1.10.2
Perhaps I think same cause as bug 11905, 12365. Please test this solution. http://bugzilla.wikimedia.org/show_bug.cgi?id=12365 # Sorry, my English is broken because I'm native Japanese :-). *** This bug has been marked as a duplicate of bug 11905 ***