Roundcube Community Forum

 

Problem Upgrading from beta v0.1-beta2.1 to last SVN 451

Started by spwbot, January 08, 2007, 03:46:36 PM

Previous topic - Next topic

spwbot

I cant upgrade the mysql database, i got the next error messege:


ERROR 1062 (23000) at line 4: Duplicate entry 'INBOX.msg-6' for key 2


If i take a look to the messege table it is full of INBOX-msg entry

ÃÂ,Ã,¿?

jpingle

The message table is just the message cache, you should be able to safely delete the contents of that table (DELETE FROM `messages`;) and then retry the update.

Also, if you are running RoundCube on the same server as the IMAP server, you could disable the message cache entirely in config/main.inc.php.

spwbot

What about the uid field?
I have my imap server in other machine so .. thats mean i can delete the entire content of the messeges table without loosing email information?

Best Regards and thank you.

p.d: sorry for my bad english.

jpingle

The UID field in that table is a message's unique ID, but the problem is that it isn't very unique. :) The reason for the changes to the message table were, in part, because of problems with message UID collisions (which you probably have in your table if you got that error)

I'd clear out the table, alter the messages table as it says in the script, and then it should be fine.