search plugin does not work

bibi · Post by **bibi** » Thu Jul 20, 2006 7:32 am

Hi Forum, thanks for the great software Garvin,

but nevertheless I´ve got problems with this plugin. Maybe I´m stupid. Sometimes the search engine finds a word another time not. Do I have to index somewhere?
Maybe one of you can help me!!!

THANKS @ all

judebert · Post by **judebert** » Thu Jul 20, 2006 8:08 am

It just uses the SQL fulltext search, so should always find (or not) the same word. Sometimes you have to enter a few entries before it starts working. And it usually only searches the entries, not the users' comments, unless you've installed a plugin.

Could you be a bit more specific? Perhaps with a link we could check it out ourselves, too.

bibi · Post by **bibi** » Thu Jul 20, 2006 8:48 am

Thanks judebert for your very fast answer!

I think it works now. But the engine can´t find some words in the entries. That´s why I thougt it does not work. But why some words and others not??????

But maybe you´re right and I need some more articles...

Post by **garvinhicking** » Thu Jul 20, 2006 12:42 pm

Hi!

That would depend on the word you search for and maybe the way/amount of your entries. What word are you searching for, and what is your URL?

MySQL regards a keyword as "bad" if it occurs more than a specific threshold of coverage. If ever 2nd word you type is "google", then mysql will blacklist "google" because it would return every entry then.

Best regards,
Garvin

bibi · Post by **bibi** » Fri Jul 21, 2006 4:08 am

Hi Garvin and thank you,

can I see the blacklist on MySql Database? The word I´m searching for you can find in mostly every entry. But I couldn´t find this word since installation. (that means, no coverage since the first time). The engine works good but the most important keywords (85% of the entries) don´t occure

Maybe there is a way to delete this wicked blacklist on MySql?!

Post by **garvinhicking** » Fri Jul 21, 2006 10:52 am

Hi!

The default stopwords of MySQL are:

http://dev.mysql.com/tech-resources/art ... ealed.html

And the rest of the blacklisting depends on the words you use in your article. For some people it can be "google" for others "serendipity". That always depends on the amount of keyword usage/coverage.

If you say the word you search for can be found in every entry, then exactly this blacklisting works.

Think about it in terms of MySQL: If a keyword is found in every article, is it really a keyword? Your visitors could then read every article, they would not need to search for it.

Best regards,
Garvin

bibi · Post by **bibi** » Sat Jul 22, 2006 5:05 am

You´re totally right Garvin!

If this word occurs in all entries, it won´t be necessary to search for...

Sometimes I´ve to think before posting...

Best wishes
bibi