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)
What a Version of RC ?
0.2.1 or trunk ?
i have a similar error by trunk
oh, yes... sorry, forgot to mention:
error comes up in both versions!
0.2.1 release and newest trunk - same error!
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.
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...
Drop a ticket @ RoundCube Webmail (http://trac.roundcube.net)
I/we are not members of devs team.