Uploaded image for project: 'Providence'
  1. PROV-1401

Building Hierarchy with variable Amount of Levels for "ca_places" not working

    Details

      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]
      "

        Attachments

          Activity

            People

            • Assignee:
              Former user (Inactive)
              Reporter:
              Sami Rahman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: