CiviCRM Community Forums (archive)

Hi

I have just started using civicrm and need to integrate a custom Joomla 2.5 component into civicrm. I need to automatically add contacts and their contact details, this I can do with the civicrm_api calls.

I can insert a new contact and their details using a nested api call, great! I have problems when trying to update an existing user - I can find them and get their id from their email address.

This works, I then put the return value in $emailid and use this in the api call to identify the id for that person which I then use in the next call to create a contact and pass the id.

This is my call

civicrm_api('Contact', 'Create', array('version' => 3, 'id'=>$emailid, 'contact_type' => $contact_type, 'contact_sub_type'=>$contact_sub_type, 'first_name'=>$firstname, 'last_name'=>$lastname));

I get the following error :

[error_code] => constraint violation
    [sql] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  11 , 'civicrm_contact,11' ,  11 ,  20130725160025 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`coolearth`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [tip] => add debug=1 to your API call to have more info about the error
    [is_error] => 1
    [error_message] => DB Error: constraint violation


I have tried to add debug=1 to the call but can't find where to add it to give any results and I don't know what is causing the error.

a: Am I going about this task the correct way? If not how should I tackle this?
b: If I am going about it the correct way how can I sort this issue please?


Any help would be gratefully received 

I hope you can understand what I am asking without examples.

Thanks

I have logged off and this has not made any difference, sorry. This only happens when I am trying to update the contact details.

I am using a script that is bootstrapped to both Joomla 2.5 and civicrm if that makes any difference.

Hi

I am working on a internal test environment and the user is root (this will be changed for a live install).

Thanks

Hi

No, I have just added a contact in the UI of CiviCrm and the entry has gone in fine.

I do have 2 additional contact types of Individual that I have added using the UI, might this cause an issue?

Thanks

Yes I added it as my first type.

I have been re-organising my code and also now have more data in the email table, I have returned an id value from the api email call using
 
$email_type = civicrm_api('Email','Get',array('email' => $array['email'],  'version' =>3, 'return' => array('email', 'id')));


What I really need to get returned is the contact_id (FK for the contact table) not necessarily the id. I have tried to call it the same way as the id but I don't seem to be able to reference it to pass the value to the update contact call. I am puzzled why I can't reference the contact_id from the email table.

Would this have caused the MySQL error as it was referencing a different id hence person?

Thanks

Hi

The first call set you suggested worked fine, the second set unfortunately did not return the contact_id.


Could you confirm or not that email addresses are unique in civicrm please? If they are a single record works perfectly, if not..... 

Thank you

Hi

Thanks for all your replies.

I see what you are saying but the $apiEmails = civicrm_api('Email', 'Get', $apiParams); does not return any data and the error is zero, I will try this on the staging site when it is up and running.

I will work with the Getsingle for now and see how this works when adding more data to the test site.

Thank you