Space Import/Export Fails with Fk constraint "fkj4cu5838aqcbw57wy7ckt0t7o" after export done by non site admin

XMLWordPrintable

    • 25
    • Severity 3 - Minor
    • 2

      Issue Summary

      When a non site admin does an export on the space, sometimes the content.csv is missing all the content but one or two records. All pages will be missing. Thus during import it fails at the step ERROR: insert or update on table "spaces" violates foreign key constraint "fkj4cu5838aqcbw57wy7ckt0t7o". This message specifically referring to spaces table homepage not mapping to anything on content table as content table has no pages.

       

      Steps to Reproduce

      1. Be a non site admin of a site and do a space CSV UI export
      2. Import that space

      Expected Results

      Space should go through successfully

      Actual Results

      ERROR: insert or update on table "spaces" violates foreign key constraint "fkj4cu5838aqcbw57wy7ckt0t7o" 

      Workaround

      Have a site admin do the exporting and importing

            Assignee:
            Alex Williams
            Reporter:
            Harry Yee (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            16 Start watching this issue

              Created:
              Updated:
              Resolved: