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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
