Development issueshttps://lab.civicrm.org/groups/dev/-/issues2024-02-01T10:38:38Zhttps://lab.civicrm.org/dev/core/-/issues/4890CiviCRM could not create trigger2024-02-01T10:38:38ZktatgenhorstCiviCRM could not create triggerOverview
----------------------------------------
_Please describe your problem or bug in detail._
Installation of version 5.69.0 on a fresh Ubuntu install with WordPress.
1. I used this link to setup Wordpress on Ubuntu:
https://ub...Overview
----------------------------------------
_Please describe your problem or bug in detail._
Installation of version 5.69.0 on a fresh Ubuntu install with WordPress.
1. I used this link to setup Wordpress on Ubuntu:
https://ubuntu.com/tutorials/install-and-configure-wordpress#1-overview
2. I followed this set of instructions to install CiviCRM:
https://docs.civicrm.org/installation/en/latest/wordpress/
3. When I go to the installation/setup wizard I add the credentials for the database I created (separate from WP database and the user has grant all and specifically grant trigger on civicrm.*). I did destroy the VM and build a second time with same steps and results.
_If you have already posted on https://civicrm.stackexchange.com or https://chat.civicrm.org, please include the link to that conversation._
I have not posted there, but I see older posts regarding this on previous versions. None of those offer a valid solution for this present issue,
Reproduction steps
----------------------------------------
1. Click on **Contacts -> New Individual**.
1. Entered **First Name** and **Last Name** and clicked **Save**.
1. Got an error "**Fatal error: DB error**".
Current behaviour
The setup stops after DB connect and reports unable to create triggers.
----------------------------------------
_What happens currently. Please provide error messages, screenshots or gifs ([LICEcap](http://www.cockos.com/licecap/), [SilentCast](https://github.com/colinkeenan/silentcast)) where appropriate._
```
TIP: The best way to convey an error message is to copy it in here and use
three backtick ` symbols. You may edit the message to remove private
information (like passwords). The backticks will help to preserve any
special characters or spaces.
```
Expected behaviour
----------------------------------------
_What should happen._
I should pass through the setup screen and have a functioning CiviCRM install.
Environment information
----------------------------------------
<!-- Some of the items below may not be relevant for every bug - if in doubt please include more information than you think is neccessary. -->
Ubuntu 20.04
MySqlD 8.0.35
Php 8.2.4
Apache2 2.4.41
CiviCRM 5.69.0
* __Browser:__ _Firefox 59.0.1/Chrome 78.0.3904/Safari 13_
* __CiviCRM:__ _Master/5.20.0/5.19.1/5.18.2/..._ <!-- If this problem relates to an upgrade, then specify both old and new versions -->
* __PHP:__ _7.0/7.1/7.2/7.3/...__
* __CMS:__ _Backdrop 1.5/Drupal 7.30/Joomla 3.3/WordPress 4.5/..._
* __Database:__ _MySQL 5.7.7/MariaDB 10.4/..._
* __Web Server:__ _Apache 2.4/Nginx 1.16/..._
Comments
----------------------------------------
_Anything else you would like the reviewer to note._
Thank you,
Karl Tatgenhorsthttps://lab.civicrm.org/dev/core/-/issues/49565.69.1 critical error: Undefined array key "crmSearchTasks" in "ext/search_ki...2024-02-07T10:25:28ZDmitry Smirnov5.69.1 critical error: Undefined array key "crmSearchTasks" in "ext/search_kit/search_kit.php" on line 61```
PHP Warning: Undefined array key "crmSearchTasks" in ext/search_kit/search_kit.php on line 61
PHP Warning: Trying to access array offset on value of type null in ext/search_kit/search_kit.php on line 61
PHP Fatal error: Uncaught T...```
PHP Warning: Undefined array key "crmSearchTasks" in ext/search_kit/search_kit.php on line 61
PHP Warning: Trying to access array offset on value of type null in ext/search_kit/search_kit.php on line 61
PHP Fatal error: Uncaught TypeError: in_array(): Argument #2 ($haystack) must be of type array, null given in ext/search_kit/search_kit.php:61
```https://lab.civicrm.org/dev/core/-/issues/4885[5.68.1] Missing Relationship Cache Trigger2024-01-15T11:28:29ZDmitry Smirnov[5.68.1] Missing Relationship Cache TriggerAfter upgrade from 5.53.0 to 5.68.1, _System Status_ page shows "Missing Relationship Cache Trigger" warning.
Attempt to "Rebuild triggers" using the provided button yields no effect.
`civicrm.civicrm_relationship_cache` table have ple...After upgrade from 5.53.0 to 5.68.1, _System Status_ page shows "Missing Relationship Cache Trigger" warning.
Attempt to "Rebuild triggers" using the provided button yields no effect.
`civicrm.civicrm_relationship_cache` table have plenty of records but no triggers.
Debug log is enabled but I could not spot any errors so "rebuilding triggers" appears to fail silently...https://lab.civicrm.org/dev/backdrop/-/issues/67PHP notices when saving permissions form2022-10-21T07:35:43ZbgmPHP notices when saving permissions form*Created by: jenlampton*
When the permissions form is saved (for the first time) the following PHP notices appear at the top of the page:
```
Notice: Constant CIVICRM_UF already defined in Civi\Setup\UI\SetupController->boot() (line 13...*Created by: jenlampton*
When the permissions form is saved (for the first time) the following PHP notices appear at the top of the page:
```
Notice: Constant CIVICRM_UF already defined in Civi\Setup\UI\SetupController->boot() (line 130 of backdrop/docroot/modules/civicrm/setup/src/Setup/UI/SetupController.php).
Notice: Constant CIVICRM_TEMPLATE_COMPILEDIR already defined in Civi\Setup\UI\SetupController->boot() (line 131 of backdrop/docroot/modules/civicrm/setup/src/Setup/UI/SetupController.php).
Notice: Constant CIVICRM_UF_BASEURL already defined in Civi\Setup\UI\SetupController->boot() (line 132 of backdrop/docroot/modules/civicrm/setup/src/Setup/UI/SetupController.php).
```https://lab.civicrm.org/dev/core/-/issues/2611Change default_value column for custom fields from varchar to text2023-08-20T02:32:58ZlarsssandergreenChange default_value column for custom fields from varchar to textA custom field can be of many types, including note. For a custom field that is a note, you may want to use a default value that is longer than 255 characters, but currently the default value is stored as a varchar(255). It would make se...A custom field can be of many types, including note. For a custom field that is a note, you may want to use a default value that is longer than 255 characters, but currently the default value is stored as a varchar(255). It would make sense to change this column to text, so that longer values can be entered.
In the custom fields UI, this field would be changed to a textarea when note is selected.
For us, the use case would be storing the content of a short waiver, so that the exact value of the waiver at the time of signing can be stored on the participant for an event, but I can imagine there may be other use cases.
Will submit PR if supported.https://lab.civicrm.org/dev/user-interface/-/issues/37Selection in quick search result list is not visible2021-08-13T21:27:08Ztimo.kabschSelection in quick search result list is not visibleIn the result list of quick search, the contact to open can be selected by mouse or keyboard (cursor up/down). Previously, the selection of the to-be-opened contact was indicated by a rectangle outline around the contact.
Starting with 5...In the result list of quick search, the contact to open can be selected by mouse or keyboard (cursor up/down). Previously, the selection of the to-be-opened contact was indicated by a rectangle outline around the contact.
Starting with 5.37 or 5.37.1 (probably along the feature of results being "real" links) this selection is not visible anymore.
![QuickSearchResults](/uploads/f940354b2a96d88fae1c7a2757f4de00/QuickSearchResults.jpg)
Environment:
- dmaster on macOS with Safari Version 14.1 (16611.1.21.161.6) and on macOS and Win10 with Chrome Version 90.0.4430.212
- own installation with macOS with Safari Version 14.1 (16611.1.21.161.6)
Steps to reproduce:
1. open dmaster and login
1. in the quick search input field, enter 'd'
1. a search result list appears (Clint Adams, Kiara Adams, Toby Adams, ...)
1. press cursor down two times
1. press enter
What happens?
- when pressing cursor down, the search result list is walked through, but the current selection is not visible
- when pressing enter after two times pressing cursor down, contact 'Kiara Adams' is opened
- when hovering a result in the result list with mouse cursor, the current selection is not visible
What should happen?
- when pressing cursor down, the search result list is walked through, and the current selection is marked by a outline rectangle
- when hovering a result in the result list with mouse cursor, the hovered search result is marked by a outline rectangle5.41.0