MySQL Database Update Error

[dukhunter99]

I upgrading to the new version. I followed the instructions perfectly and I'm getting the following error when I run the sql update. I am running the mysql.update.sql file:

SQL query:

-- 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` ) ;



MySQL said:

#1062 - Duplicate entry '9-INBOX.msg-43' for key 2