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

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

On 24 Jul 2019, at 6:12 pm, Reindl Harald <h.reindl at thelounge.net> wrote:
> Am 24.07.19 um 10:08 schrieb James Brown:
>> [1364] Field 'alias' doesn't have a default value (SQL Query: INSERT INTO `users` (`created`, `last_login`, `username`, `mail_host`, `language`) VALUES (now(), now(), ‘myuser at bordo.com.au', 'mail.bordo.com.au', 'en_US'))
>> So looks like the problem is that it can’t add anything to the ‘alias’ field?
> 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.

Thanks for you fast reply.


More information about the users mailing list