CiviCRM Community Forums (archive)

Hello,
I am having a big issue on importing my data from csv to civicrm. I followed the process and after several times, be able to import 600 contacts on 850 from the file.
Probably because I am using a shared server, the next time I tried to import again, here is the message I received.


Base de donnée de code d'erreur: Cannot add or update a child row: a foreign key constraint fails (`databasename`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL), 1452
Détails additionnels:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   [  code ] => -3
   

[message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , supplemental_address_1 , supplemental_address_2 , city , postal_code_suffix , postal_code , country_id , master_id ) VALUES ( 1576 ,  2 ,  1 ,  0 , 'adresse' , 'adresse-2' , 'ville' , 'CEDEX' , 'cpostal' ,  1076 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`databasename`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , supplemental_address_1 , supplemental_address_2 , city , postal_code_suffix , postal_code , country_id , master_id ) VALUES ( 1576 ,  2 ,  1 ,  0 , 'Adresse' , 'adresse-2' , 'ville' , 'CEDEX' , 'codepostal' ,  1076 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`databasename`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , supplemental_address_1 , supplemental_address_2 , city , postal_code_suffix , postal_code , country_id , master_id ) VALUES ( 1576 ,  2 ,  1 ,  0 , 'adresse' , 'adresse-2' , 'ville' , 'CEDEX' , 'codepostal' ,  1076 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`databasename`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]"]
)


I read a lot of posts about this error and was unable to solve it for me.
Is anyone can help me in an urgent way, that i wouldn't have to type the 200 names to build my database?
Thx in advance.
m.

It's hard to say. If you can make a copy of your CSV that is not confidential (change the details and use just a few rows) and you can recreate this error on the demo, then we can look into it.

It looks like it's trying to match an address, i.e. to share addresses, but the "master" address doesn't exist, but I'm not sure why it would do that.