mysql update ERROR

[vgelias]

I'm using a stable 0.1-beta22 in production, I am trying to update to the svn trunk 510. But when I try to update table messages, I cant because the "uniqueness", this is not unique !!!

What I have to do ??

ALTER TABLE messages

DROP body,
DROP INDEX cache_key,
ADD structure TEXT,
ADD UNIQUE uniqueness (user_id, cache_key, uid);

[fourat.zouari]

I think you should find duplicates manually doing :

SELECT COUNT( * ) AS count, user_id, cache_key, uid
  FROM messages
   GROUP BY user_id, cache_key, uid
   HAVING count >1;

[vgelias]

If I just delete the duplicates, this gonna work without problems ?? Do you have a delete schema for me ? :)

[DvD]

I got the same problem, how did you solve it?
Am i supposed to delete the duplicated rows?

[DvD]

I still have the same problem, i can't update roundcube and i really need to.

No one else has got the same problem? vgelias, how did you solve it?

[thomasb]

This table is for caching only and you can clear it before updating:

TRUNCATE TABLE messages;