[Koha-bugs] [Bug 18930] Move lost item refund rules to circulation_rules table

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Oct 25 06:22:32 CEST 2018


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18930

Alex Buckley <alexbuckley at catalyst.net.nz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #7 from Alex Buckley <alexbuckley at catalyst.net.nz> ---
The updatedatabase.pl fails when there are records in the lost item refund
rules table. See below updatedatabase.pl output:

DEV atomic update: bug_18930.perl
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`circulation_rules`, CONSTRAINT
`circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches`
(`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement "
            INSERT INTO circulation_rules ( categorycode, branchcode, itemtype,
rule_name, rule_value )
            SELECT NULL, branchcode, NULL, 'refund', refund
            FROM refund_lost_item_fee_rules
        "] at (eval 1209) line 4.
Upgrade to XXX done (Bug 18930 - Move lost item refund rules to
circulation_rules table)
kohadev-koha at kohadevbox:/home/vagrant/kohaclone/installer/data/mysql$ exit

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list