wet_haystack: Custom fulltext search index builder for Textpattern

29. November 2008

Textpattern’s full text index uses the articles’ body and title contents to find proper matches for site-internal searches.

wet_haystack is a plugin for Textpattern CMS which allows site publishers to modify this default behaviour by adding additional article fields to the set of indexed content.


Just adhere to Textpattern’s common plugin installation procedure. No modification of your page templates or any other parts of the site required.


  • This plugin is intended for Textpattern 4.2.0+. It will not work with earlier versions.
  • You need to acquire publisher privileges to change a site’s fulltext search settings with this plugin.
  • This plugin modifies your site’s database, so you are well advised to have a backup at hand in case something goes awry.
  • wet_haystack does not work with MLP.

Building a custom fulltext index

  • Go to the “Admin > Plugins” tab.
  • Navigate to wet_haystack’s options panel.
  • Check all article fields you want to include in the full text index.
  • Hit “Save” and wait for the database to re-index you current site’s content. Depending on the number and length of your articles, this may take a while.

wet_haystack screenshot

wet_haystack needs not be kept installed once the custom fulltext index has been created.

Removing an obsolete custom fulltext index

wet_haystack needs one additional database index for its operation, which it continues to use as long as you modify Textpattern’s default fulltext index settings. This custom fulltext index will be deleted when the customised setting matches Textpattern’s default setting (i.e. “Title” and “Body” are the solely checked columns).


Get it here: wet_haystack.txt.

Resources and Relateds

Express your suggestions, report bugs and discuss enhancements in this thread in the Textpattern forum.

Change log

Date Version Notes
2008-11-29 0.3 Initial public release
2008-11-30 0.4 MySQL 4.x compatibility
2008-12-01 0.5 Fixed typo
2009-09-16 0.6 Textpattern 4.2.0 compatibility: preferences panel, support for unlimited custom fields