Many synonym name usages have a blank classification

18144
Reporter: mblissett
Type: Bug
Summary: Many synonym name usages have a blank classification
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2016-01-11 16:49:13.013
Updated: 2016-01-13 11:07:54.189
Resolved: 2016-01-13 11:07:54.164
        
Description: 7 million synonyms name usages have a null kingdom (and the rest of the classification). This is an increase of around 3 million.

An example of one that has lost its classification:  http://www.gbif-uat.org/species/110762354 http://www.gbif.org/species/110762354 http://www.catalogueoflife.org/annual-checklist/2015/details/species/id/bef8a67575563cd32b103149489f9c37/synonym/8f14fed760eaffc69cc8b22f9bb123b1

SELECT COUNT(*), status, kingdom_fk IS NULL FROM name_usage WHERE deleted IS NULL GROUP BY status, kingdom_fk IS NULL ORDER BY 2, 3, 1;

Many of these names are in the test backbone, but the current backbone only includes names with a classification.

]]>
    

Author: mdoering@gbif.org
Created: 2016-01-13 11:07:38.462
Updated: 2016-01-13 11:07:38.462
        
There was an importer bug that all synonyms had no classification at all, incl pro parte ones.
Fixed here: https://github.com/gbif/checklistbank/commit/c249960f9a86cf306502257f9492cd7dfc6d3bd3

This means we need to reimport all checklists on production when the next clb-cli release is deployed!