Mysql error when caching messages

[zeno.popovici]

RC Crashes on reading certain e-mails due a database insert/update problem.

Error:

SERVICE CURRENTLY NOT AVAILABLE!
Error No. [0x01F4]

Logs:

[09-May-2008 17:45:20 +0300] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE MDB2_STATEMENT_mysql_19daed856e14c18cbb55017768e8805c7867c0507 FROM 'INSERT INTO messages\n         (user_id, del, cache_key, created, idx, uid, subject, `from`, `to`, cc, date, size, headers, structure)\n         VALUES (?, 0, ?, now(), ?, ?, ?, ?, ?, ?, FROM_UNIXTIME(), ?, ?, ?)']
[Native code: 1064]
[Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), ?, ?, ?)' at line 3]
 in /home/www/webmail.ulbsibiu.ro/mail/program/include/rcube_mdb2.inc on line 265

I'm also getting other errors in my log. Don't know if they're related.

[08-May-2008 23:40:46 +0300] DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE MDB2_STATEMENT_mysql_e1e1ef76cd71a8dfcdadc4e81dc49e8a1316e841106 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '156-INBOX.Trash.msg-2676' for key 2]  in /home/www/webmail.ulbsibiu.ro/mail/program/include/rcube_mdb2.inc on line 529

I've attached the messages I could find across affected inboxes that cause the problem.

[alec]

What mysql server version? Did you try with DB driver?

[thomasb]

Empty FROMUNIXTIME(). Fixed in r1390