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/
|
