[Koha] foreign key constraint fails when importing csv

Marty ontariowolf64 at yahoo.com
Thu Jan 29 18:05:09 UTC 2009


Me again.
Trying to get borrowers from old koha to koah 3 I get this error message;

mysql> LOAD DATA INFILE "/home/marty/patronz.csv" INTO TABLE borrowers FIELDS TERMINATED BY ',' ENCLOSED BY "";

ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`koha/borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`))

Not sure about this foreign key constraint, did I fail to set some value in Koha?


      



More information about the Koha mailing list