Dear Drupal community,

When I do a search on my fully indexed site, I get no search results...I've spent some time on the fora first and then looking in my database to figure out what could cause this problem.

It seems that the 'count' value for all words in my table 'search_total' are not calculated correctly: all words get a count of 0. If I manually change the 'count' value for a word from 0 to 1, I do get search results for that word.

In the search module code I can see that the 'count' value is calculated from the sum of the 'score' values (normalized by applying Zipf's law to equalize the probability distribution (whatever that means)).

The 'score' values in the table 'search_index' all have values that seem right to me.
The site is fully indexed
The log shows no errors
The database schema comparison reports that all tables match.

Any pointers on this issue?

Thanks in advance,

Floris

Comments

ainigma32’s picture

ainigma32 commented
Status: Active » Postponed (maintainer needs more info)

Do you have any contributed modules that might be interfering?

- Arie

fleurink’s picture

fleurink commented

Thanks for the reply!

I have disabled all contrib modules and re-indexed the site. Still: all word count values in table search_total are computed to zero... Any other ideas?

Floris

fleurink’s picture

fleurink commented
Status: Postponed (maintainer needs more info) » Fixed

Problem fixed: it was an incorrect field attribute setting for data field 'count': it was a float - which is correct - but with size 12, while values for this column need at least 16 characters. I've deleted the table search_total and created it again with the correct MySql query as provided by the database schema and re-indexed the site: now all values are there (i.e. not zero) and I get my search results!

(The schema module did no check on the correct float size, so it did not show up as a mismatch...)

Thanks Arie for the reply...

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.