hello i got a website with 5000 cities in it (in develoment not live yet). When i do a search on the field 'city' this is what happens:

(I am looking for the city : 'kortrijk')

I type: 'k - results: 'schaarbeek'
I type: 'ko' - results: 'koekelberg', 'bevekom', 'kontich', 'kortenberg', 'kortenaken', 'kortessem'
I type: 'kor' - results: 'kortenberg', 'kortenaken', 'kortessem', 'kortrijk'
I type: 'kort' - results: 'kortenberg', 'kortenaken', 'kortessem', 'kortrijk'
I type: 'kort' - results: 'kortenberg', 'kortenaken', 'kortessem', 'kortrijk'

The res tis also ok.

But as you can see the first 2 result sets are wrong (the first is completely wrong and the second does not give me 'kortrijk' where it should)

Anybody an idea what is going wrong here?

(I did not alter the source code or something else)

Comments

danielb’s picture

danielb commented

Do you have a limit set on how many results are to show?

That still wouldn't explain why you only got 1 result for the first search :/

barthaedens’s picture

barthaedens commented
Status: Active » Fixed

I think i found the solution.

The problem was that some cities where several times in the records (+20 for some of them). When they came up it gave me the first 10 results (number of results i asked) and then grouped them but as this was 10 times the same city i only got to see one result.

So when i adapted the sql queries in the module (i added a GROUP BY) the results where given as they should.

barthaedens’s picture

barthaedens commented
Status: Fixed » Active

sorry for the above remark, problem is not solved

now the search will give me only one result in the search results page even though there are plural.

danielb’s picture

danielb commented

oh sorry I didn't notice the latest reponse.
Can you give me more information about what your search word was, what are the expected results, what was autocompleted, and what are the results after submit?
Also check 'processing and results' settings in the block maybe there is an option in there that will give you the expected behaviour.

danielb’s picture

danielb commented
Status: Active » Postponed (maintainer needs more info)
danielb’s picture

danielb commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Please reopen if you are still having this issue.