~cypheon/nextcloud-chores#1: 
Cannot create first/new chore

After installing Chores to NC 25.05, I need to set up the first team. When entering a name and clicking the arrow, it seems nothing happens. This error message (HTTP 500) gets thrown though on this call: POST https://cloud.myserver.com/index.php/apps/chores/api/v1.0/team Technical details

Remote Address: ***
Request ID: yx2GQnqu1muMNE0sueGI
Type: OC\DB\Exceptions\DbalException
Code: 1364
Message: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'content' doesn't have a default value
File: /var/www/html/nextcloud/lib/private/DB/Exceptions/DbalException.php
Line: 71
Status
RESOLVED FIXED
Submitter
~jurgeng
Assigned to
No-one
Submitted
1 year, 7 months ago
Updated
1 year, 7 months ago
Labels
No labels applied.

~cypheon 1 year, 7 months ago

Hi, thank you for the detailed error description! I'll have a look at this during the week and provide an updated version. The fix is probably something simple like adding a default value to a query... Are you using MySQL? Until now, I only tested with Postgres so I suspect it's something DBMS-sepcific...

~cypheon REPORTED FIXED 1 year, 7 months ago

Hi, with a MariaDB/MySQL DB I was able to reproduce the issue, with a small change I could provide the missing default value that the DBMS complains about.

I just released a 0.0.4 nightly version that should fix the issue. Please let me know if you run into other issues or not-implemented use cases :)

~jurgeng 1 year, 7 months ago*

Hi, yes. We are indeed running MySQL. I'll have a look to upgrade the version. It's not propagating into Nextcloud yet.

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