Project

General

Profile

Actions

bug #5826

closed

Clean up names with empty name descriptions

Added by Andreas Müller about 7 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Priority14
Category:
data
Target version:
Start date:
Due date:
% Done:

100%

Estimated time:
Severity:
normal
Found in Version:

Description

As described in #5638 many empty NameDescriptions have been created in the past. These should be deleted from the database.

Actions #1

Updated by Andreas Müller almost 7 years ago

  • Status changed from New to In Progress
  • Priority changed from New to Priority14
Actions #2

Updated by Andreas Müller almost 7 years ago

  • Status changed from In Progress to Resolved

Fixed by r28664

Actions #3

Updated by Andreas Müller almost 7 years ago

Some SQL statements for testing

SELECT db.id, dba.DTYPE, dba.feature_id, db.created
FROM DescriptionBase db INNER JOIN DescriptionElementBase dba ON dba.indescription_id = db.id
WHERE db.DTYPE = 'TaxonNameDescription' AND 
 EXISTS (SELECT * FROM DescriptionElementBase deb WHERE deb.indescription_id = db.id AND 
        deb.id NOT IN 
                (SELECT id
                FROM DescriptionElementBase deb
                WHERE deb.feature_id = 952  ));

 SELECT *
FROM DefinedTermBase dtb 
WHERE dtb.titleCache like '%Protolo%' OR id = 953;

SELECT *
FROM DescriptionElementBase deb
WHERE deb.feature_id = 952;

SELECT *
FROM DescriptionBase db 
WHERE db.DTYPE = 'TaxonNameDescription' AND 
 NOT EXISTS (SELECT * FROM DescriptionElementBase deb WHERE deb.indescription_id = db.id );
Actions #4

Updated by Andreas Müller over 6 years ago

  • Description updated (diff)
  • Status changed from Resolved to Closed
  • % Done changed from 0 to 100
Actions #5

Updated by Andreas Müller over 6 years ago

  • Private changed from Yes to No
Actions

Also available in: Atom PDF