[Pkg-roundcube-maintainers] Bug#1063835: roundcube: When upgrading from roundcube 1.4.15+dfsg.1-1~deb11u2 to 1.6.5+dfsg-1~deb12u1 error "table roundcube.filestore does not exist" is thrown, not handled

[Andrew Gallagher]

Package: roundcube
Version: 1.6.5+dfsg-1~deb12u1
Severity: important

When upgrading roundcube to the latest version, the mariadb schema upgrade fails due to a missing table "roundcube.filestore".
This table apparently never existed, however this did not seem to cause any noticeable issues before the upgrade.

It appears therefore that the schema migration makes too many assumptions about the state of the current database,
and so does not handle the missing (but apparently optianal) table gracefully. Missing tables should be created if they do not exist..



-- System Information:
Debian Release: 11.8
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'oldoldstable-updates'), (500, 'oldoldstable'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 5.10.0-11-amd64 (SMP w/3 CPU threads)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages roundcube depends on:
ii  dpkg            1.21.22
ih  roundcube-core  1.6.5+dfsg-1~deb12u1

roundcube recommends no packages.

roundcube suggests no packages.

Versions of packages roundcube-core depends on:
ii  dbconfig-common                 2.0.19
ii  debconf [debconf-2.0]           1.5.77
ii  dpkg                            1.21.22
ii  libjs-bootstrap4                4.5.2+dfsg1-8~deb11u1
ii  libjs-codemirror                5.59.2+~cs0.23.109-1
ii  libjs-jquery                    3.5.1+dfsg+~3.5.5-7
ii  libjs-jquery-minicolors         2.2.6+dfsg-4
ii  libjs-jquery-ui                 1.12.1+dfsg-8+deb11u1
ii  libjs-jstimezonedetect          1.0.6-5
ii  libmagic1                       1:5.39-3+deb11u1
ii  php                             2:7.4+76
ii  php-auth-sasl                   1.1.0-1
ii  php-common                      2:76
ii  php-guzzlehttp-guzzle           7.4.5-1
ii  php-intl                        2:7.4+76
ii  php-mail-mime                   1.10.10-1
ii  php-masterminds-html5           2.7.4+dfsg-2
ii  php-mbstring                    2:7.4+76
ii  php-net-sieve                   1.4.6-1
ii  php-net-smtp                    1.10.1-1
ii  php-pear                        1:1.10.12+submodules+notgz+20210212-1
ii  php7.4 [php]                    7.4.33-1+deb11u4
ii  php7.4-cli [php-cli]            7.4.33-1+deb11u4
ii  php7.4-intl [php-intl]          7.4.33-1+deb11u4
ii  php7.4-json [php-json]          7.4.33-1+deb11u4
ii  php7.4-mbstring [php-mbstring]  7.4.33-1+deb11u4
ii  roundcube-mysql                 1.6.5+dfsg-1~deb12u1
ii  ucf                             3.0043

Versions of packages roundcube-core recommends:
ii  apache2 [httpd-cgi]     2.4.57-2
pn  php-enchant             <none>
ii  php-gd                  2:7.4+76
ii  php7.4-gd [php-gd]      7.4.33-1+deb11u4
pn  roundcube-skin-classic  <none>
pn  roundcube-skin-larry    <none>

Versions of packages roundcube-core suggests:
pn  php-bacon-qr-code           <none>
pn  php-bjeavons-zxcvbn-php     <none>
pn  php-crypt-gpg               <none>
pn  php-net-ldap3               <none>
pn  php-roundcube-rtf-html-php  <none>
iu  roundcube-plugins           1.6.5+dfsg-1~deb12u1

-- debconf information:
  roundcube/mysql/admin-pass: (password omitted)
  roundcube/mysql/app-pass: (password omitted)
  roundcube/app-password-confirm: (password omitted)
  roundcube/password-confirm: (password omitted)
  roundcube/internal/skip-preseed: false
  roundcube/internal/reconfiguring: false
  roundcube/mysql/authplugin: default
  roundcube/database-type: mysql
  roundcube/db/app-user: roundcube at localhost
  roundcube/remote/port:
  roundcube/missing-db-package-error: abort
  roundcube/hosts:
  roundcube/db/dbname: roundcube
  roundcube/remote/newhost:
  roundcube/language: en_US
  roundcube/purge: false
  roundcube/dbconfig-remove: true
  roundcube/remove-error: abort
  roundcube/restart-webserver: true
  roundcube/dbconfig-upgrade: true
  roundcube/mysql/admin-user: debian-sys-maint
  roundcube/upgrade-error: abort
  roundcube/dbconfig-reinstall: false
  roundcube/passwords-do-not-match:
  roundcube/install-error: abort
  roundcube/remote/host: localhost
  roundcube/upgrade-backup: true
  roundcube/mysql/method: Unix socket
  roundcube/reconfigure-webserver: apache2, lighttpd
  roundcube/dbconfig-install: true