upgrade to 5.28.beta1 fails
With Contact types shown in below screenshot the upgrade fails with below error
Aug 04 23:51:52 [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comment 'Internal name of Contact Type (or Subtype).' [nativecode=1138 ** Invalid use of NULL value]
[type] => DB_Error
[user_info] => ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comment 'Internal name of Contact Type (or Subtype).' [nativecode=1138 ** Invalid use of NULL value]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comment 'Internal name of Contact Type (or Subtype).' [nativecode=1138 ** Invalid use of NULL value]"]
)
Aug 04 23:51:52 [debug] $backTrace = #0 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Core/Error.php(937): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB.php(998): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...")
#3 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...")
#4 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...", "DB_Error", TRUE)
#5 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB/common.php(1925): PEAR->__call("raiseError", (Array:7))
#6 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB/mysqli.php(936): DB_common->raiseError(-1, NULL, NULL, "ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...", "1138 ** Invalid use of NULL value")
#7 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB/common.php(1231): DB_mysqli->simpleQuery("ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...")
#9 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Utils/File.php(350): DB_common->query("ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...")
#10 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php(155): CRM_Utils_File::runSqlQuery("mysql://root:root@127.0.0.1:3306/civi_dru_crm?new_link=true", "-- https://github.com/civicrm/civicrm-core/pull/17579\nALTER TABLE `civicrm_n...", NULL)
#11 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php(350): CRM_Upgrade_Form->source("-- https://github.com/civicrm/civicrm-core/pull/17579\nALTER TABLE `civicrm_n...", TRUE)
#12 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php(384): CRM_Upgrade_Form->processLocales("/Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Increm...", "5.28.alpha1")
#13 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Incremental/Base.php(66): CRM_Upgrade_Form->processSQL("5.28.alpha1")
#14 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/Task.php(74): CRM_Upgrade_Incremental_Base::runSql(Object(CRM_Queue_TaskContext), "5.28.alpha1")
#15 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/Runner.php(202): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#16 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(36): CRM_Queue_Runner->runNext(TRUE)
#17 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(90): CRM_Queue_Page_AJAX::{closure}()
#18 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(38): CRM_Queue_ErrorPolicy->call(Object(Closure))
#19 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): CRM_Queue_Page_AJAX::runNext()
#20 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:13))
#21 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:5))
#22 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:5))
#23 /Users/pradeep/Sites/civi-drupal/includes/menu.inc(527): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#24 /Users/pradeep/Sites/civi-drupal/index.php(21): menu_execute_active_handler()
#25 {main}
Aug 04 23:51:52 [info] $CRM_Queue_Page_AJAX_runNext_error = PEAR_Exception: "DB Error: unknown error"
* ERROR TYPE: DB_Error
* ERROR CODE: -1
* ERROR MESSAGE: DB Error: unknown error
* ERROR MODE: 16
* ERROR USERINFO: ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comment 'Internal name of Contact Type (or Subtype).' [nativecode=1138 ** Invalid use of NULL value]
* ERROR DEBUGINFO: ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comment 'Internal name of Contact Type (or Subtype).' [nativecode=1138 ** Invalid use of NULL value]
#0 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB.php(998): PEAR_Error->__construct("DB Error: unknown error", -1, 16, (Array:2), "ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...")
#2 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-1, 16, (Array:2), "ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...")
#3 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), "ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...", "DB_Error", TRUE)
#4 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB/common.php(1925): PEAR->__call("raiseError", (Array:7))
#5 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB/mysqli.php(936): DB_common->raiseError(-1, NULL, NULL, "ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...", "1138 ** Invalid use of NULL value")
#6 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#7 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/packages/DB/common.php(1231): DB_mysqli->simpleQuery("ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...")
#8 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Utils/File.php(350): DB_common->query("ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comme...")
#9 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php(155): CRM_Utils_File::runSqlQuery("mysql://root:root@127.0.0.1:3306/civi_dru_crm?new_link=true", "-- https://github.com/civicrm/civicrm-core/pull/17579\nALTER TABLE `civicrm_n...", NULL)
#10 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php(350): CRM_Upgrade_Form->source("-- https://github.com/civicrm/civicrm-core/pull/17579\nALTER TABLE `civicrm_n...", TRUE)
#11 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php(384): CRM_Upgrade_Form->processLocales("/Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Increm...", "5.28.alpha1")
#12 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Upgrade/Incremental/Base.php(66): CRM_Upgrade_Form->processSQL("5.28.alpha1")
#13 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/Task.php(74): CRM_Upgrade_Incremental_Base::runSql(Object(CRM_Queue_TaskContext), "5.28.alpha1")
#14 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/Runner.php(202): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#15 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(36): CRM_Queue_Runner->runNext(TRUE)
#16 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(90): CRM_Queue_Page_AJAX::{closure}()
#17 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(38): CRM_Queue_ErrorPolicy->call(Object(Closure))
#18 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): CRM_Queue_Page_AJAX::runNext()
#19 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:13))
#20 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:5))
#21 /Users/pradeep/Sites/civi-drupal/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:5))
#22 /Users/pradeep/Sites/civi-drupal/includes/menu.inc(527): civicrm_invoke("upgrade", "queue", "ajax", "runNext")
#23 /Users/pradeep/Sites/civi-drupal/index.php(21): menu_execute_active_handler()
#24 {main}
Caused problem from PR https://github.com/civicrm/civicrm-core/pull/17570
ALTER TABLE civicrm_contact_type CHANGE name name varchar(64) not null comment 'Internal name of Contact Type (or Subtype).';
is executed from 5.28.alpha1.mysql.tpl just before populateMissingContactTypeName() is called in upgrade_5_28_alpha1()