[Koha-bugs] [Bug 12488] bulkmarcimport.pl -d option should use DELETE instead of TRUNCATE

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488

--- Comment #3 from Magnus Enger <magnus at enger.priv.no> ---
Also, I got some nasty foreign key errors with the script as it is now, on
MySQL version 5.5.40-0+wheezy1:

deleting biblios
DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key
constraint (`koha_vulkan`.`biblioitems`, CONSTRAINT `biblioitems_ibfk_1`
FOREIGN KEY (`biblionumber`) REFERENCES `koha_vulkan`.`biblio`
(`biblionumber`)) at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line
137.
DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key
constraint (`koha_vulkan`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY
(`biblioitemnumber`) REFERENCES `koha_vulkan`.`biblioitems`
(`biblioitemnumber`)) at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl
line 138.
DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key
constraint (`koha_vulkan`.`branchtransfers`, CONSTRAINT
`branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES
`koha_vulkan`.`items` (`itemnumber`)) at
/usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 139.
Characteristic MARC flavour: NORMARC

Changing "truncate" to DELETE FROM as suggested in the first comment made this
problem go away.

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