Search - not all possible results are returned (even none)

Thursday 11 August 2005 3:33:51 pm

I'm working on eZ 3.7 (because of php 4.4), and it doesn't return all possible results from the database when searching (even as admin user).

For instance, when searching for a term 'xyz' in the db:

mysql> select * from ezsearch_word where word like 'xyz';
+--------+--------------+----------+
| id | object_count | word |
+--------+--------------+----------+
| 573271 | 17 | xyz |
| 570824 | 16 | XYZ |
| 526672 | 24 | Xyz |
+--------+--------------+----------+

(same thing for "word = 'xyz'")

eZ shows no results.. For some other search terms, only partial results are shown.

Search index was updated using eZ 3.7 updatesearchindex.php script on PHP 4.4.0 and also with eZ 3.6.1 script on PHP 4.3.11 (CLI).

A mirror of the system built on eZ 3.6.1 works fine hosted on PHP 4.3.1 and returns a lot of results (cannot check if everything is returned).

I'm aware that 3.7.x is considered alpha, but we're forced to use it because of PHP 4.4.0 used on ISP's machines.