[RCU] Login failing, Dovecot shows login followed by logout

James Brown jlbrown at bordo.com.au
Wed Jul 24 10:34:27 CEST 2019


On 24 Jul 2019, at 6:22 pm, Reindl Harald <h.reindl at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.roundcube.net/pipermail/users/attachments/20190724/670d4316/attachment.html>


More information about the users mailing list