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

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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

Author Message

Marin Orlic

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.