[Pkg-roundcube-maintainers] Bug#653217: roundcube-core: syntax error in sqlite DB upgrade file

[intrigeri+debian at boum.org]

Package: roundcube
Version: 0.7-1
Severity: normal

Hi,

/usr/share/dbconfig-common/data/roundcube/upgrade/sqlite/0.7-1 is buggy:

  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.6+dfsg-1.sqlite.
  applying upgrade sql for 0.6+dfsg-1 -> 0.7-1.
  CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
  SQL error: near "(": syntax error

It's lacking the "ON table" part of the CREATE INDEX statement, isn't it?

-- System Information:
Debian Release: wheezy/sid
  APT prefers unstable
  APT policy: (990, 'unstable')
Architecture: amd64 (x86_64)

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

Versions of packages roundcube-core depends on:
ii  apache2                      2.2.21-3
ii  apache2-mpm-prefork [httpd]  2.2.21-3
ii  dbconfig-common              1.8.47
ii  debconf [debconf-2.0]        1.5.41
ii  libjs-jquery                 1.7.1-1
ii  libmagic1                    5.09-2
ii  nginx-full [httpd]           1.1.11-1
ii  php-auth                     1.6.2-1
ii  php-mail-mime                1.8.0-2
ii  php-mdb2                     2.5.0b2-1
ii  php-net-smtp                 1.6.0-1
ii  php-net-socket               1.0.9-2
ii  php5                         5.3.8.0-1
ii  php5-gd                      5.3.8.0-1+b1
ii  php5-intl                    5.3.8.0-1+b1
ii  php5-mcrypt                  5.3.8.0-1+b1
ii  php5-pspell                  5.3.8.0-1+b1
ii  roundcube-sqlite             0.7-1
ii  tinymce                      3.4.3.2+dfsg0-1
ii  ucf                          3.0025+nmu2

roundcube-core recommends no packages.

Versions of packages roundcube-core suggests:
ii  php-auth-sasl      <none>
ii  php-crypt-gpg      <none>
ii  roundcube-plugins  0.7-1

roundcube depends on no packages.

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

--
  intrigeri <intrigeri at boum.org>
  | GnuPG key @ https://gaffer.ptitcanardnoir.org/intrigeri/intrigeri.asc
  | OTR fingerprint @ https://gaffer.ptitcanardnoir.org/intrigeri/otr.asc
  | The impossible just takes a bit longer.