Activity.getFields crashes
syntax error: SELECT * FROM civicrm_tag WHERE id IN ()
Sorry the backtrace isn't formatted very well since it isn't available via CLI or log file just in the browser, but it's clearly something to do with tags at Civi\Api4\Service\Spec\SpecFormatter.php
line 245 where for some reason it's trying to do stuff with tags.
Doesn't happen in 5.67.
Can reproduce on cli with cv ev "\Civi\Api4\Activity::getFields(FALSE)->setLoadOptions(['id','name','label','description','color','icon'])->execute();
{
"debug": {
"info": "SELECT * FROM civicrm_tag WHERE `id` IN () [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]",
"db_error": "syntax error",
"sql": [
"SELECT * FROM civicrm_tag WHERE `id` IN () [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]"
],
"backtrace": "#0 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(945): CRM_Core_Error::exceptionHandler(Object(DB_Error))\n#1 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/vendor/pear/db/DB.php(997): PEAR_Error->__construct('DB Error: synta...', -2, 16, Array, 'SELECT * FROM c...')\n#2 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-2, 16, Array, 'SELECT * FROM c...')\n#3 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -2, 16, Array, 'SELECT * FROM c...', 'DB_Error', true)\n#4 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/vendor/pear/db/DB/common.php(1928): PEAR->__call('raiseError', Array)\n#5 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/vendor/pear/db/DB/mysqli.php(943): DB_common->raiseError(-2, NULL, NULL, 'SELECT * FROM c...', '1064 ** You hav...')\n#6 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/vendor/pear/db/DB/mysqli.php(413): DB_mysqli->mysqliRaiseError()\n#7 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery('SELECT * FROM c...')\n#8 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/packages/DB/DataObject.php(2696): DB_common->query('SELECT * FROM c...')\n#9 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/packages/DB/DataObject.php(1829): DB_DataObject->_query('SELECT * FROM c...')\n#10 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/CRM/Core/DAO.php(487): DB_DataObject->query('SELECT * FROM c...')\n#11 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/CRM/Core/DAO.php(1654): CRM_Core_DAO->query('SELECT * FROM c...', true)\n#12 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Service/Spec/SpecFormatter.php(245): CRM_Core_DAO::executeQuery('SELECT * FROM c...')\n#13 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Service/Spec/SpecFormatter.php(173): Civi\\Api4\\Service\\Spec\\SpecFormatter::addOptionProps(Array, Object(Civi\\Api4\\Service\\Spec\\FieldSpec), 'CRM_Core_BAO_En...', 'tag_id', Array, Array)\n#14 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Schema/Traits/OptionsSpecTrait.php(53): Civi\\Api4\\Service\\Spec\\SpecFormatter::getOptions(Object(Civi\\Api4\\Service\\Spec\\FieldSpec), Array, Array, true, Array)\n#15 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Generic/DAOGetFieldsAction.php(75): Civi\\Api4\\Service\\Spec\\FieldSpec->getOptions(Array, Array, true)\n#16 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Generic/DAOGetFieldsAction.php(52): Civi\\Api4\\Generic\\DAOGetFieldsAction->specToArray(Array)\n#17 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Generic/BasicGetFieldsAction.php(97): Civi\\Api4\\Generic\\DAOGetFieldsAction->getRecords()\n#18 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Service/Spec/Provider/EntityTagFilterSpecProvider.php(100): Civi\\Api4\\Generic\\BasicGetFieldsAction->_run(Object(Civi\\Api4\\Generic\\Result))\n#19 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Schema/Traits/OptionsSpecTrait.php(53): Civi\\Api4\\Service\\Spec\\Provider\\EntityTagFilterSpecProvider::getTagList(Object(Civi\\Api4\\Service\\Spec\\FieldSpec), Array, Array, true, Array)\n#20 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Generic/DAOGetFieldsAction.php(75): Civi\\Api4\\Service\\Spec\\FieldSpec->getOptions(Array, Array, true)\n#21 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Generic/DAOGetFieldsAction.php(52): Civi\\Api4\\Generic\\DAOGetFieldsAction->specToArray(Array)\n#22 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Generic/BasicGetFieldsAction.php(97): Civi\\Api4\\Generic\\DAOGetFieldsAction->getRecords()\n#23 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Provider/ActionObjectProvider.php(72): Civi\\Api4\\Generic\\BasicGetFieldsAction->_run(Object(Civi\\Api4\\Generic\\Result))\n#24 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/API/Kernel.php(156): Civi\\Api4\\Provider\\ActionObjectProvider->invoke(Object(Civi\\Api4\\Generic\\DAOGetFieldsAction))\n#25 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/Civi/Api4/Generic/AbstractAction.php(256): Civi\\API\\Kernel->runRequest(Object(Civi\\Api4\\Generic\\DAOGetFieldsAction))\n#26 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/api/api.php(91): Civi\\Api4\\Generic\\AbstractAction->execute()\n#27 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/CRM/Api4/Page/AJAX.php(116): civicrm_api4('Activity', 'getFields', Array, '')\n#28 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/CRM/Api4/Page/AJAX.php(55): CRM_Api4_Page_AJAX->execute('Activity', 'getFields', Array, '')\n#29 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/CRM/Core/Invoke.php(322): CRM_Api4_Page_AJAX->run(Array, NULL)\n#30 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/CRM/Core/Invoke.php(69): CRM_Core_Invoke::runItem(Array)\n#31 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke(Array)\n#32 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/sites/all/modules/civicrm/drupal/civicrm.module(472): CRM_Core_Invoke::invoke(Array)\n#33 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/includes/menu.inc(527): civicrm_invoke('ajax', 'api4', 'Activity', 'getFields')\n#34 /home/jenkins/bknix-dfl/build/core-27958-1xlfo/web/index.php(21): menu_execute_active_handler()\n#35 {main}"
}
}