CiviCRM Community Forums (archive)

Strange bug here. For some reason (hopefully soon to be discovered) the when doing searches, the 'state' field is not pulling up contacts with the selected 'state' but all contacts with the other appropriate fields selected (included other address types).

What reasons are there for a search field to function like this? The data still exists because it still shows up (and exist in the mysql tables).

The advance search gives the appropriate prompt:  State/Province - Alabama ...AND... Country = 'United States'  Though, that does not change the fact that the search results include all states, regardless of if they are Alabama.

I am at 3.4.4 but cannot reproduce it on the demo site.

Very strange.

The demo is sometimes updated from svn repository so it probably has code changes made after 3.4.4 release. I looked for the issue on the issue tracker to verify if it was fixed before or after 3.4.4 release but did not see it (only a similar search builder issue).

Looking at the code in CRM/Contact/BAO/Query.php in the stateProvince function there are these lines (at about line 2951):

        if ( $countryClause ) {
            $clause = ( $stateClause AND $countryClause );
        } else {
            $clause = $stateClause;
        }

If I change the second line there as below it works fine.

            $clause = ( $stateClause . ' AND ' . $countryClause );

I feel like I might be missing something obvious, so I thought I'd check before trying to provide a patch.

Malks.

The upgrade to 3.4.5 fixed it.