Project

General

Profile

bug #4624

Opening a synonym without a taxon in a classification shows duplicate errors

Added by Andreas Müller over 4 years ago. Updated over 1 year ago.

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

0%

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.

History

#1 Updated by Katja Luther over 4 years ago

  • Status changed from New to In Progress

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

#2 Updated by Katja Luther over 4 years ago

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

#3 Updated by Andreas Müller over 1 year 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?

#4 Updated by Andreas Müller over 1 year ago

  • Private changed from Yes to No

#5 Updated by Katja Luther over 1 year ago

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

#6 Updated by Katja Luther over 1 year ago

#7 Updated by Andreas Müller over 1 year 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.

#8 Updated by Katja Luther over 1 year ago

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)