Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-13084

Unable to complete installation due to foreign key constraint

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.3.5
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      I'm installing CiviCRM 4.5 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 (this is caused when I try to start CiviCRM from the Drupal menu:

      $backTrace = #0 /home/zerocarb/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE) #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error)) #2 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error)) #3 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: constraint violation", 3, 16, (Array:2), "INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...") #4 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error>DB_Error(3, 16, (Array:2), "INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...") #5 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR>raiseError(NULL, 3, NULL, NULL, "INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...", "DB_Error", TRUE) #6 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common>raiseError(3, NULL, NULL, NULL, "1452 ** Cannot add or update a child row: a foreign key constraint fails (`ze...") #7 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql>mysqlRaiseError() #8 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...") #9 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...") #10 /home/zerocarb/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...") #11 /home/zerocarb/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...") #12 /home/zerocarb/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...", TRUE) #13 /home/zerocarb/public_html/sites/all/modules/civicrm/CRM/Core/BAO/Dashboard.php(126): CRM_Core_DAO::executeQuery("INSERT INTO civicrm_dashboard_contact (dashboard_id, contact_id, column_no, i...") #14 /home/zerocarb/public_html/sites/all/modules/civicrm/CRM/Contact/Page/AJAX.php(881): CRM_Core_BAO_Dashboard::getContactDashlets() #15 [internal function](): CRM_Contact_Page_AJAX::dashboard((Array:3)) #16 /home/zerocarb/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(258): call_user_func((Array:2), (Array:3)) #17 /home/zerocarb/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:12)) #18 /home/zerocarb/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3)) #19 /home/zerocarb/public_html/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:3)) #20 [internal function](): civicrm_invoke("ajax", "dashboard") #21 /home/zerocarb/public_html/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2)) #22 /home/zerocarb/public_html/index.php(21): menu_execute_active_handler() #23

      {main}

      Severity d

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              patricia43 Patricia Warwick
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: