Last modified: 2014-07-11 21:04:34 UTC
in 1.22, if a filename begins with a capital letter, searching fails if your search criteria includes the capital letter. If you omit the first character, it works fine. I found this to be because of the following line in /includes/special/SpecialListfiles.php, Line 138: $conds[] = 'LOWER(' . $prefix . '_name)' . If this is changed to the following, you can now search using a capital letter: $conds[] = 'CONVERT(' . $prefix . '_name USING latin1)' . Originally found by Fereal in a previous version, I simply adopted their solution for the new function in 1.22. Link to that discussion below: http://www.mediawiki.org/wiki/Thread:Project:Support_desk/Search_function_in_File_list_doesn't_work_properly
CONVERT(' . $prefix . '_name USING latin1) will break for pretty much everyone other than MySQL.