[Koha] errors, migrating from 3.10.04 to 3.14.04

Jürgen Eichenbrenner eichenbrenner at issev.de
Thu Apr 10 19:15:25 NZST 2014


Hello,

upgrading from a manually installed 3.10 Koha to a latest stable Koha Debian packages on a new server, I'm facing the following errors, when I run the upgrading database script via:
$ sudo koha-upgrade-schema
Is it necessary to upgrade in two steps instead, first from 3.10 to 3.12, followed by 3.12 to 3.14?
Or do I anyway need to correct all errors manually, by creating missing tables (like the table „koha_INSTANCENAME.borrower_debarments“) which the script updatedatabase.pl fails to create ?

Any hints and tips are highly appreciated!
Thanks,
Jürgen,
Stuttgart

$ sudo koha-upgrade-schema
DBD::mysql::db do failed: Can't create table 'koha_koha3.borrower_attribute_types_branches' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6118.
DBD::mysql::db do failed: Can't create table 'koha_koha3.categories_branches' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6120.
DBD::mysql::db do failed: Can't create table 'koha_koha3.authorised_values_branches' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6122.
[...]
DBD::mysql::db do failed: Duplicate entry 'OPACNumbersPreferPhrase' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6404.
DBD::mysql::db do failed: Duplicate entry 'IntranetNumbersPreferPhrase' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6405.
Upgrade to 3.11.00.018 done (Bug 9395: Problem with callnumber and standard number search in OPAC and Staff Client)
DBD::mysql::db do failed: Duplicate entry 'UNIMARCAuthorityField100' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6412.
[...]
DBD::mysql::db do failed: Duplicate key name 'batch_id_record_type' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6481.
[...]
DBD::mysql::db do failed: Can't create table 'koha_koha3.#sql-6d24_e0' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6877.
DBD::mysql::db do failed: Can't create table 'koha_koha3.#sql-6d24_e0' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6899.
[...]
DBD::mysql::db do failed: Can't create table 'koha_koha3.aqorders_transfers' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7110.
[...]
DBD::mysql::db do failed: Can't create table 'koha_koha3.#sql-6d24_e0' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7277.
DBD::mysql::db do failed: Can't create table 'koha_koha3.#sql-6d24_e0' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7293.
[...]
DBD::mysql::db do failed: Can't create table 'koha_koha3.borrower_debarments' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7599.
DBD::mysql::db do failed: Table 'koha_koha3.borrower_debarments' doesn't exist at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7616.
[...]
DBD::mysql::db do failed: Can't create table 'koha_koha3.aqbasketusers' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7670.


More information about the Koha mailing list