errors, migrating from 3.10.04 to 3.14.04
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.
Like you, I have some problems migrating from 3.10.04 to 3.14.04 I'm upgrading from a manually installed 3.10 Koha on Ubuntu to a latest stable Koha Debian packages on a new server. I create a new server, installed Koha and imported the db. *1st ERROR:* [Wed Apr 9 15:35:17 2014] updatedatabase.pl: DBD::mysql::db do failed: Can't create table 'koha_koha.authorised_values_branches' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6122. *2nd ERROR:* Some of the Authorised Values can't be selected. For example: When edit Items can't select *Use restrictions* or *Source of acquisition* When edit Patrons can't select *Additional attributes and identifiers* ----- Koha version: 3.08.04 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/errors-migrating-from-3-10-04-to-3-14-04-t... Sent from the Koha-general mailing list archive at Nabble.com.
I've made a a fresh install, dumped *"koha_koha.authorised_values_branches"* Than, imported *"koha_koha.authorised_values_branches"* to my koha and everything was ok. <p>Authorised Values started to work :) ----- Koha version: 3.08.04 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/errors-migrating-from-3-10-04-to-3-14-04-t... Sent from the Koha-general mailing list archive at Nabble.com.
participants (2)
-
anjoze -
Jürgen Eichenbrenner