[Pkg-roundcube-maintainers] Bug#613586: Still seems to be a problem with upgrades

[Vincent Bernat]

On Mon, 21 Feb 2011 13:25:02 +0000, Mark Syms <mark at marksyms.me.uk> wrote:
> Using 0.5.1+dfsg-3 I get the following error.
> 
> creating database backup in
> /var/cache/dbconfig-common/backups/roundcube_0.3.1-6.mysql.
> applying upgrade sql for 0.3.1-6 -> 0.5-1.
> error encountered processing
> /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1:
> mysql said: ERROR 1060 (42S21) at line 49: Duplicate column name
'changed'

How did you get there? For example, if you downgraded your installation of
0.5.XX to 0.3.1-6 then upgraded again, this is normal. There is no
downgrade procedure using dbconfig-common and the message you get cannot be
avoided. If you aborted the installation of 0.5.XXX, then this is also
normal that you get this message. If you downgraded, then restore a backup
of the database and then upgrade again, this is a problem.

For your specific case, if you just ignore the message, the postinst
script will force the application of the whole upgrade file and your
database will be fully upgraded.