~cypheon/nextcloud-chores#2: 
Cannot create first chore after creating a team

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"}]}

Status
REPORTED
Submitter
~jurgeng
Assigned to
Submitted
1 year, 6 months ago
Updated
5 months ago
Labels
No labels applied.

~jurgeng 1 year, 6 months ago*

This still exists. Is there something I can do to help you troubleshoot? (give yo an account to the instance? supply debugging info?)

~cypheon 1 year, 5 months ago

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.)

~jurgeng 1 year, 5 months ago

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

~cypheon 1 year, 5 months ago

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.

~joec 1 year, 3 months ago

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.

~menelic 5 months ago

~joec or ~cypheon, could you kindly make these changes to a new version of chores compatible with Nextcloud 29? This would make it possibel for many more people to use chores - and believe me, the functionality is needed and appreciated!

Register here or Log in to comment, or comment via email.