Bug 439223

Summary:	Support small searches in the wiki
Product:	[Retired] Dogtag Certificate System	Reporter:	Bob Lord <blord>
Component:	Wiki	Assignee:	Matthew Harmsen <mharmsen>
Status:	CLOSED NOTABUG	QA Contact:	Chandrasekar Kannan <ckannan>
Severity:	low	Docs Contact:
Priority:	low
Version:	1.0	CC:	benl
Target Milestone:	1.0
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2009-06-15 13:28:25 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	443788

Description Bob Lord 2008-03-27 16:12:14 UTC

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.

Comment 1 Bob Lord 2008-03-27 16:12:40 UTC

There is some info here that might be helpful:
http://meta.wikimedia.org/wiki/Help:Short_words_in_searches

Comment 2 Matthew Harmsen 2008-03-27 22:10:35 UTC

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.

Comment 3 Chandrasekar Kannan 2008-08-27 00:27:36 UTC

Bug already MODIFIED. setting target CS8.0 and marking screened+