After changing the lat and lng fields of the location records from double2 to a text field with only eval=trim the default value has become an empty string but the database column definition is a double (default '0' not null). An empty string does not trigger the use of the default value but MySQL/MariaDB complains about the fact that an empty string is not a valid double value.
For the time being I've set the TCA default to 0 (zero) but this results in every location by default record having the location of the "Null island" (a place in the Gulf of Guinea where a nice buoy is located). Perhaps it could be made nullable and if you really want to have the deluxe version a custom eval rule for a float number.
After changing the lat and lng fields of the location records from double2 to a text field with only eval=trim the default value has become an empty string but the database column definition is a double (default '0' not null). An empty string does not trigger the use of the default value but MySQL/MariaDB complains about the fact that an empty string is not a valid double value.
For the time being I've set the TCA default to 0 (zero) but this results in every location by default record having the location of the "Null island" (a place in the Gulf of Guinea where a nice buoy is located). Perhaps it could be made nullable and if you really want to have the deluxe version a custom eval rule for a float number.