Hello,
I use roundcube 0.4.2 with hmailserver 5.3.3-b1879, apache 2.2.17, php 5.2.14 and mysql 5.1.51 (innodb) and these plugins :
settings
compose_addressbook
msglistcols
contextmenu
copymessage
hmail_login
hmail_autoresponder
hmail_autoban
hmail_forwarding
hmail_password
hmail_signature
archive
additional_message_headers
show_additional_headers
emoticons
sound_notifier
folderbuttons
jqueryui
message_highlight
And i get these messages in php error logs :
[01-Nov-2010 22:31:38] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_7a382af19d163d2d59d5b8515074e0d2d4d9e266a USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '2-INBOX.msg-179717' for key 'uniqueness']
[02-Nov-2010 11:00:08] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_744b018cb5236c0feea6f4673a8562b90cbe0138f USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '2-INBOX.msg-179718' for key 'uniqueness']
How can i correct this ?
Thanks.
No one can help me ?
Is caching enabled? Try to truncate cache table.
Yes caching is enable, and after a truncate, the problem is still here..
Here are more error messages :
[08-Nov-2010 12:15:52] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_7b71c080fa76e4ca04ef12634454457933d1988b6 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '2-INBOX.msg-179728' for key 'uniqueness']
[08-Nov-2010 15:01:37] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_6717b1c63eab94047e68f2e3ed0fe2ca2400d9840 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '24-INBOX.Samuel.msg-1383' for key 'uniqueness']
My roundcube install hold 5 differents imap server connection.
bagu.bif, bagu.fr, techni-art.com, byjs.fr and runcms.fr
Is there a problem with that ?
Is the issue solved if you disable caching?
I'll test it for 3-4 days to see if it happen again.
But for the moment, there is no more problem.
But it's a bit slow.
OK, the error is not there since i disable caching.
But it's a bit slow without it.
What may i do to correct the error while caching is enable ?
You could try svn-trunk version. There have been some fixes regarding caching.