Category browser error problem
- MediaWiki 1.18.2
- PHP 5.2.17 (cgi-fcgi)
- MySQL 5.5.19-55
I have a four wiki farm. All four are running the same versions as above. I'm pretty sure all have the same version of CategoryBroswer installed. Below is the LocalSettings.php config's at all wiki's.
/* CategoryBrowser */ require_once("$IP/extensions/CategoryBrowser/CategoryBrowser.php"); CB_Setup::$categoriesLimit = 30; CB_Setup::$pagesLimit = 30; CB_Setup::$filesMaxRows = 2; CB_Setup::$imageGalleryPerRow = 5; CB_Setup::$allowNestedParents = false; CB_Setup::$allowNoParentsOnly = true;
Here is a ScreenShot example of two wiki's I'm not having problems with. (link to that wiki's CategoryBrowser page) On the last two this ScreenShot is of the error if the Case insensitive check box (which is checked by default) is left checked for a query of "S" Categories. Here is the same query if the Case insensitive check box is un-checked prior to query ScreenShot (link to that wiki's CategoryBrowser page). The maintenance script the error mentions has been run. Does anyone know of a fix or how to change the Case insensitive check box to un-checked by default ?
I posted there just before here, thanx (very slow discussion page) hence this post also.
Note, this is not an issue with not running the update.php script (We say that on all db errors, because 99% of the time that's what the problem is).
This appears to be a bug in the extension (Using COLLATE sql command in cases where the default collation of the db table is not compatible).