Project

General

Profile

bug #5826

Clean up names with empty name descriptions

Added by Andreas Müller almost 3 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Priority14
Category:
data
Target version:
Start date:
07/08/2016
Due date:
% Done:

100%

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.

Associated revisions

Revision 71757814 (diff)
Added by Andreas Müller almost 3 years ago

#5826 Clean up names with empty name descriptions

Revision 4229bb22 (diff)
Added by Andreas Müller over 2 years ago

ref #5826 adapt update script

History

#1 Updated by Andreas Müller almost 3 years ago

  • Status changed from New to In Progress
  • Priority changed from New to Priority14

#2 Updated by Andreas Müller almost 3 years ago

  • Status changed from In Progress to Resolved

Fixed by r28664

#3 Updated by Andreas Müller almost 3 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 );

#4 Updated by Andreas Müller over 2 years ago

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

#5 Updated by Andreas Müller over 2 years ago

  • Private changed from Yes to No

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)