Search options

Well, mysql has not the same exact issue but as far as I know the ' (apostrophe) is not a word-boundary character so the search engine is not 100% reliable. That means that "l'éléphant" is treated as a single word all together with the article and the apostrophe.

The only way I know to solve this problem is by recompiling mysql adding the ' as word-boundary (you should find tutorial about this on da' web)... or you may do some voodoo programming in PHP adding a [space] just after any apostrophe before updating your mysql table.

In punBB you just need to change an array insearch_idx.php

find:

$noise_replace =    array('',       '',      '',     '',     '',       '',       '',        '',       '',      '',     '',     '',       '',       '',        ' ', ' ', ' ', ' ', ' ', ' ', ' ', '',  '',   ' ', ' ', ' ', ' ', '',  ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '' ,  ' ', ' ', ' ', ' ', ' ', ' ');

replace:

$noise_replace =    array('',       '',      '',     '',     '',       '',       '',        '',       '',      '',     '',     '',       '',       '',        ' ', ' ', ' ', ' ', ' ', ' ', ' ', '',  ' ',   ' ', ' ', ' ', ' ', '',  ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '' ,  ' ', ' ', ' ', ' ', ' ', ' ');

Then you need to rebuild your search_words table.

Use at your own risk, this replaces all apostrophes with a space instead of a null character. It should work but --as Rickard pointed-- it may have some drawbacks. My opinion is that for some languages (italian, french, german, ..) the apostrophe can be safely replaced with a [space]. I'll give it a try and let you know.

PS: wow! I used to love Shadowrun!

probably there's something I'm doing wrong.

I added the word "noi" in the stopwords but if a post contains "noi." (noi+[period]), "noi" (w/o the period) is inserted into the search_words. Instead if the word "noi" appears alone (w/o period) it is correctly stripped out.

You can try to copy some of your stopwords, put a period at the end of each of them and paste into a post. Looking at the search_words table you should see all the words even if they are stopwords.

I updated to 1.2.10 and executed the "Rebuild search index" but this issue still persists... any clue?

ho, I see... are side effects related to the indexing of web domains? (eg: www.punbb.org)

mmmh I guess there's something else that should be done for this issue then. Words in the stopwords file followed by a "." [period] are still inserted into the DB, and two letters words followed by a period are treated as 3 letters words (eg: "dr." is inserted as "dr").

Sorry to bump this rather old topic... but replacing ' with a [space] instead of a [null] wouldn't solve this issue?

Apostrophe is also used a lot in italian and having the apostrophed article merged with the following noun/adjective drastically reduce the efficiency of the search engine. Anyway, this is a common issue of many softwares (mysql full text search is affected by this too).

Yes, I feel that in "changed files only" the file 12_to_1210_update.php is missing... I guess you can grab the one in the full release, thou