[Mediawiki-l] Adding fields to searchindex

Michele Ong nekopan at gmail.com
Sat Aug 27 15:39:03 UTC 2005


Hi all,

I've been given the task to modify an install of mediawiki so that it
has an article summary field (cur_brief) in addition to its cur_id and
cur_text fields.  cur_brief is a tinyblob which also needs to be made
fulltext searchable.  The cur table has been modified to include this
new field, but I've been having some trouble with getting the
searchindex table to include it as well for wiki searches.

What I've tried:

- Manually adding si_brief to the searchindex table and modifying the
scripts in the maintenance directory to include references to si_brief
wherever there are mentions of si_text
- Modifying the SearchMySQL4 (and related files) to include a search
for the brief field.

When I manually add data into the si_brief field, the search works
quite happily. But, I think my changes may have inadvertently caused
the wiki to stop updating the searchindex table.

Someone mentioned to me that it is possible that MySQL may maintain
the tables with the replicated data by itself but I was unable to
determine if this was the case.  I've looked at the MySQL docs for the
MyISAM and InnoDB types to see if it would help, but I'm still not
sure of what I'm looking for.

If someone could point me in the right direction to add another
fulltext field to the search, that'd be great.

Thanks,
shay



More information about the MediaWiki-l mailing list