[Koha] updatedatabase.pl – 2nd request for help

[Jürgen Eichenbrenner]

A few days ago I complained here about:

updatedatabase.pl

Sorry, for nagging again. I have to be more specific.  It seems to me, there were changes of the database scheme, not reflected properly in the updatedatabase.pl script. It fails (with mysql error s150), when upgrading a database from 3.10 to any newer version of Koha, in creating the following three tables:

- borrower_attributes_types_branches
- categories_branches
- authorised_values_branches

For getting around this, I tried to create the (new 3.12) Koha scheme before I dump in the old 3.10 database dump into a new (3.12) installation. Even then I get errors (which I reported here a few days ago).

If I don't create the newer Koha database scheme beforehand, the "Web installer" gives errors like this:

updatedatabase.pl: DBD::mysql::db do failed: Can't create table 'koha312.categories_branches' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6120.

In fact, these statement, like the one from line 6120:
CREATE TABLE categories_branches(categorycode VARCHAR(10), branchcode VARCHAR(10), FOREIGN KEY (categorycode) REFERENCES categories(categorycode) ON DELETE CASCADE, FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE ) ENGINE=INNODB DEFAULT CHARSET=utf8;
are failing with mysql error 150.

Besides of the three additional table creations, there are 6 duplicate entries of PRIMARY keys in the tables:
'OPACNumbersPreferPhrase' 
'IntranetNumbersPreferPhrase' 
'UNIMARCAuthorityField100' 
'l-overdues_report'
'UNIMARCAuthorsFacetsSeparator' 
 'CalculateFinesOnReturn' 

And a duplicate key name:
'batch_id_record_type'  

Because of this I'm stuck with 3.10 and appreciate any hints and help for getting this solved properly.

Jürgen Eichenbrenner
Int. School of Stuttgart