Last modified: 2012-08-04 20:48:48 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 11767 - Can not delete images
Can not delete images
Status: RESOLVED DUPLICATE of bug 11905
Product: MediaWiki
Classification: Unclassified
General/Unknown (Other open bugs)
PC Linux
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2007-10-26 04:56 UTC by Anton
Modified: 2012-08-04 20:48 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Anton 2007-10-26 04:56:36 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. 


#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)
Comment 1 Daniel Cannon (AmiDaniel) 2007-10-26 04:57:53 UTC
Did you run maintenance/update.php ?
Comment 2 Anton 2007-10-26 05:03:25 UTC
Yes. I am complaince with instruction
Comment 3 Anton 2007-10-26 12:47:02 UTC
Yes. I followed instruction:

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
Comment 4 Anton 2007-10-31 03:20:01 UTC
Temporary solution - downgrade from 1.11.0 to 1.10.2
Comment 5 ISAKA Yoji 2008-01-05 18:22:02 UTC
Perhaps I think same cause as bug 11905, 12365.

Please test this solution.

# Sorry, my English is broken because I'm native Japanese :-).

*** This bug has been marked as a duplicate of bug 11905 ***

Note You need to log in before you can comment on or make changes to this bug.