Roundcube Community Forum

Release Support => Release Discussion => Topic started by: bagu on November 02, 2010, 08:16:32 AM

Title: Php error on v0.4.2
Post by: bagu on November 02, 2010, 08:16:32 AM

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 :

Code: [Select]

[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.

Title: Php error on v0.4.2
Post by: bagu on November 07, 2010, 06:13:20 PM

No one can help me ?

Title: Php error on v0.4.2
Post by: rosali on November 08, 2010, 12:20:57 AM

Is caching enabled? Try to truncate cache table.

Title: Php error on v0.4.2
Post by: bagu on November 08, 2010, 01:32:22 PM

Yes caching is enable, and after a truncate, the problem is still here..

Here are more error messages :

Code: [Select]

[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 ?

Title: Php error on v0.4.2
Post by: rosali on November 09, 2010, 12:47:20 AM

Is the issue solved if you disable caching?

Title: Php error on v0.4.2
Post by: bagu on November 09, 2010, 06:08:28 PM

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.

Title: Php error on v0.4.2
Post by: bagu on November 10, 2010, 04:47:24 PM

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 ?

Title: Php error on v0.4.2
Post by: alec on November 11, 2010, 02:25:40 AM

You could try svn-trunk version. There have been some fixes regarding caching.