CiviCRM Community Forums (archive)

Hi!

I just upgraded our 3.0 to 3.2, and since thus far we only keep contacts in it, I went the export/import way, instead of taking the longer route of a full upgrade. It worked in the past. However, it doesn't seem to work anymore.

I have two export files, one for individuals and another for organizations (we have no households in store). The both where produced by 3.0, the files appear regular when opened in OOo.

On importing the files I get:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 1 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_3-2/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 1 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_3-2/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 1 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm_3-2/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

Any hint?[/code]

so, upon a closer inspection:
1) the contains a civicrm_import_job_904d69b0a47c415c72ffee50d056859a  table (and more similar tables) which appear to be tmp tables and contain the data I was trying to import. So, no apparent trouble in decoding the csv file.
2) civicrm_contact is empty, and this obviously makes the FK refuse the entry.

In short, there is probably some better way to track what is making the civicrm_contact insert fail, as civicrm_acl_cache failure is but the last ring in the chain and it can hardly show any problem at all. What do we do to backtrack this stuff?

seems like this is a session issue:

1. can you try logging out and logging back in

2. if the above does not work, can you truncate your drupal session table

thanx

lobo