Unable to create table from chapter table page

USGCRP / gcis

Global Change Information System

https://data.globalchange.gov

Other

20 stars 16 forks source link

Unable to create table from chapter table page #694

Closed amruelama closed 5 years ago

amruelama commented 5 years ago

Table can be created via "report/table/form/create" but not from "report/chapter/2/table/form/create"

ERROR: insert or update on table "table" violates foreign key constraint "table_chapter_identifier_fkey" DETAIL: Key (chapter_identifier, report_identifier)=(2, second-state-carbon-cycle-report-soccr2-sustained-assessment-report) is not present in table "chapter". at /home/gcisops/perl5/perlbrew/perls/perl-5.20.3/lib/site_perl/5.20.3/Rose/DB/Object.pm line 1182.

lomky commented 5 years ago

@amruelama that's because /chapter/2 is a shortcut to the real chapter, /chapter/the-north-american-carbon-budget. You need to go to the real address to create subobjects.