Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.1
-
Fix Version/s: 1.2
-
Component/s: None
-
Labels:None
Description
CRM/Utils/Geocode/ZipTable.php throws an error during contact import when zip code is blank.
I fixed the problem by avoiding the coordinate lookup if zip code is blank:
$zip = addslashes( $values['postal_code'] );
if ( $zip !== '' ) {
$query = 'SELECT latitude, longitude FROM zipcodes WHERE zip = ' . addslashes( $values['postal_code'] );
$dao =& CRM_Core_DAO::executeQuery( $query );
if ( $dao->fetch( ) )
}