different fulltext search results that should be identical?

[fledeboer]

Hello there. I hope you can help me handeling this problem...

Initial Position:
There a 11 articles including the word "problem" in the db-fields "keywords","thema" or "content". The 11 articles are found by using
phpmyadmin and a "normal" like sql statement.

Problem:
If I use the fulltext search function and search for:

1. "proble" i get a result of 12?

2. "problem" i get a result of 7 articles?

This is confusing me. Doese anybody else can reproduce this problem or better... can solve it?

Regards

Flo

P.S.
I hope this has nothing to do with the stop_word_list or stupid fulltext search function within mysql.

P.P.S. Some version information:
Basis is an MySQL DB Version 4.0.18
PhpMyFAQ Version 1.6.1
PHP 4.3.4

[fledeboer]

Have a look at viewtopic.php?t=1531&highlight=suche

The problem is based on the oddly fulltext search functionality by MySQL.

I "fixed" it for me by a dirty hack...

functions.php -> Line 1517 -> before the "if" syntax.

$num = 0;


But if i include this dirty hack searching with more than one word do not
reduce the result.

Hopefully someone has another solution.

[fledeboer]

At line 1515 in functions.php:

Code: Select all

/** This line is new **/
    $num = 0;
/******************/

    if (0 == $num) {
        $keys = preg_split("/\s+/", $begriff);
        $numKeys = count($keys);
        $where = '';
        for ($i = 0; $i < $numKeys; $i++) {
            if (strlen($where) != 0 ) {
//                $where = $where." OR ";

//** And here the OR is changed into an AND **//
                  $where = $where." AND ";
//**************************************//

            }
            $where = $where.'('.SQLPREFIX."faqdata.thema LIKE '%".$keys[$i]."%' OR ".SQLPREFIX."faqdata.content LIKE '%".$keys[$i]."%' OR ".SQLPREFIX."faqdata.keywords LIKE '%".$keys[$i]."%') AND ".SQLPREFIX.'faqdata.active = \'yes\'';
            if (is_numeric($category)) {
                $where .= ' AND '.SQLPREFIX.'faqcategoryrelations.category_id = '.$category;
            }
        }

And that's it.

...anymore i hope for a better solution....

[matteo]

Hi fledeboer,

...anymore i hope for a better solution....

I'm not sure what is better for you but you could try to modify the search method of the db_mysql class (inc/mysql.php) for removing the automatic boolean search with your MySQL v4.0.18:

Code: Select all

        if (version_compare($this->server_version(), '4.0.1') < 0)  {
            $against = "('".$string."')"; // Search with MySQL 3.23.23+
        } else {
            //$against = "('".$string."' IN BOOLEAN MODE)"; // Search with MySQL 4.0.1+
        }