DB manager save changes creates invalid change

[mebeingken]

Wappler Version : 4 beta 1
Operating System : mac big sur
Server Model: node
Database Type: maria
Hosting Type: custom

Expected behavior

When a table has a datetime field, it should be null if not set

Actual behavior

It is set as an empty string

How to reproduce

Using a table with a datetime column, the calendar selector pops up immediately after pressing Add New:

If I do not select anything in the calendar, and provide other data and click Save Changes, the following error is produced when attempting to apply the change:

The migration file that results shows created_at being set to an empty string, when it should not be set at all:

exports.up = function(knex) {
  return knex('app_settings').insert({"created_at":"","key":"test","value":"data"})
};

exports.down = function(knex) {
};

[jellederijke]

I experience a similar error.

First I look up a record with Edit Table Data that has a value in a date column. In this case I need to delete this value. However, upon saving the data I get the same error as you do. I’ve tried filling the column with NULL or null, but it yields the same result.

Any advice on how to edit this record successfully from the database manager is greatly appreciated. Or a fix in the next update would be great, too

btw this is on w10 using beta 10.

ps: as a workaround I have now changed the value to 1970-01-01. This is so far out of reach that it is easy to filter out