Bug#613586: Still seems to be a problem with upgrades

2011-02-23 Thread Mark Syms
Having repaired my 0.3.1-6 database by comparing to the install script the upgrade does now complete. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Bug#613586: Still seems to be a problem with upgrades

2011-02-23 Thread Vincent Bernat
On Wed, 23 Feb 2011 09:17:44 +, Mark Syms wrote: Having said that, on 0.3.1-6 grep changed /usr/share/dbconfig-common/data/roundcube/install/mysql shows `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', INDEX `changed_index` (`changed`) `changed` datetime NOT NULL DEFAULT '100

Bug#613586: Still seems to be a problem with upgrades

2011-02-23 Thread Mark Syms
It's posible that I tried retry on the first failure which as you say may have overwritten the backup. Having said that, on 0.3.1-6 grep changed /usr/share/dbconfig-common/data/roundcube/install/mysql shows `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', INDEX `changed_index` (`cha

Bug#613586: Still seems to be a problem with upgrades

2011-02-23 Thread Vincent Bernat
On Mon, 21 Feb 2011 21:51:42 +0100, Vincent Bernat wrote: Got there after applying the dbconfig backup after a previously failed upgrade. I think that dbconfig-common made a backup of your database while it was partially upgraded. Unfortunately, those backups are not versioned. I don't f

Bug#613586: Still seems to be a problem with upgrades

2011-02-21 Thread Vincent Bernat
OoO Vers la fin de l'après-midi du lundi 21 février 2011, vers 16:29, Mark Syms disait : > Got there after applying the dbconfig backup after a previously failed > upgrade. I think that dbconfig-common made a backup of your database while it was partially upgraded. Unfortunately, those back

Bug#613586: Still seems to be a problem with upgrades

2011-02-21 Thread Mark Syms
Got there after applying the dbconfig backup after a previously failed upgrade. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Bug#613586: Still seems to be a problem with upgrades

2011-02-21 Thread Vincent Bernat
On Mon, 21 Feb 2011 13:25:02 +, Mark Syms 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-comm

Bug#613586: Still seems to be a problem with upgrades

2011-02-21 Thread Mark Syms
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