Misses short words

Kezz - April 21, 2005 - 09:52
Project:SQL Search (Trip Search)
Version:4.7.x-1.x-dev
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Kezz
Status:closed
Description

Hi
Is there any way to get trip_search to recognize shorter words?
It seems to cut off at 3 letters or less - we'd like to set this at 2 letters.
We have a tourist guide at http://copenhagen.expozed.net and certain short words, like 'bar' 'bus' or 'map' are important to our visitors, so we'd like them indexed.

thx in advance for any help on this one :)

#1

moshe weitzman - May 5, 2005 - 20:38

there is no minimum. works for me with 1 letter.

#2

Kezz - May 16, 2005 - 16:09

Nope sorry - still get no results on words with 3 letters or less.
Try it for yourself at Copenhagen Expozed.
I'd love to know why this behaves differently on different sites though - we just installed it 'as is'
Getting curious now ;)

#3

chrysfwi - April 23, 2007 - 16:20
Version:4.5.x-1.x-dev» 4.7.x-1.x-dev
Status:closed» active

Hi Kezz,
I have exactly the same issue. Working with Drupal 4.7. I need a 3 letters search working.
I have noticed that it works perfectly on your site. Congratulations! It is true that Trip Search is a fantastic module.
How did you fix that finally?
I know that this is an old post but thank you in advance for your answer.

#4

joel_guesclin - April 24, 2007 - 10:44

Actually this is to do with your MySQL settings. SQL Search relies on the MySQL Fulltext indexing system, and by default MySQL does not index words shorter than 4 characters. It is possible to change this to index shorter words (though I would be dubious about going down to one-word lengths). You can find the details of how to do this in the MySQL documentation, alternatively if you are using a hosting service you will probably have to ask your provider to do this.

#5

chrysfwi - April 24, 2007 - 15:46
Status:active» closed

Thank you very much for your so prompt and efficient answer.
I will get into the mysql configuration and try to finetune this issue.
Thanks for the direct mysql documentation link. I appreciate your time.
Congratulations again for your module ;-)

 
 

Drupal is a registered trademark of Dries Buytaert.