On 24 Jul 2019, at 6:22 pm, Reindl Harald h.reindl@thelounge.net wrote:

Am 24.07.19 um 10:17 schrieb James Brown:

...

On 24 Jul 2019, at 6:12 pm, Reindl Harald h.reindl@thelounge.net wrote:

...

...

no, as the error message obiously states it don't try to add anything to the alias field because it's not listed at all and the field is lacking a default value.

so just open phpMyAdmin and define an empty string as default for the column

Perfect - thanks Reindl.

In Navicat for MySQL I unchecked the ’Not Null’ box and now it all works perfectly.

NOT NULL and default value are completly different worlds

i said make sure there is a default value and not mangle around with random options you obviously don't understand

https://dev.mysql.com/doc/refman/8.0/en/working-with-null.html https://dev.mysql.com/doc/refman/8.0/en/working-with-null.html https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html

Thanks again Reindl.

I’ve now set ‘Default Value’ to ‘EMPTY STRING’.

James.