parent_concept_id exists and is valid species, but species_concept_id is null

11423
Reporter: bko
Type: Bug
Summary: parent_concept_id exists and is valid species, but species_concept_id is null
Priority: Major
Resolution: WontFix
Status: Closed
Created: 2012-06-14 15:31:57.107
Updated: 2013-12-17 15:23:04.005
Resolved: 2013-11-06 14:53:18.091
        
Description: While working on Kenya checklist in parent-child format exportation, some infraspecific names are found valid, have parent_concept as a species, but doesn't have species_concept id.
On portal of mogo:
select id, parent_concept_id, species_concept_id, is_accepted from taxon_concept where id in (5251977, 5252003, 5251983);
shows some of these cases.]]>
    

Author: mdoering@gbif.org
Created: 2012-06-14 23:21:47.637
Updated: 2012-06-14 23:21:47.637
        
The variety Fusarium oxysporum cubense W.C. Snyder & H.N. Hansen, 1940 in the nub has a species and also a species_fk in the clb name_usage table, but apparently no species_concept_id in the portal db.

http://ecat-dev.gbif.org/usage/5251977
    

Author: bko@gbif.org
Comment: Hi [~kbraak@gbif.org] - would be good to note the reason why this issue is resolved with "Won't fix." Is it because the new processing doesn't produce this issue?
Created: 2013-11-06 15:05:44.876
Updated: 2013-11-06 15:05:44.876

Author: kbraak@gbif.org
Created: 2013-11-06 15:19:33.393
Updated: 2013-11-06 15:19:33.393
        
That's correct. The old portal index will no longer be modified.

Please take a look at http://api.gbif.org/v0.9/species/5251977 and open a new issue if there are problems in CLB, I suppose.