Skip to:
Content
Pages
Categories
Search
Top
Bottom

bbPress2 fulltext search

  • @stevendo

    Participant

    11 years, 8 months ago

    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?

Viewing 4 replies - 1 through 4 (of 4 total)

  • @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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.

Topic Info

Skip to toolbar