Unable to configure Organization Address and Contact Information

[Patricia43]

I'm installing CiviCRM 4.3.alpha3 in a Drupal 7.22 website. I'm using a separate database for CiviCRM.
The error appears to be caused by a Foreign Key constraint. I have reinstalled several times and each time I get an error when I attempt to configure the Organization Address and Contact Information. (I've tried dropping the constraint and various other database modifications to no effect.)
Here is the info from the Drupal log

$Fatal Error Details = Array ( [callback] => Array (

• => CRM_Core_Error [1] => handle )
  Code: [Select]
  => -3 [message] => DB Error: constraint violation [mode] => 16 [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' , 1 , 'civicrm_contact,1' , 2 , 20130715111055 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zerocarb_climateactnow_civicrm`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)] [type] => DB_Error [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' , 1 , 'civicrm_contact,1' , 2 , 20130715111055 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zerocarb_climateactnow_civicrm`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_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_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' , 1 , 'civicrm_contact,1' , 2 , 20130715111055 ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zerocarb_climateactnow_civicrm`.`civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"] )

[Hershel]

Delete your database completely and try again.

Also, why are you using 4.3.alpha3? The latest stable version is 4.3.5 -- you should use that.

[Patricia43]

After I wrote that I realized I did not have the most recent version and am in the process of downloading it now. Thanks.

(p.s. I had deleted the database many times.)

[Patricia43]

I downloaded 4.3.5 and installed it ... after dropping all database tables. But it still fails with a similar error - different table this time civicrm_dashboard_contact:
$Fatal Error Details = Array ( [callback] => Array (

• => CRM_Core_Error [1] => handle )
  Code: [Select]
  => -3 [message] => DB Error: constraint violation [mode] => 16 [debug_info] => INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, is_active) VALUES (1, 2, 1, 1), (2, 2, 0, 0) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zerocarb_climateactnow_civicrm`.`civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASC)] [type] => DB_Error [user_info] => INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, is_active) VALUES (1, 2, 1, 1), (2, 2, 0, 0) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zerocarb_climateactnow_civicrm`.`civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASC)] [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, is_active) VALUES (1, 2, 1, 1), (2, 2, 0, 0) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`zerocarb_climateactnow_civicrm`.`civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASC)]"] )[/li][/list]
Severity

[Patricia43]

In case anyone else has this problem, after posting this is an issue, I was advise to logout and login again ... which I rarely do ... and that got rid of the error and I was able to continue configuring the site.

[JonGold]

Patricia - thanks for reporting back, finding this forum thread saved me a lot of frustration!

[kmitz]

Logging out and back in also worked for me for version 4.5

[JonGold]

This thread saved me again - I ran into an almost identical issue when copying a Civi database from one Wordpress instance to another (not a different copy of the same site, but a different site altogether).