Error 1364: Field 'id' doesn't have a default value #744

New Issue

alpaka · 2020-12-19T13:30:06Z

alpaka commented

2020-12-19 13:30:06 +00:00

with the latest docker container I am unable to create new tasks and receive the following error messages:

2020-12-19T13:17:08.529316163Z: ERROR   ▶ handler/CreateWeb 174 Error 1364: Field 'id' doesn't have a default value
2020-12-19T13:17:08.529537478Z: WEB     ▶ 192.168.178.50  PUT 500 /api/v1/lists/8 11.486715ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0

I did not modify anything and the setup worked flawless beforehand. The only thing I did was reguraly update the docker containers.

Any ideas what might be causing this?

with the latest docker container I am unable to create new tasks and receive the following error messages: ``` 2020-12-19T13:17:08.529316163Z: ERROR ▶ handler/CreateWeb 174 Error 1364: Field 'id' doesn't have a default value 2020-12-19T13:17:08.529537478Z: WEB ▶ 192.168.178.50 PUT 500 /api/v1/lists/8 11.486715ms - Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0 ``` I did not modify anything and the setup worked flawless beforehand. The only thing I did was reguraly update the docker containers. Any ideas what might be causing this?

konrad commented

2020-12-19 13:45:43 +00:00

Maybe this is cause by b0d4902406

What's your setup? (what db etc?)

Maybe this is cause by https://kolaente.dev/vikunja/api/commit/b0d4902406aeaf572c9ca7f721f64305e8126cec What's your setup? (what db etc?)

konrad added the

kind/bug

label 2020-12-19 13:45:47 +00:00

konrad commented

2020-12-19 13:48:06 +00:00

I can confirm this does not work at least with mysql, but does work with sqlite. (Didn't test postgres yet)

konrad commented

2020-12-19 13:49:54 +00:00

Ouuh so it looks like the changes from b0d4902406 removed the auto increment from the id column(s). Not sure why the tests did not catch that...

Ouuh so it looks like the changes from https://kolaente.dev/vikunja/api/commit/b0d4902406aeaf572c9ca7f721f64305e8126cec removed the auto increment from the id column(s). Not sure why the tests did not catch that...

konrad commented

2020-12-19 13:54:48 +00:00

Looks like this is only an issue with mysql.

konrad referenced this issue from a commit

2020-12-19 14:04:37 +00:00

Fix missing auto increments from b0d4902406 on mysql

konrad closed this issue

2020-12-19 14:04:37 +00:00

konrad commented

2020-12-19 14:04:49 +00:00

Fixed in 9508d0faee

A release should be ready in ~30min.