On 24 Jul 2019, at 6:22 pm, Reindl Harald <[email protected]> wrote:
>
> Am 24.07.19 um 10:17 schrieb James Brown:
>> On 24 Jul 2019, at 6:12 pm, Reindl Harald <[email protected]> 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.
_______________________________________________
Roundcube Users mailing list
[email protected]
http://lists.roundcube.net/mailman/listinfo/users
