Jump to content

3 letters search, work or not?

ipbfuck
ipbfuck
in Technical Problems

Featured Replies

Have you configured mySQL to allow 3 letter search strings?

After doing so, have you restarted mySQL?

After doing that, have you rebuilt your IPS search index?

  • Author

I don't have touch never :p xD

... but, why this work on tags and not on standard search?

 

now i search info with mysql 3letter search etc! thanks for reply ^_^

-

edit: ok, seems to be related with fulltext search index database, and - if im not in error - this is possible only with mysql 5.6+ (atm i've 5.5.*).

Then, i cannot enable, ok!

8 minutes ago, laltroweb.it said:

I don't have touch never :p xD

... but, why this work on tags and not on standard search?

 

now i search info with mysql 3letter search etc! thanks for reply ^_^

-

edit: ok, seems to be related with fulltext search index database, and - if im not in error - this is possible only with mysql 5.6+ (atm i've 5.5.*).

Then, i cannot enable, ok!

Why works on tags? Because it doesn't use Full text search, while standard search does (which you've probably already figured out)

And you are in error...the setting has been around for quite a while, and is not a 5.6 specific setting.

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_ft_min_word_len

 

  • Author

Ok, thank'u!

so, magic question, how i can enable (hosting with cpanel - no access to php.ini etc)? ^_^

Access to php.ini isn't needed as it's a mySQL setting, not PHP ;)

Look into your options in your panel to do with mysql configuration (google will be your friend, most likely) or ask your host for further assistance.

 

  • Author

> i've found ft_min_word_len=3 in my.cnf > repair table > rebuild search index

but i don't have any way to access to my.cnf file (then, yes, i need to ask to my hosting provider)!

 

> thanks for reply,

regards ^_^

 

  • 3 weeks later...
On 10/04/2016 at 11:19 AM, Nathan Explosion said:

Have you configured mySQL to allow 3 letter search strings?

After doing so, have you restarted mySQL?

After doing that, have you rebuilt your IPS search index?

Thanks for that, have asked my host to do this. Do they need to rebuild the IPS search index or do I need to do that from ACP?

You would do that from the ACP.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Recently Browsing 0

  • No registered users viewing this page.