MDB2 Error: null value violates not-null constraint

[MKelma]

hi,

i'm seeing this error in logs, occuring 2 - 5 times a day.
i have no idea, what thing this triggers up - but the error is always the same:

[13-May-2009 14:08:57] MDB2 Error: null value violates not-null constraint (-29): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_8a39c4c6f1f3455cd741620eebb1915ab075b35dd USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1048]
[Native message: Column 'date' cannot be null]

[13-May-2009 14:08:57 +0200] DB Error: MDB2 Error: null value violates not-null constraint Query: _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_8a39c4c6f1f3455cd741620eebb1915ab075b35dd USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1048]
[Native message: Column 'date' cannot be null]  in /...path.../program/include/rcube_mdb2.php on line 553 (GET /rcpath/?_task=mail)

[lacri]

What a Version of RC ?

0.2.1 or trunk ?

i have a similar error by trunk

[MKelma]

oh, yes... sorry, forgot to mention:
error comes up in both versions!
0.2.1 release and newest trunk - same error!

[rosali]

It looks like it tries to cache a message where the date header is missing or couldn't be parsed properly. Try to change roundcube databasetable "messages", column "date" to accept NULL.

[MKelma]

thanks - i changed the NOT NULL setting and the error didn't show up since...

but shouldn't this error/bug be fixed in future versions?
i think this (date==nul/not parsable) should be handled in caching source code...

[rosali]

Drop a ticket @ RoundCube Webmail

I/we are not members of devs team.