Problem with a new Maia install

Andre Goree <[email protected]>
Newsgroups gmane.mail.virus.maiamailguard
Message-ID <[email protected]>
Maia is throwing this error in the logs on a brand-new install (FreeBSD 
11.0) whenever I try to receive and email (sent from an external 
domain):

maiad[69818]: (69818-10) TROUBLE in check_mail: Take Action! FAILED: 
DBD::mysql::st execute failed: Column 'autolearn_status' cannot be null 
at /usr/local/sbin/maiad line 4410, <GEN46> line 137.
Jan 25 15:38:29 anet2 maiad[69818]: (69818-10) PRESERVING EVIDENCE in 
/var/maiad/tmp/maia-20170125T153829-69818
Jan 25 15:38:29 anet2 postfix/smtp[20578]: 227C6EBFEB: 
to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, 
delay=1.5, delays=1.3/0/0.01/0.16, dsn=4.5.0, status=deferred (host 
127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=69818-10, 
Take Action! FAILED: DBD::mysql::st execute failed: Column 
'autolearn_status' cannot be null at /usr/local/sbin/maiad line 4410, 
<GEN46> line 137.



I do see that this happened before, but was related to a different 
version of Maia and was fixed (from what I can tell).  See:  
http://lists.purplehat.org/pipermail/pho-postfix/2015-April/001122.html
http://www.ipsure.com/blog/2012/trouble-in-check_mail-spam_scan-failed-dbdmysqlst-execute-failed-column-theme_id-cannot-be-null-at-usrlocalsbinmaiad-line-3408-error-message-thrown-by-maia-mailguard/


Has anyone else run into this issue?


Here are relevant parts of my maia_mail table
(Hopefully this formatting isn't horrid on everyone's email client)

mysql> show columns from 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 |       
          |
+------------------+------------------+------+-----+-------------+----------------+


-- 
Andre Goree
-=-=-=-=-=-
Email     - andre at drenet.net
Website   - http://www.drenet.net
PGP key   - http://www.drenet.net/pubkey.txt
-=-=-=-=-=-

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.