POST https://cloud.domain.com/index.php/apps/chores/api/v1.0/team/1/chores {"chores":[{"id":-1,"name":"Order Club Mate","due":"2023-04-25T12:00:00+02:00","points":1,"repeat":"s:1:-"}]}
Response: {"result":[{"success":false,"id":null,"error":"unable to persist chore"}]}
This still exists. Is there something I can do to help you troubleshoot? (give yo an account to the instance? supply debugging info?)
Hi, the issue seems to be related to either MariaDB or an older MySQL version not supporting the timezone offset that is appended when storing values in the DB. MySQL supports this since version 8.0.19, MariaDB unfortunately doesn't (see comments at the end of https://jira.mariadb.org/browse/MDEV-11576 ). Is it an option for you to switch to a version of MySQL >= 8.0.19? (I understand if it's not, since depending on the since of your Nextcloud instance this could be quite a major undertaking.)
Just checked, I'm running PHP 7.4.33 and MySQL 10.5.18 I'm running Nextcloud 25.0.5 on Linux 5.10.0-20-amd64 x86_64
Version "10.x" probably means it's a MariaDB (that would explain that error). To verify you can run
SHOW VARIABLES LIKE 'version_comment';
to get the exact variant info.
I am running Nextcloud 25.0.4, PHP 8.1.16, and mysql Ver 15.1 Distrib 10.3.27-MariaDB. I got the same POST response as jurgeng. I changed the formatting of the dates from format('c') to format('Y-m-d H:i:s') in Chore.php. That allowed the creation of new tasks. I also changed the format call in Choremapper.php and WorklogItem.php to get more functionality working.