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.
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.
My only question, is will removing the entries from the messages table mean that all the end users won't see that mail anymore?
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 8)