[Pkg-roundcube-maintainers] Bug#784573: roundcube: DB upgrade to 1.1.1 has error with PostgreSQL

[Courtney Bane]

Package: roundcube
Version: 1.1.1+dfsg.1-2
Severity: normal

I ran into errors with the DB upgrade script for PostgreSQL. Here's the
output I get:

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.9.5+dfsg1-4.2.pgsql.
applying upgrade sql for 0.9.5+dfsg1-4.2 -> 1.1.1-1.
error encountered processing /usr/share/dbconfig-common/data/roundcube/upgrade/pgsql/1.1.1-1:
ERROR: column "2015030800" does not exist LINE 6: UPDATE system SET value="2015030800" WHERE name="roundcube-v... ^

The double quotes in the "update system table" line of the update SQL
need to be single quotes.

This:
UPDATE system SET value="2015030800" WHERE name="roundcube-version";

Needs to become this:
UPDATE system SET value='2015030800' WHERE name='roundcube-version';

-- System Information:
Debian Release: 8.0
  APT prefers stable
  APT policy: (990, 'stable'), (990, 'stable-updates'), (800, 'testing'), (700, 'unstable')
Architecture: amd64 (x86_64)

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

Versions of packages roundcube depends on:
ii  roundcube-core  1.1.1+dfsg.1-2

roundcube recommends no packages.

roundcube suggests no packages.

Versions of packages roundcube-core depends on:
ii  dbconfig-common        1.8.47+nmu3
ii  debconf [debconf-2.0]  1.5.56
ii  libjs-jquery           1.7.2+dfsg-3.2
ii  libmagic1              1:5.22+15-2
ii  php-auth               1.6.4-1
ii  php-mail-mime          1.8.9-1
ii  php-mail-mimedecode    1.5.5-2
ii  php-net-smtp           1.6.2-2
ii  php-net-socket         1.0.14-1
ii  php5                   5.6.7+dfsg-1
ii  php5-cli               5.6.7+dfsg-1
ii  php5-common            5.6.7+dfsg-1
ii  php5-intl              5.6.7+dfsg-1
ii  php5-json              1.3.6-1
ii  php5-mcrypt            5.6.7+dfsg-1
ii  roundcube-pgsql        1.1.1+dfsg.1-2
ii  tinymce                3.4.8+dfsg0-1
ii  ucf                    3.0030

Versions of packages roundcube-core recommends:
ii  nginx-extras [httpd-cgi]  1.6.2-5
ii  php5-gd                   5.6.7+dfsg-1
ii  php5-pspell               5.6.7+dfsg-1

Versions of packages roundcube-core suggests:
ii  php-auth-sasl      1.0.6-1
pn  php-crypt-gpg      <none>
ii  roundcube-plugins  1.1.1+dfsg.1-2

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