We're updating the issue view to help you get more done. 

Building Hierarchy with variable Amount of data for ca_place not working

Description

Hi,
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`)) [250]
"

Environment

Linux

Assignee

User known

Reporter

Sami Rahman

Components

Fix versions

Affects versions

Priority

Major
Configure