User talk:JohanTheGhost

From MediaWiki.org

just thought i would tell you that your wikipiedia page follows to a page that doesn't exist

Thanks, fixed it. JohanTheGhost 14:10, 29 June 2007 (UTC)

[edit] RigorousSearch

I have a remark about your RigorousSearch extension (which is really useful for me). My mediawiki table "text" is from type InnoDB. The "old_text" field is stored as MEDIUMBLOB. But BLOBs are case-sensitive. So, I have to enter the search string with correct lower/upper case, which is - for me - not optimal. "Mediwiki" search string only finds "Mediawiki" but not "mediawiki".

I have changed the code by adding a CAST() funtion in order to search case-insensitive:

$queryTxt = "SELECT old_text FROM " . $db->tableName('text') .
                    " WHERE old_id = " . $text_id .
                    " AND CAST(old_text as CHAR) LIKE '%" . $pattern . "%'";

Maybe it's worth to add to the "official" extension. 09:27, 7 February 2008 (UTC)