[Koha-bugs] [Bug 15522] New interface for revamped circulation rules
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon May 20 21:54:39 CEST 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15522
--- Comment #19 from Victor Grousset/tuxayo <victor.grousset at biblibre.com> ---
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.
More information about the Koha-bugs
mailing list