mysql said: ERROR 1146 (42S02) at line 5: Table 'roundcube.messages' doesn't exi

[Clèm]

Hi,

I just upgrade Ubuntu. During the process, it upgrades Roundcube installed with the .deb of the Ubuntu repository. But I've got a problem :

Code: [Select]

Paramétrage de roundcube-core (0.7.1-2) ...
dbconfig-common: writing config to /etc/dbconfig-common/roundcube.conf
Replacing config file /etc/roundcube/debian-db.php with new version
creating database backup in /var/cache/dbconfig-common/backups/roundcube_0.3.1-3.mysql.
applying upgrade sql for 0.3.1-3 -> 0.5-1.
error encountered processing /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1:
[b]mysql said: ERROR 1146 (42S02) at line 5: Table 'roundcube.messages' doesn't exist[/b]
dbconfig-common: roundcube configure: aborted.
dbconfig-common: flushing administrative password
dpkg : erreur de traitement de roundcube-core (--configure) :
 le sous-processus script post-installation installé a retourné une erreur de sortie d'état 1
dpkg : des problèmes de dépendances empêchent la configuration de roundcube :
 roundcube dépend de roundcube-core (= 0.7.1-2) ; cependant :
 Le paquet roundcube-core n'est pas encore configuré.
dpkg : erreur de traitement de roundcube (--configure) :
 problèmes de dépendances - laissé non configuré
Aucun rapport « apport » n'a été créé car le message d'erreur indique une erreur consécutive à un échec précédent.
                                                                                                                  Des erreurs ont été rencontrées pendant l'exécution :
 roundcube-core
 roundcube
How could I fix the DB ?
Thanks,
Clèm

[SKaero]

I'm a little confused as to what version your upgrading from and what version your upgrading to, I see three separate version numbers 0.3.1, 0.5-1, and 0.7.1. The table its completing about (messages) was removed after version 0.6 so it seems that your RC install may have already be upgraded to at least to version 0.6. Check your current RoundCube files the index.php in the main folder should have the version number at the top.

[Clèm]

I'm a little confused as to what version your upgrading from and what version your upgrading to

So do I ^^

Check your current RoundCube files the index.php in the main folder should have the version number at the top.

| Roundcube Webmail IMAP Client
| Version 0.7.1

[SKaero]

Since the index.php says your at version 0.7.1 and the DB says you don't have the messages table I think your RoundCube is up to date (although technically version 0.7.2 is the newest stable version but its not in Ubuntu repos). I think the package manager has just gotten confused and can be safely ignored. If you want to fake the upgrade so it doesn't yell at you in the future backup the current RoundCube database and put a copy of the 0.5 database in its place so it can complete the upgrade and then replace database with the backup.

[Clèm]

I tried to manually upgrade the database by steps from 0.3.1 to 0.5, then to 0.7.1, but I obtained other errors of the same kind missing some table, duplicated some one, already exist for an other.
So I decided to erase the whole table then manually import the database found in the archive sources, finally selected don't want db-common to do the upgrade the DB during the upgrade. It works but I loose the contacts saved in the address book.