Roundcube Community Forum

Release Support => Pending Issues => Topic started by: spwbot on January 08, 2007, 03:46:36 PM

Title: Problem Upgrading from beta v0.1-beta2.1 to last SVN 451
Post by: spwbot on January 08, 2007, 03:46:36 PM
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

¿?
Title: Re: Problem Upgrading from beta v0.1-beta2.1 to last SVN 451
Post by: jpingle on January 08, 2007, 04:32:39 PM
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.
Title: Re: Problem Upgrading from beta v0.1-beta2.1 to last SVN 451
Post by: spwbot on January 08, 2007, 04:44:59 PM
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.
Title: Re: Problem Upgrading from beta v0.1-beta2.1 to last SVN 451
Post by: jpingle on January 08, 2007, 04:54:12 PM
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.
Title: Re: Problem Upgrading from beta v0.1-beta2.1 to last SVN 451
Post by: spwbot on January 09, 2007, 07:55:46 AM
thank you :)