Uploaded image for project: 'Portal'
  1. Portal
  2. POR-3007

NUB: Some classification keys do not exist in the database

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Checklistbank
    • Labels:

      Description

      SELECT n.id, n.phylum_fk, p.id FROM name_usage n LEFT JOIN name_usage p ON n.phylum_fk = p.id WHERE n.phylum_fk IS NOT NULL AND p.id IS NULL AND n.dataset_key = 'd7dddbf4-2cf0-4f39-9b2a-bb099caae36c' AND n.deleted IS NULL LIMIT 10000;

      4048 names are returned — they have a phylum_fk, but these ids don't exist in the table.

      3118 for family_fk, 1970 for class_fk, 24171 for genus_fk, and 23351 for parent_fk.

      Most of these are accepted names.

        Gliffy Diagrams

        Issue Links

          Activity

          Hide
          Markus Döring added a comment -

          This only shows up in the nub, not any other checklist. Likely a nub build based issue

          Show
          Markus Döring added a comment - This only shows up in the nub, not any other checklist. Likely a nub build based issue
          Hide
          Markus Döring added a comment -

          Fixed. Query returns zero records now

          Show
          Markus Döring added a comment - Fixed. Query returns zero records now

            People

            • Assignee:
              Markus Döring
              Reporter:
              Matthew Blissett
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: