[Koha-bugs] [Bug 20447] Add support for MARC holdings records

[bugzilla-daemon at bugs.koha-community.org]

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

Michal Denar <black23 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |black23 at gmail.com

--- Comment #62 from Michal Denar <black23 at gmail.com> ---
Hi Ere,
I tested patches and import seem be ok. But Test fails:
t/db_dependent/Exporter/Record.t .. DBD::mysql::st execute failed: Cannot add
or update a child row: a foreign key constraint fails
(`koha_kohadev`.`holdings`, CONSTRAINT `holdings_ibfk_3` FOREIGN KEY
(`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) [for
Statement "INSERT INTO holdings
        SET biblionumber = ?,
            biblioitemnumber = ?,
            frameworkcode = ?,
            holdingbranch = ?,
            location = ?,
            ccode = ?,
            callnumber = ?,
            suppress = ?,
            datecreated = NOW()
        " with ParamValues: 0='442', 1=441, 2='', 3="Location", 4=undef,
5=undef, 6="Tb | 1973", 7=0] at /home/vagrant/kohaclone/C4/Holdings.pm line
503.
ERROR in _koha_add_holding INSERT INTO holdings
        SET biblionumber = ?,
            biblioitemnumber = ?,
            frameworkcode = ?,
            holdingbranch = ?,
            location = ?,
            ccode = ?,
            callnumber = ?,
            suppress = ?,
            datecreated = NOW()
        Cannot add or update a child row: a foreign key constraint fails
(`koha_kohadev`.`holdings`, CONSTRAINT `holdings_ibfk_3` FOREIGN KEY
(`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at
/home/vagrant/kohaclone/C4/Holdings.pm line 509.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`holdings_metadata`, CONSTRAINT
`holdings_metadata_fk_1` FOREIGN KEY (`holding_id`) REFERENCES `holdings`
(`holding_id`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement "INSERT INTO
`holdings_metadata` ( `format`, `holding_id`, `marcflavour`, `metadata`) VALUES
( ?, ?, ?, ? )" with ParamValues: 0='marcxml', 1='442', 2='MARC21', 3="<?xml
version="1.0" encoding="UTF-8"?>

Can You give me feedback? 

Thank You 

Mike

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