Upgrade Problem - 0.1beta2 to 20070108

[Bladez]

Greetings All,

 I am trying to update my roundcube to the nightly as I have been experiencing some weird problems. I figured I'd try the most recent nightly. Well I went to do the SQL updates and when trying to run this:

ALTER TABLE `messages`
 DROP `body`,
 DROP INDEX `cache_key`,
 ADD `structure` TEXT,
 ADD UNIQUE `uniqueness` (`cache_key`, `uid`);

I get this error from MySQL:

Duplicate entry 'INBOX.msg-2' for key 2


Any ideas on why this is there and how I can fix it?

FYI, it's MySQL5 and PHP 5.1.2.

[bazzo]

Ive got the same error message when i upgraded my version.
I just deleted all the rows in the "messages" table.

Heres what u have to do:
1. Empty all rows inn the "messages" table inn the databse.
2. Run the update again.

[Bladez]

My only question, is will removing the entries from the messages table mean that all the end users won't see that mail anymore?

[bazzo]

They will be synced (downloaded) from the imap server on their next login.
I had no problems when i did it like this, but no guaranties