Red Hat Bugzilla – Bug 439223
Support small searches in the wiki
Last modified: 2015-01-04 18:31:25 EST
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: http://meta.wikimedia.org/wiki/Help:Short_words_in_searches
Following the instructions above was insufficient, as the "php rebuildtextindex.php" command yielded an error that required creating the file "/var/www/html/wiki/AdminSettings.php". Unfortunately, this was still insufficient, as when executed by the root user, it generated the following error: Content-type: text/html X-Powered-By: PHP/4.3.9 Dropping index... A database error has occurred Query: ALTER TABLE `searchindex` DROP INDEX si_title, DROP INDEX si_text Function: dropTextIndex Error: 1044 Access denied for user 'wikiuser'@'localhost' to database 'wikidb' (localhost) Backtrace: 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+