no birthday date possible in contacts from shared addressbooks

[robi-00]

Describe the bug

on shared addressbooks

• it is not possible to save contact changes when a birthday date is set

• changes or create new contacts have the same issue (only if birthday is set)

• if a contact has a birthday it is not possible to move it to a shared addressbook

• old contact can have birthday but can not be changed any more

Steps to reproduce

1. Go to 'contacts' in a shared addressbook
2. edit a contact with birthday
3. make any change and try to save -> errormessage will be displayed (unable to update contact)
4. delete the birthday
5. click on save -> no error

Expected behavior

no error on saving contacts

Actual behavior

no error

Contact version

5.3.2

Operating system

Linux 5.15.116

PHP engine version

PHP 8.1

Web server

Apache (supported)

Database

MySQL

Additional info

errormessage in nextcloud log
OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x8E\x82 A...' for column nextcloud.oc_calendarobjects_props.value at row 1

[robi-00]

why to nobody check if have the same issue?

[robi-00]

i fixed it not realy but it works for me now with no error!
disabled to create a calendar with the birthdays in the general groupware settings in nextcloud
it looks like this gives the issue because if i enable this funktion back saving a contact with a birthday is not possible!!!

maybe onse some will fix the issue

[operator2010]

Same issue: for me its not possible to add or change birth date for a contact after creation in shared group folder :(
Hope for a fix in contacts app...

[MichaelPihlblad]

same problem here.
issue posted in calendar repo: nextcloud/calendar#5716

other related issue in contacts repo: #3712