Change the Search indexing minimum to 3 characters

[Franke]

It's quite literally a one-click change in phpBB. It has a lot more to do with the database (MySQL, etc.), than it does PHP.

Doesn´t matter what you set it to in phpBB. It can not override the php/mysql settings. If you set it to 2 and php/mysql settings are 4, it will still be 4 after you set it to 2. Thats my point.

Changing to full text search maks this functin a little stronger.

[PatronSaintofChainsaws]

Doesn´t matter what you set it to in phpBB. It can not override the php/mysql settings. If you set it to 2 and php/mysql settings are 4, it will still be 4 after you set it to 2. Thats my point.

And my point is that no such limitation exists in PHP, nor can such a setting be configured via php.ini. Granted, having an extension like memcache or xcache enabled might activate some bizarre limitations that I'm not familiar with (although I've used both and never encountered such a thing), but as far as I am aware, there's no such limitation.

[Pugwash]

And my point is that no such limitation exists in PHP, nor can such a setting be configured via php.ini. Granted, having an extension like memcache or xcache enabled might activate some bizarre limitations that I'm not familiar with (although I've used both and never encountered such a thing), but as far as I am aware, there's no such limitation.

As far as I have understood it, he's talking about it being in the PHP source code for phpBB. If you don't have r/w access to the phpBB code, you can't change the minimum search length indexed.

[PatronSaintofChainsaws]

As far as I have understood it, he's talking about it being in the PHP source code for phpBB. If you don't have r/w access to the phpBB code, you can't change the minimum search length indexed.

It's not, it's in the Admin control panel, under Search Settings. I'm looking at it on one of my BBs right now.

For vBulletin, it's the Search Index Minimum Word Length setting under Message Searching Option.

You may need to modify my.cnf (for MySQL) and add the following for fulltext search:

[mysqld]
ft_min_word_len=3

[myisamchk]
ft_min_word_len=3

http://dev.mysql.com/doc/refman/5.1/...variables.html

Default value is supposedly 4, but strangely enough, I'm running a MySQL version that's a few months old, I don't have a specific ft_min_word_len set, and yet it's been indexing correctly as per my 3 character setting in phpBB on that board.

As I said, it's not a PHP limitation.

Anyway, an additional problem is that they'd have to rebuild the search index. Given that this is a fairly busy board, that might not be very fun.

[Franke]

I stand corrected on the php part. About mysql you are also right, those are the correct params.

The minimum length of words to be indexed is defined by the ft_min_word_len system variables. The default minimum value is four characters.

ft_min_word_len
Command Line Format --ft_min_word_len=#
Config File Format ft_min_word_len
Option Sets Variable Yes, ft_min_word_len
Variable Name ft_min_word_len
Value Set
Type numeric
Default 4
Min Value 1

If you change this value, you must rebuild FULLTEXT indexes. For example, if you want three-character words to be searchable, you need to edit my.cnf and set the ft_min_word_len variable by putting the following lines in an option file:

[mysqld]
ft_min_word_len=3

Then restart the server and rebuild your FULLTEXT indexes.

Repgeek is not currently running under fulltext, hence not beeing able to process boolean search. This needs to be fixed first in admincp.

Then you need to change the mysql setting. If the server is dedicated this should be no problem, and a restart only takes a few minutes.

However, if the forum recides at a webhotel (like my forum) and the webhotel has fixed settings this is not possible. Search will always be what mysql wants it to be and in most cases this means 4 caracters.

Apart from all this: As long as the crew don´t want this, it will definately not happen.

[sixbennetts]

It's not, it's in the Admin control panel, under Search Settings. I'm looking at it on one of my BBs right now.

For vBulletin, it's the Search Index Minimum Word Length setting under Message Searching Option.

You may need to modify my.cnf (for MySQL) and add the following for fulltext search:



http://dev.mysql.com/doc/refman/5.1/...variables.html

Default value is supposedly 4, but strangely enough, I'm running a MySQL version that's a few months old, I don't have a specific ft_min_word_len set, and yet it's been indexing correctly as per my 3 character setting in phpBB on that board.

As I said, it's not a PHP limitation.

Anyway, an additional problem is that they'd have to rebuild the search index. Given that this is a fairly busy board, that might not be very fun.

I stand corrected on the php part. About mysql you are also right, those are the correct params.

The minimum length of words to be indexed is defined by the ft_min_word_len system variables. The default minimum value is four characters.

ft_min_word_len
Command Line Format --ft_min_word_len=#
Config File Format ft_min_word_len
Option Sets Variable Yes, ft_min_word_len
Variable Name ft_min_word_len
Value Set
Type numeric
Default 4
Min Value 1

If you change this value, you must rebuild FULLTEXT indexes. For example, if you want three-character words to be searchable, you need to edit my.cnf and set the ft_min_word_len variable by putting the following lines in an option file:

[mysqld]
ft_min_word_len=3

Then restart the server and rebuild your FULLTEXT indexes.

Repgeek is not currently running under fulltext, hence not beeing able to process boolean search. This needs to be fixed first in admincp.

Then you need to change the mysql setting. If the server is dedicated this should be no problem, and a restart only takes a few minutes.

However, if the forum recides at a webhotel (like my forum) and the webhotel has fixed settings this is not possible. Search will always be what mysql wants it to be and in most cases this means 4 caracters.

Apart from all this: As long as the crew don´t want this, it will definately not happen.

SPEAK ENGRISH!!!

[PatronSaintofChainsaws]

SPEAK ENGRISH!!!

Big man have small number where large number should go. Large number top quality, A+++++++++.

Large number make happy feeling all of the time.

[Franke]

Big man have small number where large number should go. Large number top quality, A+++++++++.

Large number make happy feeling all of the time.

Well, if nothing else works, you can always remove that stupid avatar of yours.