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. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
