Package: otrs2 Version: 3.3.9-3 Severity: normal Dear Maintainer,
I included jessie-backports non-free to update otrs2 to version 5. The database upgrade aborts with this error: > Specified key was too long; max key length is 767 bytes This happens if the character set of the database is utf8mb4. The bug is already known here: > https://bugs.otrs.org/show_bug.cgi?id=12361 This happens when the upgrade script tries to create the table cloud_service_config with UNIQUE INDEX cloud_service_config_name (name) and name is defined as name VARCHAR (200) NOT NULL. The otrs perl upgrade script afterwards wants to change the database to utf8, but then it's already too late. The Debian updater should check if the database is set to utf8mb4 before starting the upgrade and abort with an error. -- System Information: Debian Release: 8.6 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 3.16.0-4-amd64 (SMP w/1 CPU core) 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 otrs2 depends on: ii adduser 3.113+nmu3 ii apache2 [httpd-cgi] 2.4.10-10+deb8u7 ii apache2-mpm-worker [httpd-cgi] 2.4.10-10+deb8u7 ii dbconfig-common 1.8.47+nmu3+deb8u1 ii debconf [debconf-2.0] 1.5.56 ii fonts-font-awesome 4.2.0~dfsg-1 ii libapache-dbi-perl 1.12-1 ii libapache2-reload-perl 0.12-3 ii libauthen-sasl-perl 2.1600-1 ii libcrypt-passwdmd5-perl 1.3-10 ii libcss-minifier-perl 0.01-1 ii libdate-pcalc-perl 6.1-4 ii libdbd-mysql-perl 4.028-2+deb8u2 ii libdbd-pg-perl 3.4.2-1 ii libdbi-perl 1.631-3+b1 ii libemail-valid-perl 1.195-1 ii libgd-graph-perl 1.48-2 ii libgd-text-perl 0.86-9 ii libio-interactive-perl 0.0.6-1 ii libio-stringy-perl 2.110-5 ii libjavascript-minifier-perl 1.11-1 ii libjs-jquery-ui 1.10.1+dfsg-1 ii libjson-perl 2.61-1 ii liblinux-distribution-perl 0.21-1 ii libmail-imapclient-perl 3.35-1 ii libmail-pop3client-perl 2.18-1 ii libmailtools-perl 2.13-1 ii libmime-tools-perl 5.505-1 ii libnet-imap-simple-perl 1.2205-1 ii libnet-imap-simple-ssl-perl 1.3-3 ii libnet-smtp-ssl-perl 1.01-3 ii libnet-sslglue-perl 1.052-1 ii libpdf-api2-perl 2.023-1 ii libproc-daemon-perl 0.14-2 ii libsoap-lite-perl 1.11-1 ii libsys-hostname-long-perl 1.4-3 ii libtext-csv-perl 1.32-1 ii libtext-diff-perl 1.41-1 ii libxml-feedpp-perl 0.43-1 ii libxml-parser-lite-perl 0.720-1 ii libxml-parser-perl 2.41-3 ii libyaml-libyaml-perl 0.41-6 ii libyaml-perl 1.13-1 ii perl [libdigest-sha-perl] 5.20.2-3+deb8u6 ii ttf-dejavu-core 2.34-1 ii ttf-dejavu-extra 2.34-1 ii ucf 3.0030 Versions of packages otrs2 recommends: ii ispell 3.3.02-6 ii libcrypt-eksblowfish-perl 0.009-1+b2 ii libencode-hanextra-perl 0.23-3+b1 ii libjson-xs-perl 2.340-1+b2 ii libtext-csv-xs-perl 1.11-2 ii mysql-server 5.5.53-0+deb8u1 ii procmail 3.22-24 Versions of packages otrs2 suggests: ii libnet-ldap-perl 1:0.6400+dfsg-2 pn libnet-smtp-tls-butmaintained-perl <none> pn otrs2-doc-en | otrs2-doc-de <none> -- Configuration Files: /etc/apache2/conf-available/otrs2.conf changed [not included] -- debconf information excluded
