Dear friends, we want to reset our catalogue, so we use ./bulkmarcimport.pl -d script to achieve this. Yet, there is a problem with MySQL database. The tables are constrained with some other tables. Interestingly, there are no hold orders on the records, so there is no reasons why the items should not be deleted. What can you suggest us?
------- DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`kohadata`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `kohadata`.`biblio` (`biblionumber`)) at ./bulkmarcimport.pl line 97. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`kohadata`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES `kohadata`.`biblioitems` (`biblioitemnumber`)) at ./bulkmarcimport.pl line 98. DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign key constraint (`kohadata`.`accountlines`, CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `kohadata`.`items` (`itemnumber`)) at ./bulkmarcimport.pl line 99. ------ Thanks in advance, Haik. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
