<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=791095915-02102007>New to the 
list.  I am trying to upgrade from from Version 0.1-beta2 to Version 
0.1-rc1 </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=791095915-02102007>and am receiving the 
following error when running the mysql.update.sql script.  Can someone 
please tell</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=791095915-02102007>me how to fix 
this.  thanks!</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=791095915-02102007><FONT 
size=2><STRONG></STRONG></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial><SPAN class=791095915-02102007><FONT size=2><STRONG>SQL 
query:</STRONG> </FONT></DIV>
<P><SPAN class=syntax><FONT size=2><SPAN 
class="syntax_alpha syntax_alpha_reservedWord">ALTER</SPAN> <SPAN 
class="syntax_alpha syntax_alpha_reservedWord">TABLE</SPAN> <SPAN 
class="syntax_quote syntax_quote_backtick">`messages`</SPAN> <SPAN 
class="syntax_white syntax_white_newline"></SPAN><SPAN 
class="syntax_alpha syntax_alpha_reservedWord">DROP</SPAN> <SPAN 
class="syntax_quote syntax_quote_backtick">`body`</SPAN> <SPAN 
class="syntax_punct syntax_punct_listsep">,</SPAN><BR><SPAN 
class="syntax_white syntax_white_newline"></SPAN><SPAN 
class="syntax_alpha syntax_alpha_reservedWord">DROP</SPAN> <SPAN 
class="syntax_alpha syntax_alpha_reservedWord">INDEX</SPAN> <SPAN 
class="syntax_quote syntax_quote_backtick">`cache_key`</SPAN> <SPAN 
class="syntax_punct syntax_punct_listsep">,</SPAN><BR><SPAN 
class="syntax_white syntax_white_newline"></SPAN><SPAN 
class="syntax_alpha syntax_alpha_reservedWord">ADD</SPAN> <SPAN 
class="syntax_quote syntax_quote_backtick">`structure`</SPAN> <SPAN 
class="syntax_alpha syntax_alpha_columnType">TEXT</SPAN><SPAN 
class="syntax_punct syntax_punct_listsep">,</SPAN><BR><SPAN 
class="syntax_white syntax_white_newline"></SPAN><SPAN 
class="syntax_alpha syntax_alpha_reservedWord">ADD</SPAN> <SPAN 
class="syntax_alpha syntax_alpha_reservedWord">UNIQUE</SPAN> <SPAN 
class="syntax_quote syntax_quote_backtick">`uniqueness`</SPAN> <SPAN 
class="syntax_punct syntax_punct_bracket_open_round">(</SPAN> <SPAN 
class="syntax_quote syntax_quote_backtick">`user_id`</SPAN> <SPAN 
class="syntax_punct syntax_punct_listsep">,</SPAN> <SPAN 
class="syntax_quote syntax_quote_backtick">`cache_key`</SPAN> <SPAN 
class="syntax_punct syntax_punct_listsep">,</SPAN> <SPAN 
class="syntax_quote syntax_quote_backtick">`uid`</SPAN> <SPAN 
class="syntax_punct syntax_punct_bracket_close_round">)</SPAN> <SPAN 
class="syntax_punct syntax_punct_queryend">;</SPAN><BR><BR></FONT></SPAN></P>
<P><STRONG><FONT size=2>MySQL said: </FONT></STRONG><A 
href="http://dev.mysql.com/doc/mysql/en/error-messages-server.html" 
target=mysql_doc></A><FONT size=2> </FONT></P>
<DIV><CODE><FONT size=2>#1062 - Duplicate entry '4-INBOX.msg-390' for key 2 
</FONT></CODE></DIV>
<DIV><CODE><FONT size=2></FONT></CODE> </DIV>
<DIV><CODE><SPAN class=791095915-02102007><FONT size=2>and here is the script 
that was supplied to upgrade:</FONT></SPAN></CODE></DIV>
<DIV><CODE><SPAN class=791095915-02102007><FONT 
size=2></FONT></SPAN></CODE> </DIV><FONT size=2>
<DIV><BR>-- RoundCube Webmail update script for MySQL databases<BR>-- Updates 
from version 0.1-beta and 0.1-beta2</DIV>
<DIV> </DIV>
<DIV>ALTER TABLE `messages`<BR>  DROP `body`,<BR>  DROP INDEX 
`cache_key`,<BR>  ADD `structure` TEXT,<BR>  ADD UNIQUE `uniqueness` 
(`user_id`, `cache_key`, `uid`);</DIV>
<DIV> </DIV>
<DIV>ALTER TABLE `identities`<BR>  ADD `html_signature` tinyint(1) default 
0 NOT NULL;</DIV>
<DIV> </DIV>
<DIV>-- Uncomment these lines if you're using MySQL 4.1 or higher<BR>ALTER TABLE 
`users`<BR>DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci,<BR>CHANGE 
`username` `username` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE 
utf8_<BR>general_ci NOT NULL,<BR>CHANGE `alias` `alias` VARCHAR( 128 ) CHARACTER 
SET utf8 COLLATE utf8_genera<BR>l_ci NOT NULL;</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV></FONT> </DIV></SPAN></FONT></BODY></HTML>