Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID Sign In with Twitter
Sign In Apply for Membership

Categories

In this Discussion

Who's Online 17

CurtisOdenSpencerMcTorbjornjohansonlocker +13 guests

Search Does not Work!

jabermjaberm
in Questions
Hi All,

I have installed a fresh version of vanilla to experience with. I have posted a number of test topics with words like (test, testing, etc).

Now when I search the forum for some of those words using the search area in the header, I get zero results. Although I am certain those words exist in the title and body of multiple posts.

Why is that?

Regards.
Tagged:

Comments

  • lucluc
    Posts: 1,015
    It's the way Full Text Search from mysql works.
  • jabermjaberm
    Posts: 23
    luc said:

    It's the way Full Text Search from mysql works.

    I didn't understand. Please explain further.
  • lucluc
    Posts: 1,015 Accepted Answer
    v2 uses Full Text Search to search the mysql database, those "shortcomings" are from the underlying system used.

    Site with not much content is not proper for search by this.

    Source:
    According to the MySQL manual, Full-text is a “natural language search”; it indexes words that appear to represent the row, using the columns you specified. As an example, if all your rows contain “MySQL” then “MySQL” won’t match much. It’s not terribly unique, and it would return too many results. However, if “MySQL” were present in only 5% of the rows, it would return those rows because it doesn’t appear too often to be known as a keyword that’s very common. (If you have “MySQL” in none of your rows, it’ll return nothing; duh.)

    MySQL also does something pretty useful. It creates a score. This score is usually something like .9823475 or .124874, but always larger than zero. It can range up above 1, and I have seen it at 4 sometimes. (Don’t try to multiply it by 100 and portray it as a % value; people will wonder why their keyword matches an article 431%!)
  • boyzforumboyzforum
    Posts: 17
    This is happening to me too. I don't think it's a problem with too little content since I have imported a huge existing forum from phpbb. So I'm not sure it's "because of the way mysql works".
    Do you think my index could be defective for some reason?
  • TimTim
    Posts: 1,573
    boyzforum said:

    This is happening to me too. I don't think it's a problem with too little content since I have imported a huge existing forum from phpbb. So I'm not sure it's "because of the way mysql works".
    Do you think my index could be defective for some reason?

    I'll get it working for you.

    Vanilla Forums Senior Developer [GitHub, Twitter, About.me]

  • TimTim
    Posts: 1,573
    Should be fixed now, @boyzforum - let me know if you notice an improvement ;)

    Vanilla Forums Senior Developer [GitHub, Twitter, About.me]

  • boyzforumboyzforum
    Posts: 17
    Will do. Thanks
Sign In or Register to comment.