Author: peter.scheie
Description:
We're running MW version 1.11.1 (according to the RELEASE-NOTES file) as installed via SVN on CentOS 5, using Postgresql 8.1.9 as installed via yum from the CentOS repos. Uploading files works, and users are able to subsequently download those files. However, attempting to update or remove an existing file, whether as a regular logged-in user or as the wiki sysop, results in the following 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,'.doc')),'1','2007-11-07 20:39:47 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 = 'JMS_Messaging_Problem_Within_Dual.doc' Function: LocalFileDeleteBatch::doDBInserts Error: 1 ERROR: function concat(text, "unknown") does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts.
Backtrace:
#0 /var/www/ctswiki/includes/Database.php(779): DatabasePostgres->reportQueryError('ERROR: functio...', 1, 'INSERT INTO fi...', 'LocalFileDelete...', false)
#1 /var/www/ctswiki/includes/Database.php(1845): Database->query('INSERT INTO fi...', 'LocalFileDelete...')
#2 /var/www/ctswiki/includes/filerepo/LocalFile.php(1216): Database->insertSelect('filearchive', 'image', Array, Array, 'LocalFileDelete...')
#3 /var/www/ctswiki/includes/filerepo/LocalFile.php(1297): LocalFileDeleteBatch->doDBInserts()
#4 /var/www/ctswiki/includes/filerepo/LocalFile.php(873): LocalFileDeleteBatch->execute()
#5 /var/www/ctswiki/includes/FileDeleteForm.php(75): LocalFile->delete('')
#6 /var/www/ctswiki/includes/ImagePage.php(491): FileDeleteForm->execute()
#7 /var/www/ctswiki/includes/Wiki.php(397): ImagePage->delete()
#8 /var/www/ctswiki/includes/Wiki.php(48): MediaWiki->performAction(Object(OutputPage), Object(ImagePage), Object(Title), Object(User), Object(WebRequest))
#9 /var/www/ctswiki/index.php(89): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest))
#10 {main
Version: 1.11.x
Severity: critical
OS: Linux
Platform: PC