Opened 4 years ago

Closed 4 years ago

#1486052 closed Bugs (fixed)

rcube_mdb2.php (627): MDB2 Error

Reported by: duelli Owned by:
Priority: 5 Milestone: 0.3.1
Component: Database Version: git-master
Severity: normal Keywords: MySQL
Cc:

Description

We are using a Debian Etch server with MySQL 5.0 for Roundcube.

After a recent SVN update I get the following error message

<b>DB Error in /srv/roundcube/program/include/rcube_mdb2.php (627):</b>&nbsp;MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_6e69e6ded2043f2275912e3dc048b812f91bb22a4 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '1-INBOX.msg-11281' for key 2] <br />

This does not only happen on my account, but also on others with this server.

We already had this error some time ago, and I then solved it by clearing some of Roundcube's MySQL tables.

In spite of this error message, Roundcube itself works flawlessly.

Change History (4)

comment:1 Changed 4 years ago by alec

  • Milestone changed from later to 0.3-stable

comment:2 follow-up: Changed 4 years ago by duelli

I commented on this issue several weeks ago on

​http://trac.roundcube.net/ticket/1485961#comment:8

as these two bugs might be related?!

comment:3 in reply to: ↑ 2 Changed 4 years ago by alec

Replying to duelli:

as these two bugs might be related?!

I don't think so.

comment:4 Changed 4 years ago by alec

  • Resolution set to fixed
  • Status changed from new to closed

Fixed in [59395e7e]. Requires "DELETE FROM messages".

Note: See TracTickets for help on using tickets.