Announcement

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

mcl
Member
2012-11-22
30

piwigo.com QuickSearch

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

Offline

 

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

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13570

Re: piwigo.com QuickSearch

(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 ;-)

Offline

 

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

rvelices
Piwigo Team
2005-12-29
1960

Re: piwigo.com QuickSearch

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).

Offline

 

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

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13570

Re: piwigo.com QuickSearch

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 :-/

Offline

 

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

rvelices
Piwigo Team
2005-12-29
1960

Re: piwigo.com QuickSearch

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 ...

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact