Roundcube Community Forum

Release Support => Release Discussion => Topic started by: Marq on February 09, 2011, 12:21:58 PM

Title: [0.5] error log spammed with DB-errors after upgrade - help?
Post by: Marq on February 09, 2011, 12:21:58 PM
I recently upgraded to 0.5 using ftp.
I followed the upgrade-instructions and made sure the installer had nothing left to complain about.
Further, I successfully sent the test mail and logged in to my account.

Working with roundcube for just a few hours, I realized my error log gre to >32MB in size since the upgrade. Seems they're all database-related and look like this:

Code: [Select]
[09-Feb-2011 18:02:11] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_6731113c60f44fcb4b52cf7e9a7f1d13c6353f3b533 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '1-INBOX.msg-61770' for key 2]


Any idea how to resolve this?

Thanks in advance,
Marq
Title: [0.5] error log spammed with DB-errors after upgrade - help?
Post by: SKaero on February 10, 2011, 12:04:05 AM
Did you do the database upgrade?
Title: [0.5] error log spammed with DB-errors after upgrade - help?
Post by: Marq on February 10, 2011, 02:55:01 AM
I followed the UPGRADE file included. As the (web)-installer didn't suggest a DB upgrade, I did not run the sql code. The installer message reads

Check DB config
DSN (write):  OK
DB Schema:  OK
DB Write:  OK
DB Time:  OK

Should I try executing the sql anyway?
Title: [0.5] error log spammed with DB-errors after upgrade - help?
Post by: dshepherd on February 10, 2011, 05:43:07 AM
Yes, you'll need to run all the SQL statements in the SQL upgrade file that appear after the version number you upgraded from.
Title: [0.5] error log spammed with DB-errors after upgrade - help?
Post by: HGHAmarion on February 10, 2011, 05:55:24 AM
will you share us the coding of this SQL....

HGH (http://www.hghforsale.org) | HGH injections (http://www.hghforsale.org/are-hgh-injections-are-an-overdose-or-not/)