We are running mariadb version 10.3.27
When trying to insert a record we get the error:
Field 'xxxx' doesn't have a default value
Our admin has to go in and change the sql mode to:
NO_ENGINE_SUBSTITUTION
and the errors go away...
A few weeks, or a month go by and the errors start again.
So our admin has to change the sql mode again...
Trying to change this field to have a default value,
id int(11) not null default none primary auto_increment
This is one of the fields giving us the error, but we can't give it a default value.
We tried this query, but it doesn't work:
alter table `customer` modify `customer_id` int(11) DEFAULT null;