[Phpwiki-talk] mysql 4.1.0 bug alert

[Reini U. <ru...@x-...>]

Mysql 4.1.0-alpha has a problem with binary textfields.
Confirmed at http://bugs.mysql.com/bug.php?id=1491

Symptom & Reproduce:
Every search will fail if the searchstring is not case-exact.
e.g. Search for "find": "FindPage" will not be found.

Workarounds:
1.) Change the field attribute for pagename in table page
     not to be "binary"
   ALTER TABLE `page` CHANGE `pagename` `pagename` VARCHAR( 100 ) NOT NULL;

2.) or install 4.1.1 (currently only from source), 5.x
     or downgrade to 3.23.x or 4.0.
     I downgraded to 4.0.18 and this worked ok.

Besides one PhpWiki flaw which prevents the navbar FindPage to find the 
page "FindPage" with the string "find". Well, it finds it but after the 
redirect to FindPage it doesn't fill the searchstring into the plugin 
forms. Looks correct, but looks bad.
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/