+ Reply to Thread
Results 1 to 14 of 14

Thread: Fulltext Search doesn't find words < 4 characters.

  1. #1
    Senior Member Grover is a jewel in the rough Grover is a jewel in the rough Grover is a jewel in the rough Grover is a jewel in the rough Grover's Avatar
    Join Date
    May 2001
    Location
    The Netherlands
    Age
    37
    Posts
    3,998

    Question Fulltext Search doesn't find words < 4 characters.

    Hi,

    I must be forgetting something (learing the beta's for the first time), but how do I set it up so I can search on words with < 4 characters if I use FullText search? I switched my testboard to Fulltext search, but I can't search on words < 4 characters.
    'The UI is so convoluted, in fact, that the top Office feature requests are features that are already in Office...'
    - Paul Thurrott on the Office 2003 user interface.
    -------------------------------------------------------
    See here for a current overview of [User Interface/Style issues] in vBulletin 4.0

  2. #2
    Senior Member TCM is on a distinguished road TCM's Avatar
    Join Date
    Dec 2004
    Location
    Toronto, Ontario, Canada
    Age
    20
    Posts
    477
    I don't belive it's possible. =/

  3. #3
    Senior Member Grover is a jewel in the rough Grover is a jewel in the rough Grover is a jewel in the rough Grover is a jewel in the rough Grover's Avatar
    Join Date
    May 2001
    Location
    The Netherlands
    Age
    37
    Posts
    3,998

    Question Confused.

    It's not possible? Serious? But I had a huge list of 3-character words inside VB 3.0.7 to let my members find these important words despite the 4-character limit. Now I want to use Fulltext Search, which I thought would find ANYTHING, but apparantly I am still stuck with this 4-character limit?

    There's is no way then to include this list of 3-character words on my FullText searches? This is very unfortunate, because I have to switch back to the old system then.....
    'The UI is so convoluted, in fact, that the top Office feature requests are features that are already in Office...'
    - Paul Thurrott on the Office 2003 user interface.
    -------------------------------------------------------
    See here for a current overview of [User Interface/Style issues] in vBulletin 4.0

  4. #4
    Senior Member TCM is on a distinguished road TCM's Avatar
    Join Date
    Dec 2004
    Location
    Toronto, Ontario, Canada
    Age
    20
    Posts
    477
    Quote Originally Posted by Grover
    It's not possible? Serious? But I had a huge list of 3-character words inside VB 3.0.7 to let my members find these important words despite the 4-character limit. Now I want to use Fulltext Search, which I thought would find ANYTHING, but apparantly I am still stuck with this 4-character limit?

    There's is no way then to include this list of 3-character words on my FullText searches? This is very unfortunate, because I have to switch back to the old system then.....
    Well, I'm not 100% sure of this, but yea, as far as I know that's right.

  5. #5
    Senior Member feldon23 is just really nice feldon23 is just really nice feldon23 is just really nice feldon23 is just really nice feldon23's Avatar
    Join Date
    Nov 2001
    Location
    Houston, TX
    Posts
    9,512
    You will have to change the setting in one of MySQL's config files and then restart it.
    vBulletin's chance of redemption is the derivative of the function ƒ as x approaches 0.

  6. #6
    Senior Member Grover is a jewel in the rough Grover is a jewel in the rough Grover is a jewel in the rough Grover is a jewel in the rough Grover's Avatar
    Join Date
    May 2001
    Location
    The Netherlands
    Age
    37
    Posts
    3,998
    Quote Originally Posted by feldon23
    You will have to change the setting in one of MySQL's config files and then restart it.
    Right... I am on a shared server, like most people I guess, so I have no access to MySQL whatsoever. Do you know it's configured at minimum 4 characters by default? I guess so?

    What do I do if I have no access to these settings and want to use Full Text Search and want to include those 3-character words I listed in my former Normal VB Search?
    'The UI is so convoluted, in fact, that the top Office feature requests are features that are already in Office...'
    - Paul Thurrott on the Office 2003 user interface.
    -------------------------------------------------------
    See here for a current overview of [User Interface/Style issues] in vBulletin 4.0

  7. #7
    vBulletin Developer Freddie Bingham is just really nice Freddie Bingham is just really nice Freddie Bingham is just really nice Freddie Bingham is just really nice Freddie Bingham is just really nice Freddie Bingham's Avatar
    Join Date
    May 2000
    Location
    California
    Age
    36
    Posts
    13,962
    Blog Entries
    16
    http://dev.mysql.com/doc/mysql/en/fu...ne-tuning.html

    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). See Section 5.3.3, “Server System Variables”. 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 need to edit my.cnf (or my.ini on Windows systems) and 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.
    Last edited by Steve Machol; Thu 23rd Aug '07 at 2:52pm. Reason: added the name of the file to edit
    vBulletin Developer since Dec 2000

  8. #8
    Senior Member feldon23 is just really nice feldon23 is just really nice feldon23 is just really nice feldon23 is just really nice feldon23's Avatar
    Join Date
    Nov 2001
    Location
    Houston, TX
    Posts
    9,512
    Quote Originally Posted by Grover
    What do I do if I have no access to these settings and want to use Full Text Search and want to include those 3-character words I listed in my former Normal VB Search?
    You've just described the impossible scenario.
    vBulletin's chance of redemption is the derivative of the function ƒ as x approaches 0.

  9. #9
    Customer Support Manager Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol is a splendid one to behold Steve Machol's Avatar
    Join Date
    Jul 2000
    Location
    Jelsoft InterGalactic HQ
    Posts
    143,005
    Added Freddie's post to my knowledgebase.
    Steve Machol, vBulletin Customer Support Manager
    "Have Copy, Will Paste" (when appropriate)

    Please do not email or PM me for vBulletin support. I will be more than glad to answer your questions on the vB Forums and in the support system.

    Just remember that what happens in localhost, stays in localhost.


  10. #10
    Senior Member Grover is a jewel in the rough Grover is a jewel in the rough Grover is a jewel in the rough Grover is a jewel in the rough Grover's Avatar
    Join Date
    May 2001
    Location
    The Netherlands
    Age
    37
    Posts
    3,998
    Quote Originally Posted by feldon23
    You've just described the impossible scenario.
    Haha, this sentence made me laugh!
    'The UI is so convoluted, in fact, that the top Office feature requests are features that are already in Office...'
    - Paul Thurrott on the Office 2003 user interface.
    -------------------------------------------------------
    See here for a current overview of [User Interface/Style issues] in vBulletin 4.0

  11. #11
    Quote Originally Posted by Freddie Bingham
    Mysql docs say to rebuild the FULLTEXT indexes after reducing the char count. It says to do this...

    mysql> REPAIR TABLE tbl_name QUICK;

    do we need to, and if so, which table?

  12. #12
    vBulletin Team Marco van Herwaarden is on a distinguished road Marco van Herwaarden's Avatar
    Join Date
    Nov 2004
    Location
    NL
    Age
    45
    Posts
    7,063
    Out of my head this would only be the post & thread tables.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

  13. #13
    Quote Originally Posted by MarcoH64
    Out of my head this would only be the post & thread tables.
    I really think the fulltext stuff should be documented better...especially considering 90% of vb admns will want to make the conversion.

  14. #14
    vBulletin Team Wayne Luke is a name known to all Wayne Luke is a name known to all Wayne Luke is a name known to all Wayne Luke is a name known to all Wayne Luke is a name known to all Wayne Luke is a name known to all Wayne Luke's Avatar
    Join Date
    Aug 2000
    Location
    So. California
    Age
    39
    Posts
    35,146
    Blog Entries
    1
    Quote Originally Posted by Milez
    I really think the fulltext stuff should be documented better...especially considering 90% of vb admns will want to make the conversion.
    It is documented quite well in the MySQL Online Documentation.

    I have added Freddie's information above to the manual entry on Search Type and included the link to the MySQL documentation.
    Wayne Luke
    Get started with your own social network.
    Purchase and download vBulletin today.
    vBCodex (Running vB 4.0 Suite) - Take your vBulletin Community to the next level. Modification tips, tricks and support.

+ Reply to Thread

Similar Threads

  1. vbulletin search engine vs mysql fulltext search?
    By fiNal in forum vBulletin 3.5 'How Do I' Questions and Troubleshooting
    Replies: 7
    Last Post: Mon 24th Oct '05, 1:27pm
  2. Fulltext Search
    By hankster in forum vBulletin 3.0 How Do I and Troubleshooting Forum
    Replies: 1
    Last Post: Fri 7th Jan '05, 2:52pm
  3. search index tables and fulltext search stuff
    By merk in forum vBulletin 3.0 How Do I and Troubleshooting Forum
    Replies: 3
    Last Post: Sat 21st Jun '03, 12:05pm
  4. Allow different minumum characters in search for different types of characters
    By UHN_ED in forum vBulletin Suggestions and Feedback
    Replies: 1
    Last Post: Mon 7th Apr '03, 7:42pm

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts