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
- 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
{main}
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