nextcloud / contacts

📇 Contacts app for Nextcloud
https://apps.nextcloud.com/apps/contacts
GNU Affero General Public License v3.0
552 stars 168 forks source link

no birthday date possible in contacts from shared addressbooks #3606

Open robi-00 opened 10 months ago

robi-00 commented 10 months ago

Describe the bug

on shared addressbooks

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 commented 9 months ago

why to nobody check if have the same issue?

robi-00 commented 6 months ago

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 commented 5 months ago

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 commented 3 months ago

same problem here. issue posted in calendar repo: https://github.com/nextcloud/calendar/issues/5716

other related issue in contacts repo: #3712