Common word threshold
set to 0 in ACP/Search settings-phpBB Native Fulltext?Common word threshold
set to 0 in ACP/Search settings-phpBB Native Fulltext?I used 70% for a tryout. So far it is working okay and the search index is remaining. I have disabled index update as well.rxu wrote:Could you try non-zero value and check if wordmatch table will stop being truncated.
Code: Select all
Common word threshold:
Words which are contained in a greater percentage of all posts will be regarded as common. Common words are ignored in search queries. Set to zero to disable. Only takes effect if there are more than 100 posts. If you want words that are currently regarded as common to be reconsidered you have to recreate the index.
set to zero to disable
is ambiguous (to me). Since it immediately follows Common words are ignored in search queries.
I suspect (linguistically) that it should imply that common words then wouldn't be ignored in search queries (but they shouldn't be removed as the the min and max characters criteria defines the contents of the search tables).Code: Select all
If you want words that are currently regarded as common to be reconsidered you have to recreate the index.
Common word threshold
setting is not 0, function tidy()
(triggered by cron) will select words from SEARCH_WORDLIST_TABLE
where roughly word_count is greater than Common word threshold
* posts number
.word_common
will be set.SEARCH_WORDLIST_TABLE
.Common word threshold
to 0 all 2-4 steps will be skipped. That leads to SEARCH_WORDMATCH_TABLE
gets raising with every new post. In OP case I guess IHP just truncating the table once it gets over some size limit.SEARCH_WORDMATCH_TABLE
is not being updated.