https://bugzilla.wikimedia.org/show_bug.cgi?id=67702

            Bug ID: 67702
           Summary: filelist search for media name - capital letters
           Product: MediaWiki
           Version: 1.22.0
          Hardware: All
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: Unprioritized
         Component: General/Unknown
          Assignee: [email protected]
          Reporter: [email protected]
       Web browser: ---
   Mobile Platform: ---

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to