Description of problem:
When you search for words in the wiki that are 3 characters long (like "nss",
"pki") the wiki returns no hits.
I'd like to have the search engine return results for 3-character terms.
There is some info here that might be helpful:
Following the instructions above was insufficient, as the
"php rebuildtextindex.php" command yielded an error that required creating the
Unfortunately, this was still insufficient, as when executed by the root user,
it generated the following error:
A database error has occurred
Query: ALTER TABLE `searchindex` DROP INDEX si_title, DROP INDEX si_text
Error: 1044 Access denied for user 'wikiuser'@'localhost' to database 'wikidb'
GlobalFunctions.php line 602 calls wfbacktrace()
Database.php line 473 calls wfdebugdiebacktrace()
Database.php line 419 calls database::reportqueryerror()
rebuildtextindex.inc line 24 calls database::query()
rebuildtextindex.php line 18 calls droptextindex()
After digging through some of the associated documentation, I was able to run
the following commands "as root":
mysql> USE wikidb;
mysql> REPAIR TABLE searchindex QUICK;
mysql> REPAIR TABLE user_newtalk QUICK;
Basically, after this, three-letter searches appear to now work.
Bug already MODIFIED. setting target CS8.0 and marking screened+