Ticket #1485055 (closed Bugs: fixed)

Opened 21 months ago

Last modified 21 months ago

Mysql error when caching messages

Reported by: zeno.popovici Owned by:
Priority: 3 Milestone: 0.2-alpha
Component: Database Version: 0.1.1
Severity: normal Keywords:
Cc:

Description

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.

Attachments

rouncube_error_mail1.txt (4.4 KB) - added by zeno.popovici 21 months ago.
rouncube_error_mail2.txt (2.9 KB) - added by zeno.popovici 21 months ago.
rouncube_error_mail3.txt (2.3 KB) - added by zeno.popovici 21 months ago.

Change History

Changed 21 months ago by zeno.popovici

Changed 21 months ago by zeno.popovici

Changed 21 months ago by zeno.popovici

Changed 21 months ago by alec

  • summary changed from RC Crashes With Error No. [0x01F4] to Mysql error when caching messages

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

Changed 21 months ago by thomasb

  • status changed from new to closed
  • resolution set to fixed

Empty FROMUNIXTIME(). Fixed in r1390

Note: See TracTickets for help on using tickets.