Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 12 Jun 2010, 00:08
pant pant is offline
 
Join Date: Mar 2010
sphinx search and 3 character search

Currently on a shared hosting package.

Need to be able to search 3 characters in search ie "the YNC", I contacted the host and they said 'no can do'. Is it possible that if I use sphinx search I will be able to get this functionality?

Pro's and con's?
Reply With Quote
Comments
  #2  
Old 12 Jun 2010, 04:45
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
You would set the min word length in the sphinx.conf file, I believe. However, if you don't have access to change your my.cnf file, then it's unlikely you are going to be able to install sphinx on your server. You need a dedicated server that you have shell access to in order to install sphinx.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 12 Jun 2010, 09:38
pant pant is offline
 
Join Date: Mar 2010
Poo
Reply With Quote
  #4  
Old 13 Jun 2010, 14:06
we_are_borg we_are_borg is offline
 
Join Date: Aug 2004
When you want to search on characters smaller then 4 (3 and lower is excluded) then you need to use the "Words to be Included Despite Character Limit" this can be found in Settings>Options>Message Searching Options (vBulletin Internal Search) then add the words smaller then 4 in the box "Words to be Included Despite Character Limit". This way you can maintain the settings of search and still search for less then 4 characters.

The Sphinx addon you need at least SSH login and the ability to install on the server. This is usually not the case with normal web hosting, you need VPN hosting or VZ hosting to do that and even then you need to read what is allowed and what you may do with it.
Reply With Quote
  #5  
Old 13 Jun 2010, 14:19
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Actually, the Message Searching Options is only to be used when using vBulletin Internal Search which is not an option in vB4. vB4 uses Full Text Search and the only way to change the min word length is by changing the mysql variable in my.cnf.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 13 Jun 2010, 15:39
we_are_borg we_are_borg is offline
 
Join Date: Aug 2004
Why is that information given in another screen and not where you input the 3 chars it self a bit strange not to warn there.

Last edited by we_are_borg; 13 Jun 2010 at 15:42. Reason: Miss read option info
Reply With Quote
  #7  
Old 13 Jun 2010, 17:46
pant pant is offline
 
Join Date: Mar 2010
What was wrong with the DB search of the 3.8 series?
Reply With Quote
  #8  
Old 13 Jun 2010, 23:16
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by we_are_borg View Post
Why is that information given in another screen and not where you input the 3 chars it self a bit strange not to warn there.
It says it's for the Internal vBulletin Search. And if you check your search type under Settings > Search Type, it won't say Internal vBulletin Search. That being said, I have questioned why it is even shown now at all in vB4.
Originally Posted by pant View Post
What was wrong with the DB search of the 3.8 series?
It doesn't allow for the contenttype search that they now do.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #9  
Old 14 Jun 2010, 00:16
we_are_borg we_are_borg is offline
 
Join Date: Aug 2004
Originally Posted by Lynne View Post
It says it's for the Internal vBulletin Search. And if you check your search type under Settings > Search Type, it won't say Internal vBulletin Search. That being said, I have questioned why it is even shown now at all in vB4.

It doesn't allow for the contenttype search that they now do.
You mean the option on the "Message Searching Options (vBulletin Internal Search)" to put in 3 letter words. Now that you say that i wonder myself if you change the my.cnf file you can search 3 letter words so why maintain that option, thats a realy good one.
Reply With Quote
  #10  
Old 14 Jun 2010, 07:04
pant pant is offline
 
Join Date: Mar 2010
Is there even any documentation to that effect?
Reply With Quote
  #11  
Old 14 Jun 2010, 15:36
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
What sort of documentation? There is stuff in the manual telling you what to change:
Note:
The minimum and maximum length of words to be indexed is defined by the ft_min_word_len and ft_max_word_len system variables (available as of MySQL 4.0.0). The default minimum value is four characters. The default maximum depends on your version of MySQL. If you change either value, you must rebuild your FULLTEXT indexes. For example, if you want three-character words to be searchable, you can set the ft_min_word_len variable by putting the following lines in an option file:

[mysqld]
ft_min_word_len=3

Then restart the server and rebuild your FULLTEXT indexes. Also note particularly the remarks regarding myisamchk in the instructions following this list.

For more on Fulltext Search from MySQL please visit:
http://dev.mysql.com/doc/refman/5.0/...ne-tuning.html
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 03:15.

Layout Options | Width: Wide Color: