Author Topic: Php error on v0.4.2  (Read 2521 times)

Offline bagu

  • Full Member
  • ***
  • Posts: 109
    • Bagu.biz
Php error on v0.4.2
« 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.

Offline bagu

  • Full Member
  • ***
  • Posts: 109
    • Bagu.biz
Php error on v0.4.2
« Reply #1 on: November 07, 2010, 06:13:20 PM »
No one can help me ?

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Php error on v0.4.2
« Reply #2 on: November 08, 2010, 12:20:57 AM »
Is caching enabled? Try to truncate cache table.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline bagu

  • Full Member
  • ***
  • Posts: 109
    • Bagu.biz
Php error on v0.4.2
« Reply #3 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 ?

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Php error on v0.4.2
« Reply #4 on: November 09, 2010, 12:47:20 AM »
Is the issue solved if you disable caching?
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline bagu

  • Full Member
  • ***
  • Posts: 109
    • Bagu.biz
Php error on v0.4.2
« Reply #5 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.

Offline bagu

  • Full Member
  • ***
  • Posts: 109
    • Bagu.biz
Php error on v0.4.2
« Reply #6 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 ?

Offline alec

  • Hero Member
  • *****
  • Posts: 1,152
Php error on v0.4.2
« Reply #7 on: November 11, 2010, 02:25:40 AM »
You could try svn-trunk version. There have been some fixes regarding caching.