Opening a synonym without a taxon in a classification shows duplicate errors
Happened during caryophyllales deleting of some taxa and names
Öffnen eines Synonym-Suchergebnisses, das nicht(?) an einem Taxon hängt, ohne TaxonNode, führt erst zu Unexpected Error, dann zu "normaler" Fehlermeldung, dass dies nicht geöffnet werden kann.
#7 Updated by Andreas Müller about 2 years ago
- Status changed from In Progress to Worksforme
- Target version deleted (
As far as I remember the ticket was not about orphaned synonyms but about synonyms attached to orphaned taxa.
These can be found by
SELECT acc.id taxonId, n.id nameId, n.nameCache, n.titleCache , synName.nameCache FROM TaxonBase acc LEFT OUTER JOIN TaxonName n ON acc.name_id = n.id INNER JOIN TaxonBase syn ON syn.acceptedTaxon_id = acc.id LEFT OUTER JOIN TaxonName synName ON syn.name_id = synName.id WHERE acc.id NOT IN (SELECT tn.taxon_id FROM TaxonNode tn WHERE tn.taxon_id IS NOT NULL) AND acc.DTYPE = 'Taxon'
In Caryophyllales we 1 such case: Arenaria subg. Solitaria which is attached to Solitaria (McNeill) Sadeghian & Zarre.
It can be found by search but opening only gives a message, that the accepted taxon is not in a classification - but no exception is thrown anymore.
So I think we can close this ticket.