3 letters search, work or not?

[ipbfuck]

Hi!

i've some article with "pdf" in tags, but i cannot found by search. if im not in error, 3 letter search is fixed in latest release, but continue to not work for me...

no result: https://laltroweb.it/search/?&q=pdf

found result in tags: https://laltroweb.it/search/?&tags=pdf

is this as expected?

[Nathan Explosion]

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?

[ipbfuck]

I don't have touch never 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!

[Nathan Explosion]

8 minutes ago, laltroweb.it said:

I don't have touch never 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

 

[ipbfuck]

Ok, thank'u!

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

[Nathan Explosion]

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.

 

[ipbfuck]

> 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

 

[Lenny Warren]

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?

[Nathan Explosion]

You would do that from the ACP.

[Lenny Warren]

Cheers @Nathan Explosion, done it and all working fine..