https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15522
--- Comment #19 from Victor Grousset/tuxayo <[email protected]> --- Hi :), I tried to test https://github.com/pianohacker/koha => branch bz15522-withdeps As it is, before trying to rebase it on master. But I can't successfully load a demo dump and do an upgrade database successfully. The last tag on the branch is v17.11.00 with means that it was from master during v18.05 development So perldeps for 18.05 dumps tried: - MARC 21 latest (v3.1900003) http://git.koha-community.org/gitweb/?p=contrib/global.git;a=history;f=sandbox/sql/sandbox1.sql.gz;h=19268bccb43b2a33d5644b7d86cbb1abb323016b;hb=HEAD I get these errors [1] with the atomic updates Other dumps tried http://git.koha-community.org/gitweb/?p=contrib/global.git;a=history;f=sandbox/sql/sandbox2.sql.gz;hb=HEAD - UNIMARC last 17.11.00 (this one should have worked) - UNIMARC last 17.05.00 - UNIMARC first 17.11.00 What did I miss to get a compatible state for the branch bz15522-withdeps ? [1] Upgrade to 17.12.00.020 done (Bug 20082 - Update descriptions of Vietnamese language) Upgrade to 17.12.00.021 done (Bug 19290 - Add system preference BrowseResultSelection) DEV atomic update: bug_15520-add_manage_circ_rules_restricted.sql DEV atomic update: bug_18887.perl DBD::mysql::db do failed: Can't create table `koha`.`circulation_rules` (errno: 150 "Foreign key constraint is incorrectly formed") [for Statement " CREATE TABLE `circulation_rules` ( `id` int(11) NOT NULL auto_increment, `branchcode` varchar(10) NULL default NULL, `categorycode` varchar(10) NULL default NULL, `itemtype` varchar(10) NULL default NULL, `rule_name` varchar(32) NOT NULL, `rule_value` varchar(32) NOT NULL, PRIMARY KEY (`id`), KEY `branchcode` (`branchcode`), KEY `categorycode` (`categorycode`), KEY `itemtype` (`itemtype`), KEY `rule_name` (`rule_name`), UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`), FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (categorycode) REFERENCES categories (categorycode) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (itemtype) REFERENCES itemtypes (itemtype) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; "] at (eval 1177) line 4. DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) SELECT branchcode, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM branch_borrower_circ_rules "] at (eval 1177) line 24. DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) SELECT NULL, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM default_borrower_circ_rules "] at (eval 1177) line 29. DBD::mysql::db do failed: Can't DROP 'max_holds'; check that column/key exists [for Statement " ALTER TABLE branch_borrower_circ_rules DROP COLUMN max_holds "] at (eval 1177) line 34. DBD::mysql::db do failed: Can't DROP 'max_holds'; check that column/key exists [for Statement " ALTER TABLE default_borrower_circ_rules DROP COLUMN max_holds "] at (eval 1177) line 38. Upgrade to XXX done (Bug 18887 - Introduce new table 'circulation_rules', use for 'max_holds' rules) DEV atomic update: bug_18925.perl DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT categorycode, branchcode, NULL, 'patron_maxissueqty', COALESCE( maxissueqty, '' ) FROM branch_borrower_circ_rules "] at (eval 1178) line 4. DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT categorycode, branchcode, NULL, 'patron_maxonsiteissueqty', COALESCE( maxonsiteissueqty, '' ) FROM branch_borrower_circ_rules "] at (eval 1178) line 9. DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT categorycode, NULL, NULL, 'patron_maxissueqty', COALESCE( maxissueqty, '' ) FROM default_borrower_circ_rules "] at (eval 1178) line 18. DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT categorycode, NULL, NULL, 'patron_maxonsiteissueqty', COALESCE( maxonsiteissueqty, '' ) FROM default_borrower_circ_rules "] at (eval 1178) line 23. DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT NULL, NULL, NULL, 'patron_maxissueqty', COALESCE( maxissueqty, '' ) FROM default_circ_rules "] at (eval 1178) line 32. DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT NULL, NULL, NULL, 'patron_maxonsiteissueqty', COALESCE( maxonsiteissueqty, '' ) FROM default_circ_rules "] at (eval 1178) line 37. DBD::mysql::db do failed: Table 'koha.circulation_rules' doesn't exist [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT NULL, branchcode, NULL, 'patron_maxissueqty', COALESCE( maxissueqty, '' ) FROM default_branch_circ_rules "] at (eval 1178) line 46. [...] -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
