bug #4624
closedOpening a synonym without a taxon in a classification shows duplicate errors
0%
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.
Updated by Katja Luther about 9 years ago
- Status changed from New to In Progress
testen, ob es mit orphaned Taxon zu tun hat???
Updated by Katja Luther about 9 years ago
- Target version deleted ()
- Priority changed from Priority08 to Priority12
Updated by Andreas Müller almost 6 years ago
- 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?
Updated by Katja Luther almost 6 years ago
Synonyms without taxa can not be found by the search, only by the bulk editor.
Updated by Katja Luther almost 6 years ago
- Related to feature request #7411: adapt mediaCreated in taxeditor to timePeriod added
Updated by Andreas Müller almost 6 years ago
- 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.
Updated by Katja Luther almost 6 years ago
- Related to deleted (feature request #7411: adapt mediaCreated in taxeditor to timePeriod)