Jump to:

23478 Posts in 18941 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » Search does not find 3 letter words

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 1615 Views
  • purplespider
    Avatar
    Community Member
    81 Posts

    Search does not find 3 letter words Link to this post

    I'm using the standard SilverStripe search, but it does not find any 3 letter words, is there anyway to change this limit?

    Thanks
    James

  • neilcreagh
    Avatar
    Community Member
    94 Posts

    Re: Search does not find 3 letter words Link to this post

    Anyone got any ideas about this? I need the search results to throw back results for two letter searches (products are known as 'V3' or 'V4' etc.).
    ?? Running 2.4.2

  • swaiba
    Avatar
    Forum Moderator
    1792 Posts

    Re: Search does not find 3 letter words Link to this post

    I just tried this (a couple of 2.4.0 sites) and there were some strange results... I got results for 'on' or 'to' and get page results, but not '4u'... I tried with with single/double quotes and without.

  • purplespider
    Avatar
    Community Member
    81 Posts

    Re: Search does not find 3 letter words Link to this post

    I did manage to fix this. It's not a limitation of SilverStripe, it's actually due to a default setting of MySQL.

    You need to change the "ft_min_word_len" MySQL variable on the server. The default is 4, changing it to 3 will allow 3 letter searches to work etc.

    James

  • borriej
    Avatar
    Community Member
    267 Posts

    Re: Search does not find 3 letter words Link to this post

    how do you change the mysql setting?
    Through htaccess?
    Im not hosting my own server, but in the Netherlands we usually pay for hosting on a shared server.

    1615 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.