CiviCRM Community Forums (archive)

I have a Drupal installation with CiviCRM installed. I was trying to import an existing database from another CiviCRM installation and did something wrong and I can't seem to get things back again.

I would like to completely uninstall and reinstall the Civi installation but it's not working. Every time I try to do so, when I try to access the add a new individual (just to test and see if I installed correctly) I get the following error:
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrm`.`civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452
Additional Details:
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`.`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`.`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`.`civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)
I have removed the Civi module, used phpmyadmin to remove the database, deleted the civicrm.settings.php file, and also deleted the civicrm folder. I would then try and install fresh but keep getting the same error. What can I do besides reinstalling Drupal?

My end goal is to install Drupal/CiviCRM on a server that I just built and then import the CiviCRM database. I do not want to import the Drupal database, there is nothing in there that I want to keep, there is only usable info in the CiviCRM database.

Thanks[/code]

Thanks for the response. I am not much of a database person. I found the 'sessions' table in phpmyadmin. Can you tell me what I need to do to truncate it? If I can reading things correctly, it only has one record in it. Would I simply empty it?

Thanks again.

That did the trick.

Thanks

that worked for me too!  Also you must delete the files/civicrm folder when you reinstall.