Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

ft_min_word_len

Discussion in 'Database Discussions' started by keat63, Mar 28, 2017.

  1. keat63

    keat63 Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    885
    Likes Received:
    26
    Trophy Points:
    28
    cPanel Access Level:
    Root Administrator
    When I set word_len to 2 in my.cnf, after restarting MYSQL, I see the following error.

    170328 12:41:32 [ERROR] /usr/sbin/mysqld: unknown variable 'set-variable=ft_min_word_len=2'

    Any ideas what I'm doing wrong ?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you let us know the specific entry you added to your /etc/my.cnf file? There's a StackOverflow thread on this topic at:

    ft_min_word_len set in local my.cnf?

    Thank you.
     
  3. keat63

    keat63 Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    885
    Likes Received:
    26
    Trophy Points:
    28
    cPanel Access Level:
    Root Administrator
    I tried 'set-variable=ft_min_word_len=2' and 'ft_min_word_len=2', both of which produced similar errors.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you verify which version of MySQL is installed on the system?

    Thank you.
     
  5. keat63

    keat63 Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    885
    Likes Received:
    26
    Trophy Points:
    28
    cPanel Access Level:
    Root Administrator
    Does 5.5.54 mean anything.
    Incidentally since trying 'ft_min_word_len = 2' ie a space between =, I don't see those errors.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    That value (with the space) matches what's referenced at:

    ft_min_word_len set in local my.cnf?

    Ensure to review the top answer on that URL now that the entry is working well.

    Thank you.
     

Share This Page