Regression on 5.48 upgrade
New upgrade bug ... - I got past it doing https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/civicrm/+/769796/1
- the item that it caught is further down
* ERROR USERINFO: SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`label` AS `label`, `a`.`value` AS `value`, `a`.`name` AS `name`, `a`.`grouping` AS `grouping`, `a`.`filter` AS `filter`, `a`.`is_default` AS `is_default`, `a`.`weight` AS `weight`, `a`.`description` AS `description`, `a`.`is_optgroup` AS `is_optgroup`, `a`.`is_reserved` AS `is_reserved`, `a`.`is_active` AS `is_active`, `a`.`component_id` AS `component_id`, `a`.`domain_id` AS `domain_id`, `a`.`visibility_id` AS `visibility_id`, `a`.`icon` AS `icon`, `a`.`color` AS `color`
FROM a
WHERE (`a`.`option_group_id` = "19") AND (`a`.`name` = "CiviGrant")
[nativecode=1146 ** Table 'civicrm.a' doesn't exist]
* ERROR DEBUGINFO: SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`label` AS `label`, `a`.`value` AS `value`, `a`.`name` AS `name`, `a`.`grouping` AS `grouping`, `a`.`filter` AS `filter`, `a`.`is_default` AS `is_default`, `a`.`weight` AS `weight`, `a`.`description` AS `description`, `a`.`is_optgroup` AS `is_optgroup`, `a`.`is_reserved` AS `is_reserved`, `a`.`is_active` AS `is_active`, `a`.`component_id` AS `component_id`, `a`.`domain_id` AS `domain_id`, `a`.`visibility_id` AS `visibility_id`, `a`.`icon` AS `icon`, `a`.`color` AS `color`
FROM a
WHERE (`a`.`option_group_id` = "19") AND (`a`.`name` = "CiviGrant")
[nativecode=1146 ** Table 'civicrm.a' doesn't exist]
#0 /srv/civi-sites/wmff/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: no such table", -18, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#2 /srv/civi-sites/wmff/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-18, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#3 /srv/civi-sites/wmff/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_civirpow), NULL, -18, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...", "DB_Error", TRUE)
#4 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#5 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-18, NULL, NULL, "SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...", "1146 ** Table 'civicrm.a' doesn't exist")
#6 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#7 /srv/civi-sites/wmff/drupal/sites/default/civicrm/extensions/rpow/DB/civirpow.php(66): DB_mysqli->simpleQuery("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#8 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB/common.php(1234): DB_civirpow->simpleQuery("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#9 /srv/civi-sites/wmff/civicrm/packages/DB/DataObject.php(2696): DB_common->query("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#10 /srv/civi-sites/wmff/civicrm/packages/DB/DataObject.php(1829): DB_DataObject->_query("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#11 /srv/civi-sites/wmff/civicrm/CRM/Core/DAO.php(468): DB_DataObject->query("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#12 /srv/civi-sites/wmff/civicrm/CRM/Core/DAO.php(1633): CRM_Core_DAO->query("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...", TRUE)
#13 /srv/civi-sites/wmff/civicrm/Civi/Api4/Query/Api4SelectQuery.php(167): CRM_Core_DAO::executeQuery("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#14 /srv/civi-sites/wmff/civicrm/Civi/Api4/Generic/DAOGetAction.php(113): Civi\Api4\Query\Api4SelectQuery->run()
#15 /srv/civi-sites/wmff/civicrm/Civi/Api4/Generic/DAOGetAction.php(101): Civi\Api4\Generic\DAOGetAction->getObjects(Object(Civi\Api4\Generic\Result))
#16 /srv/civi-sites/wmff/civicrm/Civi/Api4/Provider/ActionObjectProvider.php(69): Civi\Api4\Generic\DAOGetAction->_run(Object(Civi\Api4\Generic\Result))
#17 /srv/civi-sites/wmff/civicrm/Civi/API/Kernel.php(149): Civi\Api4\Provider\ActionObjectProvider->invoke(Object(Civi\Api4\Generic\DAOGetAction))
#18 /srv/civi-sites/wmff/civicrm/Civi/Api4/Generic/AbstractAction.php(234): Civi\API\Kernel->runRequest(Object(Civi\Api4\Generic\DAOGetAction))
#19 /srv/civi-sites/wmff/civicrm/api/api.php(85): Civi\Api4\Generic\AbstractAction->execute()
#20 /srv/civi-sites/wmff/civicrm/CRM/Upgrade/Incremental/php/FiveFortySeven.php(284): civicrm_api4("OptionValue", "get", (Array:2))
#21 /srv/civi-sites/wmff/civicrm/CRM/Queue/Task.php(73): CRM_Upgrade_Incremental_php_FiveFortySeven::migrateCiviGrant(Object(CRM_Queue_TaskContext))
#22 /srv/civi-sites/wmff/civicrm/CRM/Queue/Runner.php(215): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
RAW Paste Data
* ERROR USERINFO: SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`label` AS `label`, `a`.`value` AS `value`, `a`.`name` AS `name`, `a`.`grouping` AS `grouping`, `a`.`filter` AS `filter`, `a`.`is_default` AS `is_default`, `a`.`weight` AS `weight`, `a`.`description` AS `description`, `a`.`is_optgroup` AS `is_optgroup`, `a`.`is_reserved` AS `is_reserved`, `a`.`is_active` AS `is_active`, `a`.`component_id` AS `component_id`, `a`.`domain_id` AS `domain_id`, `a`.`visibility_id` AS `visibility_id`, `a`.`icon` AS `icon`, `a`.`color` AS `color`
FROM a
WHERE (`a`.`option_group_id` = "19") AND (`a`.`name` = "CiviGrant")
[nativecode=1146 ** Table 'civicrm.a' doesn't exist]
* ERROR DEBUGINFO: SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`label` AS `label`, `a`.`value` AS `value`, `a`.`name` AS `name`, `a`.`grouping` AS `grouping`, `a`.`filter` AS `filter`, `a`.`is_default` AS `is_default`, `a`.`weight` AS `weight`, `a`.`description` AS `description`, `a`.`is_optgroup` AS `is_optgroup`, `a`.`is_reserved` AS `is_reserved`, `a`.`is_active` AS `is_active`, `a`.`component_id` AS `component_id`, `a`.`domain_id` AS `domain_id`, `a`.`visibility_id` AS `visibility_id`, `a`.`icon` AS `icon`, `a`.`color` AS `color`
FROM a
WHERE (`a`.`option_group_id` = "19") AND (`a`.`name` = "CiviGrant")
[nativecode=1146 ** Table 'civicrm.a' doesn't exist]
#0 /srv/civi-sites/wmff/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: no such table", -18, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#2 /srv/civi-sites/wmff/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-18, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#3 /srv/civi-sites/wmff/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_civirpow), NULL, -18, 16, (Array:2), "SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...", "DB_Error", TRUE)
#4 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#5 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-18, NULL, NULL, "SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...", "1146 ** Table 'civicrm.a' doesn't exist")
#6 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#7 /srv/civi-sites/wmff/drupal/sites/default/civicrm/extensions/rpow/DB/civirpow.php(66): DB_mysqli->simpleQuery("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#8 /srv/civi-sites/wmff/civicrm/vendor/pear/db/DB/common.php(1234): DB_civirpow->simpleQuery("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#9 /srv/civi-sites/wmff/civicrm/packages/DB/DataObject.php(2696): DB_common->query("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#10 /srv/civi-sites/wmff/civicrm/packages/DB/DataObject.php(1829): DB_DataObject->_query("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#11 /srv/civi-sites/wmff/civicrm/CRM/Core/DAO.php(468): DB_DataObject->query("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#12 /srv/civi-sites/wmff/civicrm/CRM/Core/DAO.php(1633): CRM_Core_DAO->query("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...", TRUE)
#13 /srv/civi-sites/wmff/civicrm/Civi/Api4/Query/Api4SelectQuery.php(167): CRM_Core_DAO::executeQuery("SELECT `a`.`id` AS `id`, `a`.`option_group_id` AS `option_group_id`, `a`.`lab...")
#14 /srv/civi-sites/wmff/civicrm/Civi/Api4/Generic/DAOGetAction.php(113): Civi\Api4\Query\Api4SelectQuery->run()
#15 /srv/civi-sites/wmff/civicrm/Civi/Api4/Generic/DAOGetAction.php(101): Civi\Api4\Generic\DAOGetAction->getObjects(Object(Civi\Api4\Generic\Result))
#16 /srv/civi-sites/wmff/civicrm/Civi/Api4/Provider/ActionObjectProvider.php(69): Civi\Api4\Generic\DAOGetAction->_run(Object(Civi\Api4\Generic\Result))
#17 /srv/civi-sites/wmff/civicrm/Civi/API/Kernel.php(149): Civi\Api4\Provider\ActionObjectProvider->invoke(Object(Civi\Api4\Generic\DAOGetAction))
#18 /srv/civi-sites/wmff/civicrm/Civi/Api4/Generic/AbstractAction.php(234): Civi\API\Kernel->runRequest(Object(Civi\Api4\Generic\DAOGetAction))
#19 /srv/civi-sites/wmff/civicrm/api/api.php(85): Civi\Api4\Generic\AbstractAction->execute()
#20 /srv/civi-sites/wmff/civicrm/CRM/Upgrade/Incremental/php/FiveFortySeven.php(284): civicrm_api4("OptionValue", "get", (Array:2))
#21 /srv/civi-sites/wmff/civicrm/CRM/Queue/Task.php(73): CRM_Upgrade_Incremental_php_FiveFortySeven::migrateCiviGrant(Object(CRM_Queue_TaskContext))
#22 /srv/civi-sites/wmff/civicrm/CRM/Queue/Runner.php(215): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
Mar 11 00:32:00 [warning] Array
(
[entity] => Navigation
[values] => Array
(
[name] => Grant Status
[domain_id] => current_domain
)
)
Array
(
[checkPermissions] =>
[where] => Array
(
[0] => Array
(
[0] => name
[1] => =
[2] => Grant Status
)
[1] => Array
(
[0] => domain_id
[1] => =
[2] => current_domain
)
)
)