CiviCRM Community Forums (archive)

In my code, I am looking up the household address, then trying to assign it as a "shared with" address for the individual who is a household member.


My code snippet:

$tmp_address2 = array( 1 => array( 'location_type_id'       => 1,
                                      'is_primary'             => 1,
                                      'master_id'          => $hhid,    
                                      'city'                   => $tmp_address[city],
                                      'state_province'         => $tmp_address[state_province_id],
                                      'street_address'         => $tmp_address[street_address],
                                      'supplemental_address_1' => $tmp_address[supplemental_address_1],
                                      'postal_code'          => $tmp_address[postal_code] ,
                                      'country_id'             => $tmp_address[country_id] ,
                                      'geo_code_1'      => $tmp_address[geo_code_1],
                                      'geo_code_2'      => $tmp_address[geo_code_2]                                   
                                       )
                        );
        // Put them in an array and then add to $params array
        $loc_params = array('version'    => '3.0',
                        'contact_id' => $cid,
                        'address'    => $tmp_address2
                        );
       
        echo "<br><br>loc_params to send to API: <br>";
        print_r($loc_params);
       
       $newLocation =& civicrm_location_add($loc_params);


At runtime I see:
loc_params to send to API:
Array ( [version] => 3.0 [contact_id] => 7226 [address] => Array ( [1] => Array ( [location_type_id] => 1 [is_primary] => 1 [master_id] => 6380 [city] => Chicago [state_province] => 1012 [street_address] => 4342 S. Trumbull [supplemental_address_1] => [postal_code] => 60632 [country_id] => 1228 [geo_code_1] => 41.814075 [geo_code_2] => -87.71056 ) ) )

Yet the error message is:
DB Error: constraint violation

[debug_info] =&gt; UPDATE  civicrm_address  SET contact_id = 7226 , location_type_id = 1 , is_primary = 1 , is_billing = 0 , street_address = '4342 S. Trumbull' , city = 'Chicago' , state_province_id = 1012 , postal_code = '60632' , country_id = 1228 , geo_code_1 = 41.8140750 , geo_code_2 = -87.7105600 , master_id = 6380   WHERE (  civicrm_address.id = 3670 )   [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`hydepark_main`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
    [type] =&gt; DB_Error

I was incorrectly passing the contact id of the household. I fixed my code to send the id of the location instead, and now its working for the contacts that I had previously imported.

However, it is throwing a different error for contacts that were created in the user interface.

The code is:
 echo "<br><br>loc_params to send to API: <br>";
  print_r($loc_params);
 $newLocation =& civicrm_location_update($loc_params);
               
  $tmp_newloc = civicrm_error( $newLocation );   
 if( $tmp_newloc  ) {
            echo '<br>Error occured while creating Location: '.$tmp_newloc ;
        } else {
           
             echo '<br>Location Created:';
             print_r( $newLocation );
             echo "<br>";
        }

--------------------

The results on the screen are:


loc_params to send to API:
Array ( [version] => 3.0 [contact_id] => 8291 [address] => Array ( [1] => Array ( [location_type_id] => 1 [is_primary] => 1 [master_id] => 3640 [city] => Chicago [state_province] => 1012 [street_address] => 123 Main Ave. [supplemental_address_1] => [postal_code] => 60637 [country_id] => 1228 [geo_code_1] => 41.791758 [geo_code_2] => -87.590584 ) ) )

Error occured while creating Location: 1