Project

General

Profile

Actions

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.

Status:
Worksforme
Priority:
Priority14
Assignee:
Category:
taxeditor
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Severity:
normal
Found in Version:

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.

Actions #1

Updated by Katja Luther about 9 years ago

  • Status changed from New to In Progress

testen, ob es mit orphaned Taxon zu tun hat???

Actions #2

Updated by Katja Luther about 9 years ago

  • Target version deleted ()
  • Priority changed from Priority08 to Priority12
Actions #3

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?

Actions #4

Updated by Andreas Müller almost 6 years ago

  • Private changed from Yes to No
Actions #5

Updated by Katja Luther almost 6 years ago

Synonyms without taxa can not be found by the search, only by the bulk editor.

Actions #6

Updated by Katja Luther almost 6 years ago

Actions #7

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.

Actions #8

Updated by Katja Luther almost 6 years ago

Actions

Also available in: Atom PDF