Search function in File list doesn't work properly
Hi dear, when I try to search a name in File List the result are empty either if the file is in the wiki; a workaround is to omit the first char of filename ( http://www.mwusers.com/forums/showthread.php?16489-Search-function-in-File-list-doesn-t-work-properly ) . I've tried with last mediawiki release ( 1.16.2 ) but the problem persist.
DB: Mysql 5.0.77 OS: Centos 5.5
I've always thought the File List search needed some sort of option to activate since it never worked for me.
Checking the file, the query generated attempts to convert both the image names and the search query to lowercase before using a LIKE comparison. I've checked the database and apparently the image name column is set as VARBINARY, preventing the lowercase conversion of the image name thus botching the comparison.
TL;DR Go to includes\specials\SpecialListfiles.php. On Line 84, change:
$this->mQueryConds = 'LOWER(img_name)' .
$this->mQueryConds = 'CONVERT(img_name USING latin1)' .
Necrobumping since this problem still persists in 1.19.