BioplatformsAustralia / bpaotu

OTU database access for the Australian Microbiome
GNU Affero General Public License v3.0
5 stars 1 forks source link

contextual view: broad land use doens't work #68

Closed grahame closed 6 years ago

grahame commented 6 years ago

Add broad land use, get this traceback

runserver_1 | sqlalchemy.exc.InvalidRequestError: Could not find a FROM clause to join from. Tried joining to <class 'bpaotu.otu.SampleLandUse'>, but got: Can't determine join between 'Join object on sample_context(140241661005216) and ontology_sampleaustraliansoilclassification(140241661226288)' and 'ontology_samplelanduse'; tables have more than one foreign key constraint relationship between them. Please specify the 'onclause' of this join explicitly.