On 24 Jul 2019, at 6:12 pm, Reindl Harald h.reindl@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@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.
James.