Description
Steps to reproduce:
- Start with a fresh (not already upgraded) WebTop installation that have task service v.5.3.0
- Create a new task, fill details and save
Expected behaviour:
- New task is created
Current behaviour:
- A generic error is displayed. Under the hood the below db error is thrown.
Caused by: org.jooq.exception.DataAccessException: SQL [insert into "tasks"."tasks" ("task_id", "category_id", "revision_status", "revision_timestamp", "public_uid", "subject", "description", "start_date", "due_date", "completed_date", "importance", "is_private", "status", "completion_percentage", "reminder_date", "reminded_on", "revision_sequence", "href", "etag", "creation_timestamp") values (?, ?, ?, cast(? as timestamp), ?, ?, ?, cast(? as timestamp), cast(? as timestamp), cast(? as timestamp), ?, ?, ?, ?, cast(? as timestamp), cast(? as timestamp), ?, ?, ?, cast(? as timestamp))]; ERROR: null value in column "creation_timestamp" violates not-null constraint Detail: Failing row contains (12, 13, N, 2019-04-19 10:57:39.196+02, 0, null, dc34c2491511eadd57d9d058c7356671@studiorocchi.net, test, null, null, null, null, 1, f, notstarted, 0, null, null, null, null). at org.jooq.impl.Utils.translate(Utils.java:1553) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:609) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:355) ... 63 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "creation_timestamp" violates not-null constraint Detail: Failing row contains (12, 13, N, 2019-04-19 10:57:39.196+02, 0, null, dc34c2491511eadd57d9d058c7356671@studiorocchi.net, test, null, null, null, null, 1, f, notstarted, 0, null, null, null, null).