Re: autolearn_status error Ubuntu 18.04 LTS

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]> 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]
> 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