Page 1 of 1
search plugin does not work
Posted: Thu Jul 20, 2006 7:32 am
by bibi
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
Posted: Thu Jul 20, 2006 8:08 am
by judebert
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.
Posted: Thu Jul 20, 2006 8:48 am
by bibi
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...
Posted: Thu Jul 20, 2006 12:42 pm
by garvinhicking
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
Posted: Fri Jul 21, 2006 4:08 am
by bibi
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?!
Posted: Fri Jul 21, 2006 10:52 am
by garvinhicking
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
Posted: Sat Jul 22, 2006 5:05 am
by bibi
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