CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2023-11-10T13:53:14Zhttps://lab.civicrm.org/dev/core/-/issues/4751Call to civicrm_api3_create_error from civicrm/Civi/API/Kernel.php fails2023-11-10T13:53:14ZchriscantCall to civicrm_api3_create_error from civicrm/Civi/API/Kernel.php failsAn overnight geocode Scheduled Job started generating an error on 2023-11-03 because the Parameters had a blank line at the end. I'd updated to CiviCRM 5.67.0 the day before.
```plaintext
Parameters raw (from db settings):
geocoding=1
...An overnight geocode Scheduled Job started generating an error on 2023-11-03 because the Parameters had a blank line at the end. I'd updated to CiviCRM 5.67.0 the day before.
```plaintext
Parameters raw (from db settings):
geocoding=1
parse=0
```
Parameters parsed (and passed to API method): `a:0:{}`
When previously the parameters passed to the API `a:3:{s:7:"version";i:3;s:9:"geocoding";s:1:"1";s:5:"parse";s:1:"0";}`
I fixed that problem by removing the blank line.
However, the error was being reported through civicrm/Civi/API/Kernel.php line 407 it seems, ie here: https://github.com/civicrm/civicrm-core/blob/master/Civi/API/Kernel.php#L407
This threw an exception as shown below.
I fixed that problem adding this line before
`require_once "api/v3/utils.php";`
Hope this helps, Chris
When seeking help with this issue, you may be asked for some of the following information:
```plaintext
WordPress version 6.3.2
Active theme: Avada (version 7.11.2)
Current plugin: CiviCRM (version 5.67.0) PHP version 8.1.25
Error Details
=============
An error of type E_ERROR was caused in line 407 of the file /var/.../wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php. Error message: Uncaught Error: Call to undefined function civicrm_api3_create_error() in /var/.../wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php:407
Stack trace:
#0 /var/.../wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(348): Civi\API\Kernel->createError()
#1 /var/.../wp-content/plugins/civicrm/civicrm/Civi/API/Kernel.php(88): Civi\API\Kernel->formatApiException()
#2 /var/.../wp-content/plugins/civicrm/civicrm/api/api.php(28): Civi\API\Kernel->runSafe()
#3 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php(125): civicrm_api()
#4 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php(92): CRM_Core_JobManager->executeJob()
#5 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Admin/Form/Job.php(218): CRM_Core_JobManager->executeJobById()
#6 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(614): CRM_Admin_Form_Job->postProcess()
#7 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(56): CRM_Core_Form->mainProcess()
#8 /var/.../wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform()
#9 /var/.../wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle()
#10 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(355): HTML_QuickForm_Page->handle()
#11 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/Page/Basic.php(364): CRM_Core_Controller->run()
#12 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/Page/Basic.php(170): CRM_Core_Page_Basic->edit()
#13 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Admin/Page/Job.php(140): CRM_Core_Page_Basic->run()
#14 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(322): CRM_Admin_Page_Job->run()
#15 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(69): CRM_Core_Invoke::runItem()
#16 /var/.../wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke()
#17 /var/.../wp-content/plugins/civicrm/civicrm.php(1199): CRM_Core_Invoke::invoke()
#18 /var/.../wp-includes/class-wp-hook.php(310): CiviCRM_For_WordPress->invoke()
#19 /var/.../wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters()
#20 /var/.../wp-includes/plugin.php(517): WP_Hook->do_action()
#21 /var/.../wp-admin/admin.php(259): do_action()
#22 {main}
```5.67.1https://lab.civicrm.org/dev/core/-/issues/4750clear cache does not reliably remove durable temp tables2023-11-04T16:45:03Zlcdwebclear cache does not reliably remove durable temp tablesDurable (civicrm_tmp_d%) temp tables are intended for use when the table must be used in multiple transactions and therefore cannot be a true MySQL temp table. These should be cleared out when the clean cache function is triggered from t...Durable (civicrm_tmp_d%) temp tables are intended for use when the table must be used in multiple transactions and therefore cannot be a true MySQL temp table. These should be cleared out when the clean cache function is triggered from the UI, scheduled jobs, or CLI -- with a few exceptions for those created within the last two days or that are tied to the civicrm_user_job table. Currently there is faulty logic that causes them to persist much longer than necessary, thus cluttering the DB.lcdweblcdwebhttps://lab.civicrm.org/dev/core/-/issues/4749PHP8 Fatal error when adding files on Case custom field2023-11-08T20:40:37ZPradeep Nayakpradpnayak@gmail.comPHP8 Fatal error when adding files on Case custom fieldReplicated on https://dmaster.demo.civicrm.org/civicrm/case/cd/edit?cgcount=1&action=update&reset=1&type=Case&entityID=1&groupID=4&cid=160&subType=1
Error:
TypeError: strtolower(): Argument #1 ($string) must be of type string, array giv...Replicated on https://dmaster.demo.civicrm.org/civicrm/case/cd/edit?cgcount=1&action=update&reset=1&type=Case&entityID=1&groupID=4&cid=160&subType=1
Error:
TypeError: strtolower(): Argument #1 ($string) must be of type string, array given in strtolower() (line 1423 of /srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/DAO.php).
Steps to replicate:
1. Create custom sets for case, add file type custom field.
2. Create a case
3. On manage case screen, click on Edit button under custom group set, and try to upload a file
File is uploaded but system throws fatal error.
Backtrace:
````
#0 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(1418): CRM_Core_Error::backtrace()
#1 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/BAO/CustomField.php(1323): CRM_Core_DAO::getFieldValue("CRM_Core_DAO_File", (Array:2), "id", "uri")
#2 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/BAO/CustomField.php(1193): CRM_Core_BAO_CustomField::formatDisplayValue((Array:2), (Array:45), 100025185)
#3 /var/sites//drupal10/vendor/civicrm/civicrm-core/api/v3/CustomValue.php(425): CRM_Core_BAO_CustomField::displayValue((Array:2), Object(CRM_Core_BAO_CustomField), 100025185)
#4 /var/sites//drupal10/vendor/civicrm/civicrm-core/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_custom_value_getdisplayvalue((Array:4))
#5 /var/sites//drupal10/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(158): Civi\API\Provider\MagicFunctionProvider->invoke((Array:8))
#6 /var/sites//drupal10/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest((Array:8))
#7 /var/sites//drupal10/vendor/civicrm/civicrm-core/api/api.php(133): Civi\API\Kernel->runSafe("CustomValue", "getdisplayvalue", (Array:4))
#8 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Case/Form/CustomData.php(184): civicrm_api3("CustomValue", "getdisplayvalue", (Array:4))
#9 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Case/Form/CustomData.php(127): CRM_Case_Form_CustomData->formatCustomDataChangesForDetail((Array:20))
#10 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/Form.php(624): CRM_Case_Form_CustomData->postProcess()
#11 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/QuickForm/Action/Upload.php(153): CRM_Core_Form->mainProcess()
#12 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/QuickForm/Action/Upload.php(120): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Case_Form_CustomData), "upload")
#13 /var/sites//drupal10/vendor/civicrm/civicrm-packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Case_Form_CustomData), "upload")
#14 /var/sites//drupal10/vendor/civicrm/civicrm-packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Case_Form_CustomData), "upload")
#15 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/Controller.php(355): HTML_QuickForm_Page->handle("upload")
#16 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Utils/Wrapper.php(98): CRM_Core_Controller->run()
#17 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(292): CRM_Utils_Wrapper->run("CRM_Case_Form_CustomData", "Case Custom Set", (Array:0))
#18 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(69): CRM_Core_Invoke::runItem((Array:18))
#19 /var/sites//drupal10/vendor/civicrm/civicrm-core/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:4))
#20 /var/sites//drupal10/web/modules/contrib/civicrm/src/Civicrm.php(88): CRM_Core_Invoke::invoke((Array:4))
#21 /var/sites//drupal10/web/modules/contrib/civicrm/src/Controller/CivicrmController.php(83): Drupal\civicrm\Civicrm->invoke((Array:4))
#22 [internal function](): Drupal\civicrm\Controller\CivicrmController->main((Array:4), "")
#23 /var/sites//drupal10/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array((Array:2), (Array:2))
#24 /var/sites//drupal10/web/core/lib/Drupal/Core/Render/Renderer.php(592): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#25 /var/sites//drupal10/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(124): Drupal\Core\Render\Renderer->executeInRenderContext(Object(Drupal\Core\Render\RenderContext), Object(Closure))
#26 /var/sites//drupal10/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext((Array:2), (Array:2))
#27 /var/sites//drupal10/vendor/symfony/http-kernel/HttpKernel.php(182): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#28 /var/sites//drupal10/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#29 /var/sites//drupal10/web/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#30 /var/sites//drupal10/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#31 /var/sites//drupal10/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#32 /var/sites//drupal10/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#33 /var/sites//drupal10/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#34 /var/sites//drupal10/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#35 /var/sites//drupal10/web/core/lib/Drupal/Core/StackMiddleware/StackedHttpKernel.php(51): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#36 /var/sites//drupal10/web/core/lib/Drupal/Core/DrupalKernel.php(704): Drupal\Core\StackMiddleware\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, TRUE)
#37 /var/sites//drupal10/web/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#38 {main
````
API params for getdisplayvalue
````
Array ( [custom_field_id] => 30 [entity_id] => 100025185 [custom_field_value] => Array ( [id] => 201 [data] => ) )
````https://lab.civicrm.org/dev/core/-/issues/4748PHP 8 - Fatal error in CRM_Contribution_Form_ContributionCharts, passes subst...2023-11-08T20:40:11ZFrancis (Agileware)PHP 8 - Fatal error in CRM_Contribution_Form_ContributionCharts, passes substring instead of int to mktime() in year fieldOverview
----------------------------------------
Contribution Dashboard crashes due to incorrectly passed arguments in the charts implementation
Reproduction steps
----------------------------------------
1. Use PHP version 8.1
2. Have...Overview
----------------------------------------
Contribution Dashboard crashes due to incorrectly passed arguments in the charts implementation
Reproduction steps
----------------------------------------
1. Use PHP version 8.1
2. Have a Contribution with a receive data before Year 1000 (Yes this will be bogus, but data is not always clean)
3. Go to Contributions / Dashboard
Current behaviour
----------------------------------------
CiviCRM site crashes with:
```
Uncaught TypeError: mktime(): Argument #6 ($year) must be of type ?int, string given in /path/to/civicrm/CRM/Contribute/Form/ContributionCharts.php:176
```
Expected behaviour
----------------------------------------
Contributions dashboard is loaded
Environment information
----------------------------------------
* __CiviCRM:__ Master, 5.66.2, 5.67
* __PHP:__ 8.1.25
* __CMS:__ WordPress 6.3.3
Comments
----------------------------------------
Was unable to reproduce this on dmaster, reason being that I don't know *how* the invalid date got in where I found the bug.https://lab.civicrm.org/dev/core/-/issues/4747testRegexpOperators fails on `max`2023-11-04T21:39:46ZtottentestRegexpOperators fails on `max`Starting in 5.68, the test `api\v4\Action\ContactGetTest::testRegexpOperators` appears to be failing consistently on `max` environment (php81 + mysql80).
* Example: https://test.civicrm.org/job/CiviCRM-Core-Matrix/BKPROF=max,CIVIVER=mas...Starting in 5.68, the test `api\v4\Action\ContactGetTest::testRegexpOperators` appears to be failing consistently on `max` environment (php81 + mysql80).
* Example: https://test.civicrm.org/job/CiviCRM-Core-Matrix/BKPROF=max,CIVIVER=master,SUITES=phpunit-api4,label=bknix-tmp/13173/testReport/(root)/api_v4_Action_ContactGetTest/testRegexpOperators/
* List: https://test.civicrm.org/job/CiviCRM-Core-Matrix/BKPROF=max,CIVIVER=master,SUITES=phpunit-api4,label=bknix-tmp/
(*Since this would've gotten through PR review, it probably works on `php81`+`mysql57`. This smells like a mysqld compatibility issue.*)
cc @colemanwhttps://lab.civicrm.org/dev/core/-/issues/4746Standalone - Syntax error2023-11-04T21:40:17ZtottenStandalone - Syntax errorThis appears to be a consistent test-regression circa 5.68.alpha:
* List: https://test.civicrm.org/job/CiviCRM-E2E-Matrix/BKPROF=min,BLDTYPE=standalone-clean,CIVIVER=master,label=bknix-tmp/
* Example: https://test.civicrm.org/job/CiviCR...This appears to be a consistent test-regression circa 5.68.alpha:
* List: https://test.civicrm.org/job/CiviCRM-E2E-Matrix/BKPROF=min,BLDTYPE=standalone-clean,CIVIVER=master,label=bknix-tmp/
* Example: https://test.civicrm.org/job/CiviCRM-E2E-Matrix/BKPROF=min,BLDTYPE=standalone-clean,CIVIVER=master,label=bknix-tmp/6857/console
The test-log shows a PHP fatal:
```
In PasswordReset.php line 23:
[ParseError]
syntax error, unexpected 'string' (T_STRING), expecting function (T_FUNCTIO
N) or const (T_CONST)
```RichRichhttps://lab.civicrm.org/dev/core/-/issues/4745Joomla: Fails to download extension feed2023-11-09T23:56:48ZtottenJoomla: Fails to download extension feedOverview
----------------------------------------
There appears to be a Guzzle conflict when fetching the extension feed on Joomla.
Reproduction steps
----------------------------------------
1. Install CiviCRM on Joomla
1. Navigate to...Overview
----------------------------------------
There appears to be a Guzzle conflict when fetching the extension feed on Joomla.
Reproduction steps
----------------------------------------
1. Install CiviCRM on Joomla
1. Navigate to dashboard
Current behaviour
----------------------------------------
The first pageload fails with:
![Screen_Shot_2023-11-01_at_4.20.15_PM](/uploads/bfab953fd770a8c09af0658b11529f04/Screen_Shot_2023-11-01_at_4.20.15_PM.png)
The NACK is cached for a while, so you won't immediately see the problem again. But we should expect it to recur.
Expected behaviour
----------------------------------------
No crash.
Environment information
----------------------------------------
The "hydra sites" (https://test.civicrm.org/view/Sites/job/hydra-sites/) are clean CMS installations. (They have the Civi source code preloaded -- but the installer hasn't run.) The error was observed on the hydra site for Joomla with CiviCRM `5.67.beta2` circa Nov 1, 2023.
* __Browser:__ Firefox
* __CiviCRM:__ 5.67.beta2
* __PHP:__ 7.4
* __CMS:__ Joomla
* __Database:__ 5.7
* __Web Server:__ Apachehttps://lab.civicrm.org/dev/core/-/issues/4742[PHP 8.1] CRM_Admin_Form_Generic warnings2023-10-31T20:38:36Zjofranzfranz@systopia.de[PHP 8.1] CRM_Admin_Form_Generic warnings## Having
- CiviCRM 5.66.2
- Drupal 10.1.5
- PHP 8.1
## Visiting
- `.../admin/config/development/logging` to enable logs in UI
- `.../civicrm/admin/setting/theisland`
## Expecting
No erros
## Seeing
```
Warning: Undefined array key ...## Having
- CiviCRM 5.66.2
- Drupal 10.1.5
- PHP 8.1
## Visiting
- `.../admin/config/development/logging` to enable logs in UI
- `.../civicrm/admin/setting/theisland`
## Expecting
No erros
## Seeing
```
Warning: Undefined array key "template" in include() (line 5 of sites/default/files/civicrm/templates_c/de_DE/%%0B/0B9/0B956D8A%%Field.tpl.php).
Warning: Undefined array key "help" in include() (line 14 of sites/default/files/civicrm/templates_c/de_DE/%%0B/0B9/0B956D8A%%Field.tpl.php).
Warning: Trying to access array offset on value of type null in include() (line 14 of sites/default/files/civicrm/templates_c/de_DE/%%0B/0B9/0B956D8A%%Field.tpl.php).
Warning: Undefined array key "pre_html_text" in include() (line 23 of sites/default/files/civicrm/templates_c/de_DE/%%0B/0B9/0B956D8A%%Field.tpl.php).
Warning: Undefined array key "post_html_text" in include() (line 26 of sites/default/files/civicrm/templates_c/de_DE/%%0B/0B9/0B956D8A%%Field.tpl.php).
Warning: Undefined array key "documentation_link" in include() (line 30 of sites/default/files/civicrm/templates_c/de_DE/%%0B/0B9/0B956D8A%%Field.tpl.php).
Warning: Trying to access array offset on value of type null in include() (line 30 of sites/default/files/civicrm/templates_c/de_DE/%%0B/0B9/0B956D8A%%Field.tpl.php).
```
---
_internal ref 23127_https://lab.civicrm.org/dev/core/-/issues/4741Error: datefmt_create: invalid locale: U_ILLEGAL_ARGUMENT_ERROR2023-11-02T11:56:43Zaydunsaidan.saunders@squiffle.ukError: datefmt_create: invalid locale: U_ILLEGAL_ARGUMENT_ERROROverview
----------------------------------------
Trying to access some civicrm pages produces "datefmt_create: invalid locale: U_ILLEGAL_ARGUMENT_ERROR"
This is being encountered with php8.1, but not php7.4. It is on Joomla 4, but I d...Overview
----------------------------------------
Trying to access some civicrm pages produces "datefmt_create: invalid locale: U_ILLEGAL_ARGUMENT_ERROR"
This is being encountered with php8.1, but not php7.4. It is on Joomla 4, but I don't think that is the problem.
The Joomla stacktrace is:
```
| # | Function | Location |
|-----|-------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------|
| 1 | () | JROOT/administrator/components/com_civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php:106 |
| 2 | IntlDateFormatter->__construct() | JROOT/administrator/components/com_civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php:106 |
| 3 | PHP81_BC\{closure}() | JROOT/administrator/components/com_civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php:205 |
| 4 | PHP81_BC\{closure}() | |
| 5 | preg_replace_callback() | JROOT/administrator/components/com_civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php:186 |
| 6 | PHP81_BC\strftime() | JROOT/administrator/components/com_civicrm/civicrm/vendor/pear/log/Log.php:887 |
| 7 | Log->formatTime() | JROOT/administrator/components/com_civicrm/civicrm/vendor/pear/log/Log/file.php:294 |
| 8 | Log_file->log() | JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php:601 |
| 9 | CRM_Core_Error::debug_log_message() | JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php:573 |
| 10 | CRM_Core_Error::debug_var() | JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php:442 |
| 11 | CRM_Core_Error::handleUnhandledException() | JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:39 |
| 12 | CRM_Core_Invoke::invoke() | JROOT/components/com_civicrm/civicrm.php:84 |
| 13 | civicrm_invoke() | JROOT/components/com_civicrm/civicrm.php:11 |
| 14 | require_once() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 |
| 15 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() | JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 |
| 16 | Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() | JROOT/libraries/src/Component/ComponentHelper.php:361 |
| 17 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:208 |
| 18 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:249 |
| 19 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:293 |
| 20 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/includes/app.php:61 |
| 21 | require_once() | JROOT/index.php:32 |
```
The error occurs when CRM_Core_Error() tries to write to a logfile - so something should be written to the log, but the act of writing creates a new separate error.
In `JROOT/administrator/components/com_civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php:106` right before the call to `IntlDateFormatter()` `$locale` has the value 'C' which is determined from a call to `setlocale(LC_TIME, '0')`
Other uses of `IntlDateFormatter()` call `CRM_Core_I18n::getLocale()` to find the locale but this call is in the pear log module's compatibility layer for the deprecated `strftime()`.
As an ugly hack, setting `$locale = "en_US";` gets things working again.
Environment information
----------------------------------------
* __CiviCRM:__ _5.66.1_
* __PHP:__ _8.1_ - does not occur with 7.4
* __CMS:__ _Joomla 4_5.67.0https://lab.civicrm.org/dev/core/-/issues/4740Ability to assign a tagset tag to a contact has gone missing if label is diff...2023-11-15T16:15:32ZDaveDAbility to assign a tagset tag to a contact has gone missing if label is different from name1. Create a tagset for contacts (not a bare tag but a tagset).
1. Change the label of the tagset.
2. Add a tag to the tagset.
3. Try to find where on the contact record to apply this tag. There used to be a widget in the Tags accordion. ...1. Create a tagset for contacts (not a bare tag but a tagset).
1. Change the label of the tagset.
2. Add a tag to the tagset.
3. Try to find where on the contact record to apply this tag. There used to be a widget in the Tags accordion. The one for bare tags is there but not for tagsets.5.68.0https://lab.civicrm.org/dev/core/-/issues/4739Fatal Error "invalid locale" with scheduled jobs and tax receipts (and others...2023-11-07T12:25:25ZkcristianoFatal Error "invalid locale" with scheduled jobs and tax receipts (and others) and php 8.1.25 & civicrm 5.66.xAfter updating to php 8.1.25
```
PHP 8.1.25 (cli) (built: Oct 27 2023 13:02:10) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.25, Copyright (c) Zend Technologies
with Zend OPcache v8.1.25, Copyright (c), by Zend Technologies
``...After updating to php 8.1.25
```
PHP 8.1.25 (cli) (built: Oct 27 2023 13:02:10) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.25, Copyright (c) Zend Technologies
with Zend OPcache v8.1.25, Copyright (c), by Zend Technologies
```
Any attempt to call cron (cli with cv, or in the UI) fails with the following erro:
```
[28-Oct-2023 10:50:42 America/New_York] PHP Fatal error: Uncaught IntlException: datefmt_create: invalid locale: U_ILLEGAL_ARGUMENT_ERROR in /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php:105
Stack trace:
#0 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php(105): IntlDateFormatter->__construct()
#1 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php(204): PHP81_BC\{closure}()
#2 [internal function]: PHP81_BC\{closure}()
#3 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php(185): preg_replace_callback()
#4 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/Log.php(887): PHP81_BC\strftime()
#5 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/Log/file.php(294): Log->formatTime()
#6 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(590): Log_file->log()
#7 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(562): CRM_Core_Error::debug_log_message()
#8 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(442): CRM_Core_Error::debug_var()
#9 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException()
#10 /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm.php(1199): CRM_Core_Invoke::invoke()
#11 /home/cvdemo/public_html/wp-includes/class-wp-hook.php(310): CiviCRM_For_WordPress->invoke()
#12 /home/cvdemo/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters()
#13 /home/cvdemo/public_html/wp-includes/plugin.php(517): WP_Hook->do_action()
#14 /home/cvdemo/public_html/wp-admin/admin.php(259): do_action()
#15 {main}
thrown in /home/cvdemo/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/log/php-8.1-strftime.php on line 105
```
I am finding this on:
WP 6.3.2
CiviCRM 5.64.x and greater
The only workaround I could find was temporarily reverting to php 7.45.67.0https://lab.civicrm.org/dev/core/-/issues/4738Fields disappear when there is a number validation in Activity custom fields2023-11-02T15:22:36ZbgmFields disappear when there is a number validation in Activity custom fieldsSeen in #4154, but not a new issue:
- Create a new Custom Group, for Activities
- In that group, create a new custom field of type numeric
Then go to a contact, and create a new activity (ex: meeting), and in the numeric field, enter s...Seen in #4154, but not a new issue:
- Create a new Custom Group, for Activities
- In that group, create a new custom field of type numeric
Then go to a contact, and create a new activity (ex: meeting), and in the numeric field, enter something invalid (ex: 123abc).
Result: validation error causes a fatal error:
![image](/uploads/4507a214a62f15c31b74672d392041cb/image.png)
And the custom fields, which are loaded using ajax, are not displayed.https://lab.civicrm.org/dev/core/-/issues/4737Activity.getFields crashes2023-10-28T01:41:36ZDaveDActivity.getFields crashessyntax 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\Sp...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}"
}
}
```5.68.0https://lab.civicrm.org/dev/core/-/issues/4736New individual popup to create one on-the-fly is popping up the cms user acco...2023-10-27T21:24:50ZDaveDNew individual popup to create one on-the-fly is popping up the cms user account creation form not the usual profile popupe.g. create a contribution. In the contact field choose New Individual.e.g. create a contribution. In the contact field choose New Individual.5.68.0https://lab.civicrm.org/dev/core/-/issues/4735Event Registration Error on Wordpress 6.3.1 Civi 5.63.4 "Could not find valid...2023-12-06T16:06:38Zdarren.woodsEvent Registration Error on Wordpress 6.3.1 Civi 5.63.4 "Could not find valid value for id"Overview
----------------------------------------
When registering for an event, users do not see the configured thank you messge, but instead are shown the error: "Could not find valid value for id"
https://civicrm.stackexchange.com/qu...Overview
----------------------------------------
When registering for an event, users do not see the configured thank you messge, but instead are shown the error: "Could not find valid value for id"
https://civicrm.stackexchange.com/questions/45729/event-registration-error-on-wordpress-6-3-1-civi-5-63-4-could-not-find-valid-va
Reproduction steps
----------------------------------------
1. Configure an event with free online registration and a thankyou message.
2. Register for the event from the event info page.
Current behaviour
----------------------------------------
Users are shown an error: "Could not find valid value for id"
Expected behaviour
----------------------------------------
Thank you message configured in the event should be shown.
Environment information
----------------------------------------
* __Browser: Browser independent.
* __CiviCRM: 5.63.4
* __PHP: 8.1
* __CMS: WordPress 6.3.1
* __Database: MariaDB
* __Web Server: Nginx
Comments
----------------------------------------
This only happens with registering for events using the Civi event info page. If you embed a shortcode for the specific event in a WordPress page then the error is not shown.https://lab.civicrm.org/dev/core/-/issues/4734ADMIN_UI: default checkbox2023-11-03T15:31:20ZGuillaumeSorelADMIN_UI: default checkboxCould it be possible to have checkboxes per default for each new admin screen using SK, so it becomes possible to select multiple lines (for mailings, messages templates, custom fields...) and proceed bulk actions on them, especially del...Could it be possible to have checkboxes per default for each new admin screen using SK, so it becomes possible to select multiple lines (for mailings, messages templates, custom fields...) and proceed bulk actions on them, especially delete?
New SK screens are sweet but actions still need to be proceeded one-by-one.https://lab.civicrm.org/dev/core/-/issues/4733Where art thou APIv4: MailingEventSubscribe Create? Missing parity with civic...2023-11-02T15:16:06Zjustinfreeman (Agileware)Where art thou APIv4: MailingEventSubscribe Create? Missing parity with civicrm_api3('MailingEventSubscribe', 'Create')Where art thou APIv4: MailingEventSubscribe Create? Missing parity with civicrm_api3('MailingEventSubscribe', 'Create')
Agileware Ref: CVAP-50Where art thou APIv4: MailingEventSubscribe Create? Missing parity with civicrm_api3('MailingEventSubscribe', 'Create')
Agileware Ref: CVAP-50https://lab.civicrm.org/dev/core/-/issues/4732Scheduled Reminder select2 fields to save/view correctly2023-10-27T00:41:38Zmagnolia61Scheduled Reminder select2 fields to save/view correctlyI am testing 5.68 (master) and run into a problem with Event Type based scheduled reminders.
I think since the Event Type and Registration status have been changed to select2 values are saved but when I re-edit the reminder the field sh...I am testing 5.68 (master) and run into a problem with Event Type based scheduled reminders.
I think since the Event Type and Registration status have been changed to select2 values are saved but when I re-edit the reminder the field show empty.
![image](/uploads/1b0c39ee96ae06c36c0b8dcf2adc1552/image.png)
This is what is recorded in the database:
![image](/uploads/b9f77048338bd4347da0a6cc96cc94e1/image.png)
When I select a single value the behavior of the participant status is different than for the event types. A single value for the participant status gets saved and shown on re-edit.
![image](/uploads/d0659ed253a2ee37a07f21be2f0d70a8/image.png)
BTW. I confirmed this bug on https://dmaster.demo.civicrm.org/
![image](/uploads/b078da97fc6d141a3a5d7d54cc6c1ec0/image.png)
![image](/uploads/c256cd3bdef9f8980be7ab38fdaeb8ed/image.png)https://lab.civicrm.org/dev/core/-/issues/4731SearchKit/Form Builder: re-positioning menu links column in table display bre...2023-11-02T17:26:41ZtomrosenbloomSearchKit/Form Builder: re-positioning menu links column in table display breaks csv downloadTo reproduce:
1. add a Menu column to a SK table display - it will appear in the last column by default
2. move menu links column to a different position
3. create afform from this display
4. use action menu to download results to csv
5...To reproduce:
1. add a Menu column to a SK table display - it will appear in the last column by default
2. move menu links column to a different position
3. create afform from this display
4. use action menu to download results to csv
5. now check the download - the column data immediately to the right of the menu column is missing and the data in subsequent columns is shifted to the left
I guess this could be due to something not being closed off properly and corrupting the table, and in that case it could be relevant that one of my menu links is `civicrm/case-detail#/?id=[id]`
EDIT: no, don't think it's that: I removed this link and the problem persists5.68.0https://lab.civicrm.org/dev/core/-/issues/4730Case tagsets showing name not label2023-10-30T02:57:49ZDaveDCase tagsets showing name not labelThis isn't fixed by https://lab.civicrm.org/dev/core/-/issues/4727 so must be coming from somewhere else.
Create/edit are ok and bare case tags are ok, but for some reason case tagsets display name.This isn't fixed by https://lab.civicrm.org/dev/core/-/issues/4727 so must be coming from somewhere else.
Create/edit are ok and bare case tags are ok, but for some reason case tagsets display name.5.68.0