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

bubulak vb at radiolan.sk
Sat Jan 22 17:48:45 UTC 2011

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

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
>> source /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
>> show innodb status
>> ;
> Sorry, the actual stuff that you need to type is :
> source /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
> show innodb status;
>> 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.

More information about the Pkg-roundcube-maintainers mailing list