[Pkg-roundcube-maintainers] Bug#720955: roundcube-core: fails to upgrade MySQL database (0.7.2-9 -> 0.9.2-2)

[Matteo Checcucci]

Package: roundcube
Version: 0.7.2-9
Severity: important

Hello,
I was trying to upgrade roundcube from version 0.7.2-9 to version 0.9.2-2.
Packages roundcube, roundcube-core, roundcube-mysql, and roundcube-plugins taken
from current jessie, while package roundcube-plugins-extra from current sid.
During the upgrade the MySQL database failed to be updated with the following error:


An error occurred while upgrading the database:

mysql said: ERROR 1091 (42000) at line 3: Can't DROP 'cache_id'; check that column/key exists 


Retrying failed again.

Aborting led to a non-working package.

I downgraded to the previous version, which, however, does not work with apache 2.4 ...

Could you please help?

Thank you.



-- System Information:
Debian Release: jessie/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 3.10-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages roundcube-core depends on:
ii  apache2                2.4.6-3
ii  apache2-bin [httpd]    2.4.6-3
ii  dbconfig-common        1.8.47+nmu1
ii  debconf [debconf-2.0]  1.5.50
ii  libjs-jquery           1.7.2+dfsg-3
ii  libjs-jquery-ui        1.10.1+dfsg-1
ii  libmagic1              1:5.14-2
ii  php-auth               1.6.2-1
ii  php-mail-mime          1.8.4-1
ii  php-mdb2               2.5.0b5-1
ii  php-net-smtp           1.6.1-1
ii  php-net-socket         1.0.14-1
ii  php5                   5.5.1+dfsg-2
ii  php5-gd                5.5.1+dfsg-2
ii  php5-intl              5.5.1+dfsg-2
ii  php5-mcrypt            5.5.1+dfsg-2
ii  php5-pspell            5.5.1+dfsg-2
ii  roundcube-mysql        0.7.2-9
ii  tinymce                3.4.8+dfsg0-1
ii  ucf                    3.0027+nmu1

roundcube-core recommends no packages.

Versions of packages roundcube-core suggests:
ii  php-auth-sasl      1.0.6-1
pn  php-crypt-gpg      <none>
ii  roundcube-plugins  0.7.2-9

roundcube depends on no packages.

-- Configuration Files:
/etc/roundcube/apache.conf changed:
Alias /roundcube/program/js/tiny_mce/ /usr/share/tinymce/www/
Alias /webmail /var/lib/roundcube
<Directory "/usr/share/tinymce/www/">
      Options Indexes MultiViews FollowSymLinks
      AllowOverride None
      Order allow,deny
      allow from all
</Directory>
<Directory /var/lib/roundcube/>
  Options +FollowSymLinks
  # This is needed to parse /var/lib/roundcube/.htaccess. See its
  # content before setting AllowOverride to None.
  AllowOverride All
  order allow,deny
  allow from all
</Directory>
<Directory /var/lib/roundcube/config>
        Options -FollowSymLinks
        AllowOverride None
</Directory>
<Directory /var/lib/roundcube/temp>
        Options -FollowSymLinks
        AllowOverride None
	Order allow,deny
	Deny from all
</Directory>
<Directory /var/lib/roundcube/logs>
        Options -FollowSymLinks
        AllowOverride None
	Order allow,deny
	Deny from all
</Directory>


-- debconf information:
  roundcube/upgrade-error: abort
  roundcube/pgsql/authmethod-user: password
  roundcube/purge: false
* roundcube/dbconfig-install: false
  roundcube/db/dbname: roundcube
  roundcube/language: en_US
  roundcube/remote/newhost:
  roundcube/pgsql/changeconf: false
  roundcube/upgrade-backup: true
  roundcube/install-error: abort
  roundcube/mysql/admin-user: root
  roundcube/hosts:
  roundcube/pgsql/authmethod-admin: ident
  roundcube/dbconfig-remove:
  roundcube/pgsql/admin-user: postgres
  roundcube/internal/skip-preseed: true
  roundcube/db/app-user: roundcube
  roundcube/dbconfig-reinstall: false
  roundcube/mysql/method: unix socket
  roundcube/remove-error: abort
  roundcube/restart-webserver: true
  roundcube/dbconfig-upgrade: true
  roundcube/remote/port:
  roundcube/pgsql/method: unix socket
  roundcube/pgsql/manualconf:
  roundcube/db/basepath:
  roundcube/pgsql/no-empty-passwords:
  roundcube/passwords-do-not-match:
  roundcube/internal/reconfiguring: false
  roundcube/reconfigure-webserver: apache2, lighttpd
  roundcube/database-type: mysql
  roundcube/remote/host:
  roundcube/missing-db-package-error: abort