KB Search broken

[GezusK]

Script URL:
Version of script: 2.0
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

We've been using .94, but recently set up 2.0. We didn't do an upgrade, since we made a few changes. We can't get the KB search to work. It return 0 results everytime. We haven't made any changes to knowledgebase.php file. Is there another file in which we could have broke the search?

We also did a fresh install, with a new database, and it still wouldn't work. No modifications have been done to that one. Its using PHP 5. We've also tried entering the query from the KB.php into phpmyadmin, with 0 results returned again.

[GezusK]

It looks to not be totally broken, just inconsistent. Some terms return results, some don't. For instance, I have an two articles that mention Helpdesk, but searching for Helpdesk doesn't return anything.

[Klemen]

That's probably a MySQL fulltext search issue - any words that occur in 50% or more database entries (articles) are not used as keywords.

In other words: try adding more articles with different subjects (let's say at least 10 different articles to the knowledgebase) and see if that works. You can try by adding simple "test", "this is a test", ... articles.

[GezusK]

Ok, that explains some of the problem. Is there a word length filter too?

For instance, I had two articles, one of them had the word 'employees' in the title. When it was just those articles, search for 'employees' wouldn't work. But when I added a third article, it would then work. In the third article, I added some random words, such as cat, dog, mouse, moose. Search for mouse or moose worked, but not for cat and dog.

I tried adding a search script that I found on the net, which would break down a search to the individual words in it, and then search for each word, and highlighting the words in the results. But I don't understand php enough to get it to work with hesk.

I guess as I add articles, then some of the problems will clear up.

[Klemen]

For instance, I had two articles, one of them had the word 'employees' in the title. When it was just those articles, search for 'employees' wouldn't work. But when I added a third article, it would then work. In the third article, I added some random words, such as cat, dog, mouse, moose. Search for mouse or moose worked, but not for cat and dog.

That's exactly what I am trying to tell you... It's how MySQL search works. If you have a word in 50% (or more) articles it will not be found. So if you have word "employees" in 1 out of 2 articles that's 50%, but when you add a third article this word is only in 1 out of 3 articles (less than 50%) so it works.