Project

General

Profile

Actions

bug #6705

open

Remove remaining orphaned PolytomousKeyNodes

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

Status:
New
Priority:
Priority13
Category:
data
Target version:
Start date:
06/08/2017
Due date:
% Done:

0%

Estimated time:
Severity:
normal
Found in Version:

Description

There are PKN left that are linked to an existing key but have no parent but link to a taxon (so are no root nodes).

SELECT *
FROM PolytomousKeyNode pkn
WHERE pkn.parent_id IS NULL
AND pkn.taxon_id IS NOT NULL

Check carefully that they are not linked as parents and that they are not root nodes. Maybe run recursively until none is left.

Also use the script used in #6226 to remove orphaned KeyStatements afterwards.

There are 16 examples in cyprus.


Related issues

Copied from Edit - task #6226: Delete orphaned key nodesClosedAndreas Müller11/28/2016

Actions
Actions #1

Updated by Andreas Müller over 4 years ago

  • Copied from task #6226: Delete orphaned key nodes added
Actions #2

Updated by Andreas Müller over 4 years ago

  • Description updated (diff)
Actions #3

Updated by Andreas Müller over 3 years ago

  • Priority changed from Highest to Priority14
Actions #4

Updated by Andreas Müller over 3 years ago

  • Target version changed from CDM UML 5.0 to CDM UML 5.5
Actions #5

Updated by Andreas Müller about 3 years ago

  • Priority changed from Priority14 to Priority13
Actions #6

Updated by Andreas Müller over 2 years ago

  • Target version changed from CDM UML 5.5 to CDM UML 5.15
Actions #7

Updated by Andreas Müller over 1 year ago

  • Target version changed from CDM UML 5.15 to CDM UML 5.29
Actions

Also available in: Atom PDF