Piwigo.org

mcl · 2012-12-11 13:39:27

I need QuickSearch to search for a minimum of three characters in Album, Title and Description and Photo, Title and Description, but it does not seem to search for less than four characters.

Is it possible to change this behaviour to three characters.

It searches tags and original filenames for three characters.

Remember this is piwigo.com, so I can not make any php changes myself only css.

Thanks

mcl

plg · 2012-12-11 14:52:30

(to anybody replying to mcl, please don't say "ask Piwigo.com", because I have told mcl to come here for this question, which is not related to Piwigo.com at all ;-)

rvelices · 2012-12-11 16:11:28

the quick search uses the mysql full text engine which by default ignores any full text term of less than three characters. This is a config that can be changed on the mysql server:

Code:

[mysqld]
ft_min_word_len=3

Note that tag names and file names do not use the full text search (this is why it works).

plg · 2012-12-11 16:15:12

Thank you rvelices for "advanced expertise" :-)

So that would mean modifying the MySQL configuration on the Piwigo.com server where mcl is hosted. If I read correctly the documentation, it means that MySQL will rebuild all FULLTEXT indexes :-/

rvelices · 2012-12-11 16:18:41

plg wrote:
So that would mean modifying the MySQL configuration on the Piwigo.com server where mcl is hosted. If I read correctly the documentation, it means that MySQL will rebuild all FULLTEXT indexes :-/

We dont use the full text indexes, just the full text search witout indexes so there should be no issue ...

Piwigo.org

Announcement

#1 2012-12-11 13:39:27

piwigo.com QuickSearch

#2 2012-12-11 14:52:30

Re: piwigo.com QuickSearch

#3 2012-12-11 16:11:28

Re: piwigo.com QuickSearch

Code:

#4 2012-12-11 16:15:12

Re: piwigo.com QuickSearch

#5 2012-12-11 16:18:41

Re: piwigo.com QuickSearch

plg wrote:

Board footer