Builders Collective

Bug Tracker

    Use this thread to post any bugs you find on this forum.

    Known Issues

    • Search does not work

      I spent some time trying to figure out the search functionality and learned some things about MySQL’s MATCH function. It looks like the reason the search functionality wasn’t working for me was that I didn’t have enough posts to produce a relevance ranking with the MATCH function. According to the book, MySQL by Paul DuBois:

      MATCH produces a relevance ranking for each row. Ranks are non-negative floating-point numbers, with a rank of zero indicating that the search words were not found. Positive values indicate that at least one search word was found. Words that are present in more than half the rows of the table are considered to have zero relevance because they are so common.

      So, I didn’t have enough posts for the MATCH function to consider the content relevant. The other issue is that search function does not find matching words in the title of the thread. It is looking only for matching words in the content. I’ll look into extending this, if I can.