Re: autolearn_status error Ubuntu 18.04 LTS
"Janky Jay, III" <[email protected]>
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <[email protected]> |
Thank you! On 5/12/20 3:49 PM, jjs - mainphrame wrote: > It's odd that column was set up with the NOT NULL restriction, since > it doesn't seem to be used, and is null on every row here. > > Seeing the error apparently depends on whether the mysql install is > set to strict mode. > > In any case, for those who want to use mysql and not mariadb, this > cleared it up here. > > mysql> describe maia_mail; > +------------------+------------------+------+-----+-------------+----------------+ > | Field | Type | Null | Key | Default | > Extra | > +------------------+------------------+------+-----+-------------+----------------+ > | id | int(10) unsigned | NO | PRI | NULL | > auto_increment | > | received_date | datetime | NO | MUL | NULL | > | > | size | int(10) unsigned | NO | | NULL | > | > | sender_email | varbinary(255) | NO | MUL | NULL | > | > | envelope_to | blob | NO | | NULL | > | > | subject | varchar(255) | NO | MUL | NULL | > | > | contents | longblob | NO | | NULL | > | > | score | float | YES | MUL | NULL | > | > | autolearn_status | varchar(15) | NO | | unavailable | > | > +------------------+------------------+------+-----+-------------+----------------+ > 9 rows in set (0.00 sec) > > mysql> ALTER TABLE maia_mail MODIFY autolearn_status varchar(15); > Query OK, 0 rows affected (0.45 sec) > Records: 0 Duplicates: 0 Warnings: 0 > > mysql> describe maia_mail; > +------------------+------------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra > | > +------------------+------------------+------+-----+---------+----------------+ > | id | int(10) unsigned | NO | PRI | NULL | > auto_increment | > | received_date | datetime | NO | MUL | NULL | > | > | size | int(10) unsigned | NO | | NULL | > | > | sender_email | varbinary(255) | NO | MUL | NULL | > | > | envelope_to | blob | NO | | NULL | > | > | subject | varchar(255) | NO | MUL | NULL | > | > | contents | longblob | NO | | NULL | > | > | score | float | YES | MUL | NULL | > | > | autolearn_status | varchar(15) | YES | | NULL | > | > +------------------+------------------+------+-----+---------+----------------+ > 9 rows in set (0.02 sec) > > mysql> > > Jake > > On Tue, May 12, 2020 at 2:38 PM Janky Jay, III <[email protected] > <mailto:[email protected]>> wrote: > > On 5/12/20 12:28 PM, Alexandre Takacs wrote: > > > >> Hello Everyone, > >> > >> I've been out of the loop for a long while and decided to try the > >> latest build using the install script on Ubuntu 18.04 LTS. > Everything > >> seemed to go along just fine and I am testing with a domain and > >> getting the following error. > > > > As a quick fix change column 'autolearn_status' to allow null ? > > > > Worth a try IMHO > > This ... > > I've also seen other people having this issue with MySQL in the > past and > allowing NULL by altering the "autolearn_status" column fixed the > issue. > > Regards, > Janky Jay, III > > _______________________________________________ > Maia-users mailing list > [email protected] <mailto:[email protected]> > http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users > _______________________________________________ Maia-users mailing list [email protected] http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users