Ducati Monster Forum

Kitchen Sink => Board Tech Issues => Fixed Board Issues => Topic started by: Spidey on December 15, 2008, 03:08:00 PM

Title: Search function is wonky
Post by: Spidey on December 15, 2008, 03:08:00 PM
Every coupla days, the search function pitches a fit.  Sometimes I get results that have nothing to do with the words I searched.  Most commonly, it'll just give me recent posts that have none of the search keywords in them.   Today was a bit different.  I was searching for "most recent results" and it returned searches with the keywords, but in no discernible order.  And it only gave me three threads when there should have been pages.

I was talking with a few people who lurk on the DMF and they universally said that they don't trust the search function to give them proper results.  Is there something going on?
Title: Re: Search function is wonky
Post by: ducpainter on December 15, 2008, 03:46:50 PM
Can't answer your question.

I've never found the search function in SMF to be very reliable...ever.

Now that we have things running fairly smoothly I'm afraid to mess with it much.

Next time it happens try to get a screenshot.
Title: Re: Search function is wonky
Post by: Spidey on December 15, 2008, 03:49:29 PM
Will do.  Even if my search term is--as usual--"ducati lesbian midget porn".      [moto]
Title: Re: Search function is wonky
Post by: ducpainter on December 15, 2008, 03:51:46 PM
and besides...

it gives people too lazy to search an excuse. ;D
Title: Re: Search function is wonky
Post by: darylbowden on December 21, 2008, 12:14:09 AM
It's because SMF search uses a MySQL search term called "%LIKE%."  However, this can lead to some strange results sometimes as it  can grab words that exist in other words and return those for you.  So if you search "ducati" it will also bring back "education" and so on.  If you're interested in the way this works, you can read more here http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html

Really, it just comes down to the SMF folks not caring a whole hell of a lot about the search algorithm...