Project

General

Profile

Actions

bug #2449

open

Some or many names have an empty fullTitleCache though information is atomized

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

Status:
In Progress
Priority:
Priority14
Category:
cdmlib
Target version:
Start date:
Due date:
% Done:

30%

Estimated time:
Severity:
major
Found in Version:
Tags:

Description

E.g. Cicerbita duthieana in Cichorieae or Aiphanes bicornis Cerón & R.Bernal in PalmWeb

It looks like this accounts mainly to updated names.

Examples can be found in AlgaTerra and FM (see #note-9). For remaining issue see #note-10


Related issues

Related to EDIT - bug #2448: Missing updated by/when (e.g. in PalmWeb)WorksformeAndreas Müller

Actions
Related to EDIT - bug #9649: Specimens sometimes have empty titleCache instead of class<UUID>ClosedAndreas Müller

Actions
Related to EDIT - bug #9665: Filter out property change event for created and updated and cacheStrategy ClosedAndreas Müller

Actions
Actions #1

Updated by Andreas Müller over 12 years ago

maybe related to #2448

Actions #2

Updated by Andreas Müller over 2 years ago

  • Related to bug #2448: Missing updated by/when (e.g. in PalmWeb) added
Actions #3

Updated by Andreas Müller over 2 years ago

  • Related to bug #9649: Specimens sometimes have empty titleCache instead of class<UUID> added
Actions #4

Updated by Andreas Müller over 2 years ago

  • Related to bug #9665: Filter out property change event for created and updated and cacheStrategy added
Actions #5

Updated by Andreas Müller over 2 years ago

  • Description updated (diff)
  • Status changed from New to Resolved
  • Target version changed from cdmlib - Old Next Major Release to Release 5.45

Check if this is fixed with #9665

Actions #6

Updated by Andreas Müller over 2 years ago

  • Private changed from Yes to No
Actions #7

Updated by Andreas Müller over 2 years ago

  • Priority changed from Highest to Priority14
Actions #9

Updated by Andreas Müller about 2 years ago

An empty fullTitleCache with atomized data was not found anywhere. Empty fullTitleCaches exist for fully empty data which have something like TaxonName#9617 in the titleCache. So empty fullTitleCaches are not replaced by this default yet. But maybe this is also not necessary.

Only in algaterra_old I found records with also empty titleCache which needs to be further checked. Even after running cacheUpdate and trying to edit the names manually.

SELECT id, protectedTitleCache, protectedFullTitleCache, titleCache, fullTitleCache , tn.*
    FROM TaxonName tn
    WHERE tn.titleCache IS NULL OR tn.titleCache = '' OR tn.fullTitleCache IS NULL OR tn.fullTitleCache = ''
    ;

    SELECT *
    FROM OriginalSourceBase osb
    WHERE osb.sourcedName_id IN (
    SELECT id
    FROM TaxonName tn
    WHERE tn.titleCache IS NULL OR tn.titleCache = '' OR tn.fullTitleCache IS NULL OR tn.fullTitleCache = ''
) ;

Also in Flora Malesiana after running cache update (#9650).

Pro-iBiosphere eupolybothrus_pilot has empty titleCache with atomized data but this has no CDM Server anymore and was not yet cache updated. => the DB is archived in the meanwhile.

Also rl_standardliste has them but was not yet cache udpated. => do not exist anymore after cache updating (#9650)

Actions #10

Updated by Andreas Müller about 2 years ago

  • Status changed from Resolved to In Progress

Also Algaterra was saved correctly when the name was explicitly stored differently and then changed back.

Only remaining problem: if only a nom. ref. exists it is not saved as suche in the fullTitleCache but null is saved instead (at least this was the case for the algaterra records). This needs to be checked and corrected if necessary. In the TaxEditor this can not be seen as it is shown correctly for some reason.

Actions #11

Updated by Andreas Müller about 2 years ago

  • Description updated (diff)

Also the 2 examples from the description are handled correctly in the meanwhile.

Actions #12

Updated by Andreas Müller about 2 years ago

  • % Done changed from 0 to 30
Actions #13

Updated by Andreas Müller about 1 year ago

  • Tags set to formatting
  • Description updated (diff)
Actions

Also available in: Atom PDF