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

[Vincent Bernat]

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.
-- 
I WILL NOT TRADE PANTS WITH OTHERS
I WILL NOT TRADE PANTS WITH OTHERS
I WILL NOT TRADE PANTS WITH OTHERS
-+- Bart Simpson on chalkboard in episode 7F05
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-roundcube-maintainers/attachments/20110122/3d9bf4fc/attachment.pgp>