search

mbohun / biolink

Automatically exported from code.google.com/p/biolink
0 stars 0 forks source link

Cannot add ranks after adding Sub-Kingdon in Plantae #197

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
From Dieter Slos

Original issue reported on code.google.com by david.ba...@gmail.com on 18 Jul 2013 at 12:44

GoogleCodeExporter commented 9 years ago 
This issue is being caused by a misconfiguration in the tblBiotaDefRules table, 
which incorrectly asserts that the only valid child rank of a Plantae 
Subkingdom is Phylum, even though Phylum is not included in the list of valid 
ranks for Plantae. The solution to this issue is to update the tblBiotaDefRules 
table to make the valid child of a Plantae Subkingdom be 'Division'. An SQL 
script can be downloaded from the Downloads page, or otherwise the following 
SQL can be executed against the BioLink database:

UPDATE tblBiotaDefRules SET vchrValidChildList='''D'''
WHERE chrKingdomCode = 'P' AND chrRankCode = 'SKING';

Original comment by david.ba...@gmail.com on 18 Jul 2013 at 7:08