id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
1485055,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.",Bugs,closed,3,0.2-alpha,Database,0.1.1,normal,fixed,,