Julia suggested to open an issue in Jira as this could be a bug: http://www.collectiveaccess.org/support/forum/index.php?p=/discussion/comment/314746/#Comment_314746
Here's the details:
I've been trying to import places from my excel sheet. I was using "placeHierarchyBuilder" with "useParentAsSubject" option to build the hierarchy as I've variable amount of levels in data.
I've list items called "SPECTRUM Place Authority (i1)" inside "place_hierarchies" too.
Everytime it fails with the following error,
Could not insert new record for place: Cannot add or update a child row: a foreign key constraint fails (`ca`.`ca_places`, CONSTRAINT `fk_ca_places_hierarchy_id` FOREIGN KEY (`hierarchy_id`) REFERENCES `ca_list_items` (`item_id`))