[Koha] Batch load error

Tom Hanstra hanstra at nd.edu
Wed Aug 6 08:36:26 NZST 2014


When I attempt to batch load a record in a new Koha installation, I'm
seeing the following error in the Koha error log:

[Tue Aug 05 16:25:09 2014] [error] [client 10.41.63.84] [Tue Aug  5
16:25:09 2014] stage-marc-import.pl: DBD::mysql::st execute failed: Field
'marcxml_old' doesn't have a default value at
/usr/share/koha/lib/C4/ImportBatch.pm line 1403.

Is there some set of default values which I need to set in order to have
records load properly?  Did I miss something on setup or install?

Note that I also have these additional errors:

[Tue Aug 05 16:25:09 2014] [error] [client 10.41.63.84] [Tue Aug  5
16:25:09 2014] stage-marc-import.pl: DBD::mysql::st execute failed: Cannot
add or update a child row: a foreign key constraint fails
(`rome_prod`.`import_biblios`, CONSTRAINT `import_biblios_ibfk_1` FOREIGN
KEY (`import_record_id`) REFERENCES `import_records` (`import_record_id`)
ON DELETE CASCADE ON UPDATE CASCADE) at
/usr/share/koha/lib/C4/ImportBatch.pm line 1442.
[Tue Aug 05 16:25:09 2014] [error] [client 10.41.63.84] [Tue Aug  5
16:25:09 2014] stage-marc-import.pl: DBD::mysql::st execute failed: Cannot
add or update a child row: a foreign key constraint fails
(`rome_prod`.`import_items`, CONSTRAINT `import_items_ibfk_1` FOREIGN KEY
(`import_record_id`) REFERENCES `import_records` (`import_record_id`) ON
DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/lib/C4/ImportBatch.pm
line 440.,

but I'm guessing these are because of the initial loading problem.

Thanks for any pointers you can give,
Tom


More information about the Koha mailing list