Hi guys,

I’m implementing fulltext search for my company’s forums site which is based on bbPress 2 (plugin version 2.2.4). I think I should start with the wp_posts_fulltext_search table (MYISAM engine) that’s intended by WordPress for fulltext search. However, this table is not updated whenever a bbPress forum topic/reply is created/updated/deleted. How should I handle this problem?

[@netweb Keymaster 11 years, 8 months ago]

Search is built into bbPress 2.3

GGive it a try if you want https://bbpress.org/blog/2013/03/bbpress-2-3-release-candidate-1/ 🙂

[@stevendo Participant 11 years, 8 months ago]

Thanks Stephen.

For the bbPress 2.3 search feature, my question is whether it supports fulltext search and how it creates fulltext index. I also need to filter the search results by user-selected parent forums which should require a custom query.

[@stevendo Participant 11 years, 8 months ago]

After digging into the source code of search, I found that it uses SQL’s LIKE for searching. So…no fulltext search.

I searched on the Web and it looks like Sphinx can give me a solution, though it requires extra setup and configuration. MySQL 5.6.4 will add supports of fulltext search for InnoDB as well.

[@stevendo Participant 11 years, 8 months ago]

Well, finally it turned out to me that the wp_posts_fulltext_search table was a custom table that the former dev of the site added (not a WordPress native). 🙂 I’m good to go now.