City search values return bogus results with multi-word Cities e.g (Fort Worth) [#635198]

Implementing simple Country (default US), State, City "And'd" Search to Location Search and Individual components generate good results and combinations return logical results unless a "two word" city is supplied. At this point I either get NO result set or odd result sets that have nothing to do with the other valid search values.

I also find that running a blank Country, State, City while filling the "Name" value search also produces nonsense results. I can hide the name search field, but the odd results are non-starter for getting this thing to work.

We are successfully using APACHESOLR for the CORE search function of this site and I appears there is currently no integration to override the Location Search with SOLR, true? Would that help at all?

Best
Cal

Comments

Comment #1

cpearson commented 17 November 2009 at 18:57

Some success with manipulating the location_search.module ANDing of L.city to become a LIKE 'city%' and getting better results. But the string is still being stripped or parsed in such a way as to eliminated the second word... city:Fort will get you all the Fort Worth's and Fort Thomas and Fort Collins but "Fort Worth" = no results.


      if ($city = search_query_extract($keys, 'city')) {

        $floofy = '%s' . "%";
        $conditions1 .= " AND (l.city LIKE '$floofy')";

        $arguments1[] = $city;
        $keys = search_query_insert($keys, 'city');
      }