Bug 439223 - Support small searches in the wiki
Summary: Support small searches in the wiki
Alias: None
Product: Dogtag Certificate System
Classification: Retired
Component: Wiki
Version: 1.0
Hardware: All
OS: Linux
Target Milestone: 1.0
Assignee: Matthew Harmsen
QA Contact: Chandrasekar Kannan
Depends On:
Blocks: 443788
TreeView+ depends on / blocked
Reported: 2008-03-27 16:12 UTC by Bob Lord
Modified: 2015-01-04 23:31 UTC (History)
1 user (show)

Clone Of:
Last Closed: 2009-06-15 13:28:25 UTC

Attachments (Terms of Use)

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:

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'

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+

Note You need to log in before you can comment on or make changes to this bug.