Am 23.05.2012 10:39, schrieb Thomas Mueller: >> Installing new version of config file /etc/init.d/otrs2 ... >> dbconfig-common: writing config to /etc/dbconfig-common/otrs2.conf >> Replacing config file /etc/otrs/database.pm with new version >> creating database backup in >> /var/cache/dbconfig-common/backups/otrs2_2.4.9+dfsg1-3+squeeze1.mysql. >> applying upgrade sql for 2.4.9+dfsg1-3+squeeze1 -> 3.0. >> error encountered processing >> /usr/share/dbconfig-common/data/otrs2/upgrade/mysql/3.0: >> mysql said: ERROR 1005 (HY000) at line 322: Can't create table >> 'otrs2.#sql-1712_71' (errno: 150) >> dbconfig-common: otrs2 configure: aborted. >> dbconfig-common: flushing administrative password >> dpkg: error processing otrs2 (--configure): >> subprocess installed post-installation script returned error exit >> status 1 >> > Can't reproduce this error.
I tried to reproduce this error, please notice that I also upgraded to mysql-server-5.5. After I had installed otrs2 on squeeze and upgraded to sid I get: otrs2 (3.1.5+dfsg1-1) wird eingerichtet ... Neue Version der Konfigurationsdatei /etc/init.d/otrs2 wird installiert ... dbconfig-common: writing config to /etc/dbconfig-common/otrs2.conf Replacing config file /etc/otrs/database.pm with new version creating database backup in /var/cache/dbconfig-common/backups/otrs2_2.4.9+dfsg1-3+squeeze1.mysql. applying upgrade sql for 2.4.9+dfsg1-3+squeeze1 -> 3.0. error encountered processing /usr/share/dbconfig-common/data/otrs2/upgrade/mysql/3.0: mysql said: ERROR 1005 (HY000) at line 322: Can't create table 'otrs2.#sql-2ddc_72' (errno: 150) dbconfig-common: otrs2 configure: aborted. Then I simply tried out following: mysql> drop database otrs2; create database otrs2; root@squeeze:~/usr/share/dbconfig-common/data/otrs2/install# mysql -ptest otrs2 < mysql root@squeeze:~/usr/share/dbconfig-common/data/otrs2/install# (this was the squeeze database, I habe unpackaged it to ~/) root@squeeze:~/usr/share/dbconfig-common/data/otrs2/install# mysql -ptest otrs2 < /usr/share/dbconfig-common/data/otrs2/upgrade/mysql/3.0 ERROR 1025 (HY000) at line 46: Error on rename of './otrs2/article_flag' to './otrs2/#sql2-2ddc-78' (errno: 152) root@squeeze:~/usr/share/dbconfig-common/data/otrs2/install# And this was the 3.0 upgrade database from the 3.1.5 package, so I can confirm it.. -- /* Mit freundlichem Gruß / With kind regards, Patrick Matthäi GNU/Linux Debian Developer E-Mail: [email protected] [email protected] */
signature.asc
Description: OpenPGP digital signature
