22c22 < $sqlft = 'MATCH(' . join(',', $h['search']). ') AGAINST (' . $qwords . ')'; --- > $sqlft = 'MATCH(' . join(',', $h['search']). ') AGAINST (' . $qwords . ' IN BOOLEAN MODE)'; 25a26 > 47a49,50 > > 50,58c53,72 < if (!$cant) { // no result < if ($fulltext && $words) // try a simple search < return $this->_find($h, $words, $offset, $maxRecords, false); < else < return array( < 'data' => array(), < 'cant' => 0 < ); < } --- > //if (!$cant) { // no result > // if ($fulltext && $words) // try a simple search > // return $this->_find($h, $words, $offset, $maxRecords, false); > // else > // return array( > // 'data' => array(), > // 'cant' => 0 > // ); > //} > > //note: above cant block causes following error in MySQL 4.0.15 boolean search > //*************************************************************** > //Warning: mysql error: Got error 'repetition-operator operand invalid' from regexp in query: > //SELECT COUNT(*) FROM tiki_comments c, tiki_pages p WHERE c.objectType = "wiki page" AND p.pageName=c.object AND (UPPER(c.title) REGEXP '.*+LISTENING.*' OR UPPER(c.data) REGEXP '.*+LISTENING.*') AND (UPPER(c.title) REGEXP '.*+PAGE.*' OR UPPER(c.data) REGEXP '.*+PAGE.*') > //in c:\program files\easyphp1-7\www\tw\lib\tikidblib.php on line 125 > //Values: > > //$result is false > //$result is empty > //***************************************************************** 64a79 >