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