Overunity.com Archives

Discussion board help and admin topics => Help to access this discussion board => Topic started by: molux on May 14, 2007, 10:02:38 AM

Title: Search Engine Probleme
Post by: molux on May 14, 2007, 10:02:38 AM
Hy,

I have ? probleme to the forum search engine, i search Mintaka under this forum, and it doesn't find any port !
I manually search this theme, and i find it here:
http://www.overunity.com/index.php/topic,1754.0.html

Mintaka is spelled, (under url for exemple)

Why the search engine don't find it ?

It's not easy to find data under forum without this tools, can you do something ?

Molux
Title: Re: Search Engine Probleme
Post by: Paul-R on May 14, 2007, 10:12:52 AM
There is a difference between "minataka" and "mintakafulcrum".
With some engines, minataka* would find mintaka and anything
else tacked on the end, but Google doesn't do it.
Paul.
Title: Re: Search Engine Probleme
Post by: molux on May 14, 2007, 12:44:15 PM
Hello Paul-R,

I dont use google, i use the internal search engine, (look screenshot) and normaly (like phpBB, or other) find the part information naturally.

I try this:
mintaka
mintaka%
mintaka*
and nothing

(And it's a mistake, google fortunately find a part data...)

I think it simple to add this fonctionality to the serach engine with MySQL helper
(Or perhaps is a MySQL version Bugg's ? or Php.ini with an heuristic Magic Quot param ?) For me it's a bug, and it's not so easy to find if an information already poster under the forum. what all other forum can do that ?

A++

Molux

Title: Re: Search Engine Probleme
Post by: hartiberlin on July 29, 2007, 11:21:06 PM
When I have more time I will try to see,if I can change some caching for
the search.
This will increase the database very much, but you are correct,
it needs a bit of a tweak to find something like this...

Try in the meantime also the google search at the top of the forum page.
Title: Re: Search Engine Probleme
Post by: molux on July 30, 2007, 04:29:04 AM
Hy Harti,

Thanks if you can do that, perhaps you can use/modify the finding SQL request to support the syntaxe of LIKE:

Exemple:

"SELECT .... WHERE post_title LIKE '%$keyword%' OR post_content LIKE '%$keyword%'...."

You have to filter $keyword to dont have som SQL injection
You can simple dont accept some special caracteres (used into SQL syntaxe) like " , ', =, LIKE, IN, %

Thanks for you great job Harti

Molux