CiviCRM Community Forums (archive)

This is probably an underlying configuration problem. When I try to create a New Event, I get down to the pop-up calendar, set the month (but the days don't match the dates); when I click on the day, I get
Sorry. A non-recoverable error has occurred.
DB Error: constraint violation
Error Details
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`dcrca`.`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
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -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 (`dcrca`.`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 (`dcrca`.`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 (`dcrca`.`civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

Now, for background, this is a new install on a server that previously held a CiviCRM installation. I had hoped to use the same db entries (Contact list, Event Types, etc.) but they don't show up. Anybody got any idea what is wrong and how I can fix it (and preferably reuse my existing MySQL tables and their data). Thanks for any help, I know just enough to be dangerous....mostly to myself.

 That worked! Who knew? So simple! Thanks much!
Now, can you tell me why my new copy of CiviCRM can't find the Contacts, Events, etc. generated by the old one? I'm giving it the same MySQL locations, passwords, etc. as the old one, but no data shows up in CiviCRM. And it's not just CiviCRM, I can't find the old user list for Drupal, either. Any help much appreciated. I'll also ask on the Drupal forums. Thanks again!
PS - can you tell me what wysiwyg editor CiviCRM Forums uses? I like it lots better than ckeditor.