[Koha] bulkmarcimport-problems!

Magdalena Söderqvist soderqvist at sipri.org
Fri Feb 17 23:46:40 NZDT 2012


Hi all, 
my IT-expert is helping me import some marc-records which I have edited in Marc Edit. But importing the records back into Koha is not working. And the editing itself does not seem to be the problem, we get the same error message when trying to import the orginal, unedited .mrc file, which I pulled from the "tools/export.pl" page. Do the below messages contain enough information to tell what we're doing wrong? Any help is, as always, much appreciated. We are currently running version 3.6.2 on Debian Squeeze. 

Also: we're doing this on a copy of the database, could that be part of the problem? 

Cheers, 
Magdalena 

******************** 
deleting biblios 
> > DBD::mysql: b do failed: Cannot delete or update a parent row: a 
> > foreign key constraint fails (`koha`.`issues`, CONSTRAINT 
> > `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` 
> > (`itemnumber`) ON UPDATE CASCADE) at ./bulkmarcimport.pl line 96. 

******************* 

Duplicate entry 'A13150' for key 'itembarcodeidx' at 
/usr/share/koha/lib/C4/Items.pm line 361, <GEN16> line 804. 
.DBD::mysql::st execute failed: Duplicate entry 'A13151' for key 
'itembarcodeidx' at /usr/share/koha/lib/C4/Items.pm line 2105, <GEN16> 
line 805. 
ERROR in _koha_new_item INSERT INTO items SET 

******************** 

- 

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 
Magdalena Söderqvist 
Librarian 
SIPRI Library and Documentation Department 

STOCKHOLM INTERNATIONAL 
PEACE RESEARCH INSTITUTE 

Signalistgatan 9 
SE-169 70 Solna, Sweden 
Telephone: +46 8 655 97 78 
Fax: +46 8 655 97 33 
Email: soderqvist at sipri.org 
Internet: www.sipri.org 


More information about the Koha mailing list