[0.1rc1] 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

[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.