Error upgrading from Version 0.1-beta2 to Version 0.1-rc1

[tazmanian]

 I am trying to upgrade from from Version 0.1-beta2 to Version 0.1-rc1
and am receiving the following error when running the mysql.update.sql script. Can someone please tell
me how to fix this. thanks!
 
SQL query:
ALTER TABLE `messages` DROP `body` ,
DROP INDEX `cache_key` ,
ADD `structure` TEXT,
ADD UNIQUE `uniqueness` ( `user_id` , `cache_key` , `uid` ) ;



MySQL said:

#1062 - Duplicate entry '4-INBOX.msg-390' for key 2
 
and here is the script that was supplied to upgrade:
 

-- RoundCube Webmail update script for MySQL databases
-- Updates from version 0.1-beta and 0.1-beta2
 
ALTER TABLE `messages`
 DROP `body`,
 DROP INDEX `cache_key`,
 ADD `structure` TEXT,
 ADD UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`);
 
ALTER TABLE `identities`
 ADD `html_signature` tinyint(1) default 0 NOT NULL;
 
-- Uncomment these lines if you're using MySQL 4.1 or higher
ALTER TABLE `users`
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci,
CHANGE `username` `username` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_
general_ci NOT NULL,
CHANGE `alias` `alias` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_genera
l_ci NOT NULL;

[apollo]

I got the same error, however RC1 is working great without these update.

I think the changes that should be made by that script are ment for upgrading from beta1 to beta2, not for beta2 to rc1. Theres another update-script which is needed for upgrading.

[benedikt]

I use ur thread as it is the same topic even not the same problem, ok?

I also wanted to upgrade my beta2 but after copying the index.php only, I can only see sth like this when I enter the URL in my Firefox:

‹������lQÃÂ'Ã,ªÃ›0}ïWÃ,¨â€ =6n Ã...Â'Ã,µ$Ã,Ãž$c…ÞÃ,¶dÃ,¹l{tb-1sí`Ã,«Ã,·-ìãçÃ,¤wcÃ...Â'=Xâ€Â"l)âÂ,,¢ÇÃ,¼Ã¾v*Ã,¡Ã,§Ã,³â€ ÃÂ"ËÃÂ"~â€Â"[pþ%Î9/êÃ,¾~Ã,ªÃ...¸Ã·Ã,°Ã... â€Â"P;aÃ,¼"eÃ,ÃÃ...Â"â€Â"Ã,¬'6Ã...Â"_Ã,¯Ã—èGÖuÃ,¼Ã,®Ã¸mÃ,¬Ã,µÁoî‚þBF’$ËfÉDx;kãÃÂ"ÿ”YÃ,­Ã—ëÃ...¡eIÃ,B)ÃÂ'˜Uöbd~iðçÃ,³P6PVÕÃ,±â€šÃ·Ã‹8áÃ,Ã...Â'YÃ,¢â€¢Ã¹
uÊ<Ý5ú‘Ð}À”ÞˆÃ,·Ãž3è~OÙàlçÃÂ,,âÂ,,¢OâÂ,,¢ÃÂ'ôÁC þFÚXyÏfÃ,\4Ã,¡Ã,±NÃ,¢KÙ’A‹Z{1Ã,´ÃŠtâAHù;Ã,¾*I}ÊVËåÃ,»@…Ã,ªÃ«)eBÃ,%äÃÂ,‘ Ã,´ÃªLÊZ4„Ã...½Ã,$RÃ,½Ã...½â€œâ€°Ã,¡Ã•ÃÂ,‡Ã,¹ sÖ-&U,+Ã,¶ÃµÃ¶iûÃ,¹|Þ@~<ÊÃ,¼ÃžðqÃ,»Ã›â€Â"ÃÂ...<4üð<fÙ‹âÂ,,¢Ã,â€¦Ã–ÆÂ'-Ã,.õRiÃÂ,ãÃ,¬â€œÃ,¬â€¹ áÃ8Ã,©Ã,©Ã«p“Ì‚qÃ,£Ã,¹Ã,¦Ã,·Ã‡Ã¸Bca“Ù/���ÿÿ�Ã,µDqÃ,¹n��

I dont know where the problem is. I turned off safe_mode, I switched off MagicQuotes, but still...
I also downloaded from another sourceforge-server but I cant get it to work.

Is there any experience with this problem?

[SKaero]

The errors should be fixed it do all of the steps,

• replace index.php
• replace all files in folder /program/
• replace all files in folder /skins/default/
• run all commands in SQL/*.update.sql or re-initalize database with *.initial.sql
• add these lines to /config/main.inc.php

$rcmail_config['draft_autosave'] = 300;
$rcmail_config['date_today'] = 'H:i';

• If you have LDAP servers configured, change prop key 'mail_field'

to 'email_field' for each server confgured in /config/main.inc.php
[/list]

[tazmanian]

I have done everything starting at step 1 including the following:
replace index.php
replace all files in folder /program/
replace all files in folder /skins/default/

it is at the next point that the problem from above begins.
run all commands in SQL/*.update.sql

since my database is in mysql. I run the mysql.update.sql included with the new build and that is when the following error occurs:
MySQL said:

#1062 - Duplicate entry '4-INBOX.msg-390' for key 2
and so I stop at this point. Luckily, I mad a copy of the whole roundcube directly before I tried the upgrade and I am able at this point to go back to my original build (Version 0.1-beta2) and it works fine. Fixes!! Please help. I really would like to get this upgraded to the newer build as we like the product.

[benedikt]

I did as explained in the INSTALL, as I replaced the whole folder where RC is installed. I used the mysql-initial and changed the configuration.

Its just strange that the old version works, the new doesnt.