bug #4624
closed
Opening a synonym without a taxon in a classification shows duplicate errors
Added by Andreas Müller about 9 years ago.
Updated almost 6 years ago.
Description
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.
- Status changed from New to In Progress
testen, ob es mit orphaned Taxon zu tun hat???
- Target version deleted ()
- Priority changed from Priority08 to Priority12
- Description updated (diff)
- Priority changed from Priority12 to Priority14
- Target version changed from Reviewed Next Major Release to Release 5.1
Is this still an open issue?
- Private changed from Yes to No
Synonyms without taxa can not be found by the search, only by the bulk editor.
- Status changed from In Progress to Worksforme
- Target version deleted (
Release 5.1)
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.
Also available in: Atom
PDF