Jake, I used the default install with the local db server.
mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using EditLine wrapper
I did try to set the value in the DB to NO/YES but it doesn’t seem to take
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 | |
+------------------+------------------+------+-----+-------------+----------------+
9 rows in set (0.01 sec)
Thanks,
Dave
From: jjs - mainphrame <[email protected]>
Sent: Tuesday, May 12, 2020 2:24 PM
To: [email protected]
Cc: Maia-Users Mailing List <[email protected]>
Subject: Re: [Maia-users] autolearn_status error Ubuntu 18.04 LTS
Just out of curiosity, was this a default install of a local maia db, or did it use an existing db server?
If so, what db version is it? I'm looking through the schema, and in the maia logs here, and I'm not seeing this rule enforced anywhere
jake
On Tue, May 12, 2020 at 9:02 AM jjs - mainphrame <[email protected] <mailto:[email protected]> > wrote:
Is this happening on every message? Sounds like an error in the DB schema.
jake
On Tue, May 12, 2020 at 8:36 AM <[email protected] <mailto:[email protected]> > 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.
May 12 14:04:59 maia postfix/lmtp[33612]: EECC1859E0: to=<[email protected] <mailto:[email protected]> >, relay=127.0.0.1[127.0.0.1]:10024, delay=0.35, delays=0.22/0/0/0.12, dsn=4.5.0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=21314-03, Take Action! FAILED: DBD::mysql::st execute failed: Column 'autolearn_status' cannot be null at /var/lib/maia/maiad line 4408, <GEN20> line 156. (in reply to end of DATA command))
The Maia server is at the head end, the user account was created in the web interface and there is a transport file and relay_domain mappings file to the recipient email server.
Seems like its something minor but A google search isn’t helping me out
Thanks,
Dave
_______________________________________________
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
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.