[Pkg-roundcube-maintainers] Bug#610725: roundcube 0.5-1 upgrade from 0.3.1-6

[bubulak]

thanks ... that was it ...
i just make mysqldump with --no-create-info --no-create-db 
--skip-add-drop-table, then remove completly roundcube 0.3.1-6, drop db 
, drop user, install 0.3.1-6 again and import only values from sql dump.
and finaly upgrade to 0.5-2 works without error

once again thank for help
best regards
vlado

On 01/22/2011 05:32 PM, Vincent Bernat wrote:
> OoO Vers la  fin de l'après-midi du samedi 22  janvier 2011, vers 16:23,
> bubulak<vb at radiolan.sk>  disait :
>
>> I tried following steps but for user roundcube seams to not be working.
> mysql>  show table status
>
>> BEGIN
>> source /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
>> show innodb status
>> ROLLBACK
>> ;
>
> Sorry, the actual stuff that you need to type is :
>
> BEGIN;
> source /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
> show innodb status;
> ROLLBACK;
>
>> ALTER TABLE `messages` DROP FOREIGN KEY `user_id_fk_messages`
>> Cannot find a constraint with the given id user_id_fk_messages.
>
> The upgrade  file seems to have  been half played. Or  maybe the foreign
> key  never  existed.  Do  you  remember what  is  the  first version  of
> roundcube that you did install? Is it 0.3.1 or an earlier version?
>
> To solve  your problem, the easiest  way would be to  play 0.5-1 upgrade
> file by hand into the mysql interpreter. Ignore any error that you could
> get in the process.