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

Add ON DELETE Options for constraints fails

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Blocker
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.3.6
    • Fix Version/s: 4.3.8
    • Component/s: None
    • Labels:
      None

      Description

      Add ON DELETE Options for constraints gives this output during upgrade:
      Error Field Error Value
      Type DB_Error
      Code -15
      Message DB Error: can not create
      Mode 16
      UserInfo ALTER TABLE civicrm_financial_account ADD CONSTRAINT FK_civicrm_financial_account_contact_id FOREIGN KEY (`contact_id`) REFERENCES civicrm_contact (`id`) ON DELETE SET NULL ; [nativecode=1005 ** Can't create table 'woolman_civicrm.#sql-694_114f6' (errno: 150)]
      DebugInfo ALTER TABLE civicrm_financial_account ADD CONSTRAINT FK_civicrm_financial_account_contact_id FOREIGN KEY (`contact_id`) REFERENCES civicrm_contact (`id`) ON DELETE SET NULL ; [nativecode=1005 ** Can't create table 'woolman_civicrm.#sql-694_114f6' (errno: 150)]
      PEAR_Exception: DB Error: can not create in unknown on line unknown

      • DB_Error: DB Error: can not create in unknown on line unknown
        Exception trace
      1. Function Location
        0 CRM_Core_Error::exceptionHandler(Object(DB_Error)) unknown:unknown
        1 call_user_func(Array, Object(DB_Error)) /var/www/woolman.org/sites/all/modules/civicrm/packages/PEAR.php:931
        2 PEAR_Error->PEAR_Error('DB Error: can no…', -15, 16, Array, ' ALTER TABLE ci…') /var/www/woolman.org/sites/all/modules/civicrm/packages/DB.php:969
        3 DB_Error->DB_Error(-15, 16, Array, ' ALTER TABLE ci…') /var/www/woolman.org/sites/all/modules/civicrm/packages/PEAR.php:564
        4 PEAR->raiseError(null, -15, null, null, ' ALTER TABLE ci…', 'DB_Error', true) /var/www/woolman.org/sites/all/modules/civicrm/packages/DB/common.php:1905
        5 DB_common->raiseError(-15, null, null, null, '1005 ** Can't cr…') /var/www/woolman.org/sites/all/modules/civicrm/packages/DB/mysql.php:898
        6 DB_mysql->mysqlRaiseError() /var/www/woolman.org/sites/all/modules/civicrm/packages/DB/mysql.php:327
        7 DB_mysql->simpleQuery(' ALTER TABLE ci…') /var/www/woolman.org/sites/all/modules/civicrm/packages/DB/common.php:1216
        8 DB_common->query(' ALTER TABLE ci…') /var/www/woolman.org/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
        9 DB_DataObject->_query(' ALTER TABLE ci…') /var/www/woolman.org/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
        10 DB_DataObject->query(' ALTER TABLE ci…') /var/www/woolman.org/sites/all/modules/civicrm/CRM/Core/DAO.php:155
        11 CRM_Core_DAO->query(' ALTER TABLE ci…', false) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Core/DAO.php:917
        12 CRM_Core_DAO::executeQuery(' ALTER TABLE ci…', Array, true, null, false, false) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:1149
        13 CRM_Upgrade_Incremental_php_FourThree::task_4_3_x_checkConstraints(Object(CRM_Queue_TaskContext), '4.3.6') unknown:unknown
        14 call_user_func_array(Array, Array) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Queue/Task.php:79
        15 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Queue/Runner.php:186
        16 CRM_Queue_Runner->runNext(true) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
        17 {closure}

        () /var/www/woolman.org/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
        18 CRM_Queue_ErrorPolicy->call(Object(Closure)) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
        19 CRM_Queue_Page_AJAX::runNext(Array) unknown:unknown
        20 call_user_func(Array, Array) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Core/Invoke.php:258
        21 CRM_Core_Invoke::runItem(Array) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Core/Invoke.php:70
        22 CRM_Core_Invoke::_invoke(Array) /var/www/woolman.org/sites/all/modules/civicrm/CRM/Core/Invoke.php:52
        23 CRM_Core_Invoke::invoke(Array) /var/www/woolman.org/sites/all/modules/civicrm/drupal/civicrm.module:354
        24 civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext') unknown:unknown
        25 call_user_func_array('civicrm_invoke', Array) /var/www/woolman.org/includes/menu.inc:350
        26 menu_execute_active_handler() /var/www/woolman.org/index.php:17
        27

        {main}

        Attachments

        1. deleteScript.sql
          0.4 kB
          Pradeep Nayak
        2. newDeleteScript.sql
          1.0 kB
          Pradeep Nayak

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              colemanw Coleman Watts
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: