Project

General

Profile

bug #7179

Phycobank: set protectedTitleCaches = 1 where Person contains no data

Added by Andreas Kohlbecker over 1 year ago. Updated 9 months ago.

Status:
Closed
Priority:
New
Category:
data
Target version:
-
Start date:
01/15/2018
Due date:
% Done:

100%

Severity:
normal
Found in Version:
Tags:

Description

For imported data (from IAPT) the protectedCollectorTitleCache and protectedNomenclaturalTitleCache are initially null which is interpreted as false. But for most Teams or Persons no atomized data is entered so far.


Changing original subject:

The Teams should not be modified since they might contain data manually edited by Henning.

History

#1 Updated by Andreas Kohlbecker over 1 year ago

these sql statements fix the issue


UPDATE AgentBase a SET protectedTitleCache = 1 
    WHERE DTYPE = 'Person' AND a.firstname IS NULL 
    AND a.lastname IS NULL AND a.suffix IS NULL AND a.prefix IS NULL AND a.initials IS NULL

#2 Updated by Andreas Kohlbecker over 1 year ago

  • Description updated (diff)

#3 Updated by Andreas Kohlbecker over 1 year ago

  • Subject changed from Phycobank: set protectedTitleCaches = 1 where Person or Team contains no data to Phycobank: set protectedTitleCaches = 1 where Person contains no data
  • Description updated (diff)

#4 Updated by Andreas Kohlbecker over 1 year ago

  • Status changed from New to In Progress

#5 Updated by Andreas Kohlbecker over 1 year ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 50

needs to be applied to the production db after discussion with henning

#6 Updated by Andreas Kohlbecker over 1 year ago

  • Description updated (diff)

#7 Updated by Andreas Kohlbecker over 1 year ago

  • Status changed from Resolved to Closed

applied to the production database

#8 Updated by Andreas Kohlbecker over 1 year ago

  • % Done changed from 50 to 100

#9 Updated by Andreas Kohlbecker 11 months ago

  • Status changed from Closed to In Progress
  • Target version changed from Release 4.13 to Release 5.2
  • % Done changed from 100 to 20

This only has been fixed for protectedTitleCache. The flags protectedCollectorTitleCache and protectedNomenclaturalTitleCache still need to be fixed!

#10 Updated by Andreas Kohlbecker 11 months ago

fixing

UPDATE AgentBase a SET protectedCollectorTitleCache = 1 
    WHERE DTYPE = 'Person' AND a.givenName IS NULL 
    AND a.familyName IS NULL AND a.suffix IS NULL AND a.prefix IS NULL AND a.initials IS NULL 
    AND protectedCollectorTitleCache IS NULL

this affects the following data:

Person  79  2016-09-20 09:50:38 620718b8-4289-4901-9ac2-0ef3ee21e1a6                            1   Moser et al.                Moser et al.                                                        
Person  160 2016-09-20 09:50:39 e86708da-e837-4116-a473-f0732f315217                            1   Iser.               Iser.                                                       
Person  182 2016-09-20 09:50:39 2986ebc6-c771-4ee8-9425-b42dec557ae0                            1   Dragastan               Dragastan                                                       
Person  202 2016-09-20 09:50:39 a0b62ac8-52c6-4a0e-ab06-53c83a99398f                            1   Pizzuto             Pizzuto                                                     
Person  224 2016-09-20 09:50:40 783fcd8e-5fe4-489d-bbb7-cf059710f01e                            1   Pothe de Baldis             Pothe de Baldis                                                     
Person  234 2016-09-20 09:50:40 a93458cb-481e-4fdc-91e2-9632518aa27b                            1   Klöser             Klöser                                                     
Person  268 2016-09-20 09:50:40 2c82e24e-7bb1-4be7-9af0-5f9426e9fe1e                            1   Prof. Leistikow, Frankfurt              Prof. Leistikow, Frankfurt                                                      
Person  270 2016-09-20 09:50:40 2c392862-fc76-4eeb-a1b0-828ab385f55b                            1   Østrup             Østrup                                                     
Person  271 2016-09-20 09:50:40 79000f30-0ba0-4709-bbf1-79a349d1414e                            1   Beatrice Flad-Schnorrenberg             Beatrice Flad-Schnorrenberg                                                     
Person  276 2016-09-20 09:50:41 b328f593-c1e4-40d5-9b48-8d219c9172d6                            1   Cleve-Euler             Cleve-Euler                                                     
Person  409 2016-09-20 09:50:41 3c93709c-b460-489e-b661-ced4dbc18617                            1   Balashova               Balashova                                                       
Person  459 2016-09-20 09:50:42 bf237d47-4d99-402e-b8fb-0e9e3eb4944c                            1   Komura              Komura                                                      
Person  560 2016-09-20 09:50:43 d8dfad9c-a36f-4571-9799-3731b204fc94                            1   Melendi             Melendi                                                     
Person  561 2016-09-20 09:50:43 1c85edd6-3fcd-4c4f-8ae7-2236e4d7b3ef                            1   Volkh.              Volkh.                                                      
Person  665 2016-09-20 09:50:43 590030c4-63b8-40ba-a1ed-073baf3eaeef                            1   Hagino              Hagino                                                      
Person  760 2016-09-20 09:50:44 495a662a-6976-4412-8e25-78192de6445e                            1   Barker              Barker                                                      
Person  763 2016-09-20 09:50:44 bb6970e2-fdff-4306-a8a3-64786eb0d9b1                            1   Long                Long                                                        
Person  765 2016-09-20 09:50:44 88564fe2-e067-4113-afa3-3b097304a7a2                            1   Smith               Smith                                                       
Person  884 2016-09-20 09:50:45 59caad62-65fc-4fd6-b6bb-192f120404b3                            1   Sirodot             Sirodot                                                     
Person  915 2016-09-20 09:50:45 fbd85f49-00af-4929-9970-d8fd90987426                            1   Akiyama             Akiyama                                                     
Person  1047    2016-09-20 09:50:49 99032128-eaf9-4e28-afce-62c9e8da0e49                            1   Souza               Souza                                                       
Person  1059    2016-09-20 09:50:50 85a3be3a-114f-40a3-bab8-1f1a6f0cc4fb                            1   Brockmann               Brockmann                                                       
Person  2370    2018-04-25 08:09:29 c2fb9a1d-189f-41b3-9f6b-1c50b66da739                            0   Person#2370<c2fb9a1d-189f-41b3-9f6b-1c50b66da739>               Person#2370<c2fb9a1d-189f-41b3-9f6b-1c50b66da739>                                           21          
Person  1183    2016-09-20 09:50:51 8c0a9c57-5ff0-4872-b077-22b084a434ae                            1   Prof. Th.M. Fries               Prof. Th.M. Fries                                                       
Person  1196    2016-09-20 09:50:51 25ec909a-63c7-41df-9c17-4d0c5357845f                            1   Kogame              Kogame                                                      
Person  1205    2016-09-20 09:50:51 1f048b01-8512-4e89-a9ca-222c9baad928                            1   Tognetto                Tognetto                                                        
Person  2371    2018-04-25 08:15:00 6fc2921f-0845-4539-8625-f644e1024432    2018-04-25 08:18:25                     0   International Commission on Zoological Nomenclature             International Commission on Zoological Nomenclature                                         21  21      
Person  1320    2016-12-02 15:59:57 3fa82d24-6171-4857-9113-decb1c7333e1    2016-12-02 15:59:59                     1   Pfitzer             Pfitzer                                         10  10      
Person  1382    2016-12-05 09:50:13 c3fadbfa-b00e-4153-8482-c7babcccd7d1    2016-12-05 09:50:15                     1   L.              L.                                          10  10      
Person  1439    2016-12-05 14:27:24 fe252436-0860-4895-b6f5-154e1c8b3dcb    2016-12-05 14:27:25                     1   Berthold                Berthold                                            10  10      
Person  1461    2016-12-05 15:02:03 8ba80994-8592-4500-90da-8f55718d0adb    2016-12-05 15:23:35                     1   Bourrelly               Bourrelly                                           10  10      
Person  1533    2017-01-23 15:19:18 6b53ff0c-577d-4304-bb49-5a5f687b9065    2017-01-23 15:19:20                     1   Perty               Perty                                           21  21      
Person  1554    2017-01-23 16:50:36 400219e9-8553-4b1c-a702-6fe622c662e6    2017-01-23 16:50:37                     1   Lemoine             Lemoine                                         21  21      
Person  2414    2018-06-11 13:08:54 03aaf454-2e35-4a80-b699-6181de607864    2018-06-11 13:12:09                     0   Kulikovskiy             Kulikovskiy                                         21  21      
Person  2415    2018-06-11 13:08:54 ed5c4543-2b77-4fde-b37b-5976cadf168a    2018-06-11 13:12:09                     0   Lange-Bert.             Lange-Bert.                                         21  21      
Person  2158    2017-10-20 16:02:22 c291feb8-e402-48c9-aa83-5d25042ee713    2017-10-20 16:02:25                     1   Zerdoner                Zerdoner                                            21  21      

#11 Updated by Andreas Kohlbecker 11 months ago

fixing protectedNomenclaturalTitleCache

UPDATE AgentBase a SET protectedNomenclaturalTitleCache = 1 
    WHERE DTYPE = 'Person' AND a.givenName IS NULL 
    AND a.familyName IS NULL AND a.suffix IS NULL AND a.prefix IS NULL AND a.initials IS NULL 
    AND protectedNomenclaturalTitleCache IS NULL

this affects the following data:

Person  79  2016-09-20 09:50:38 620718b8-4289-4901-9ac2-0ef3ee21e1a6                            1   Moser et al.                Moser et al.                                    1                   
Person  160 2016-09-20 09:50:39 e86708da-e837-4116-a473-f0732f315217                            1   Iser.               Iser.                                   1                   
Person  182 2016-09-20 09:50:39 2986ebc6-c771-4ee8-9425-b42dec557ae0                            1   Dragastan               Dragastan                                   1                   
Person  202 2016-09-20 09:50:39 a0b62ac8-52c6-4a0e-ab06-53c83a99398f                            1   Pizzuto             Pizzuto                                 1                   
Person  224 2016-09-20 09:50:40 783fcd8e-5fe4-489d-bbb7-cf059710f01e                            1   Pothe de Baldis             Pothe de Baldis                                 1                   
Person  234 2016-09-20 09:50:40 a93458cb-481e-4fdc-91e2-9632518aa27b                            1   Klöser             Klöser                                 1                   
Person  268 2016-09-20 09:50:40 2c82e24e-7bb1-4be7-9af0-5f9426e9fe1e                            1   Prof. Leistikow, Frankfurt              Prof. Leistikow, Frankfurt                                  1                   
Person  270 2016-09-20 09:50:40 2c392862-fc76-4eeb-a1b0-828ab385f55b                            1   Østrup             Østrup                                 1                   
Person  271 2016-09-20 09:50:40 79000f30-0ba0-4709-bbf1-79a349d1414e                            1   Beatrice Flad-Schnorrenberg             Beatrice Flad-Schnorrenberg                                 1                   
Person  276 2016-09-20 09:50:41 b328f593-c1e4-40d5-9b48-8d219c9172d6                            1   Cleve-Euler             Cleve-Euler                                 1                   
Person  409 2016-09-20 09:50:41 3c93709c-b460-489e-b661-ced4dbc18617                            1   Balashova               Balashova                                   1                   
Person  459 2016-09-20 09:50:42 bf237d47-4d99-402e-b8fb-0e9e3eb4944c                            1   Komura              Komura                                  1                   
Person  560 2016-09-20 09:50:43 d8dfad9c-a36f-4571-9799-3731b204fc94                            1   Melendi             Melendi                                 1                   
Person  561 2016-09-20 09:50:43 1c85edd6-3fcd-4c4f-8ae7-2236e4d7b3ef                            1   Volkh.              Volkh.                                  1                   
Person  665 2016-09-20 09:50:43 590030c4-63b8-40ba-a1ed-073baf3eaeef                            1   Hagino              Hagino                                  1                   
Person  760 2016-09-20 09:50:44 495a662a-6976-4412-8e25-78192de6445e                            1   Barker              Barker                                  1                   
Person  763 2016-09-20 09:50:44 bb6970e2-fdff-4306-a8a3-64786eb0d9b1                            1   Long                Long                                    1                   
Person  765 2016-09-20 09:50:44 88564fe2-e067-4113-afa3-3b097304a7a2                            1   Smith               Smith                                   1                   
Person  884 2016-09-20 09:50:45 59caad62-65fc-4fd6-b6bb-192f120404b3                            1   Sirodot             Sirodot                                 1                   
Person  915 2016-09-20 09:50:45 fbd85f49-00af-4929-9970-d8fd90987426                            1   Akiyama             Akiyama                                 1                   
Person  1047    2016-09-20 09:50:49 99032128-eaf9-4e28-afce-62c9e8da0e49                            1   Souza               Souza                                   1                   
Person  1059    2016-09-20 09:50:50 85a3be3a-114f-40a3-bab8-1f1a6f0cc4fb                            1   Brockmann               Brockmann                                   1                   
Person  2370    2018-04-25 08:09:29 c2fb9a1d-189f-41b3-9f6b-1c50b66da739                            0   Person#2370<c2fb9a1d-189f-41b3-9f6b-1c50b66da739>               Person#2370<c2fb9a1d-189f-41b3-9f6b-1c50b66da739>                                   1       21          
Person  1183    2016-09-20 09:50:51 8c0a9c57-5ff0-4872-b077-22b084a434ae                            1   Prof. Th.M. Fries               Prof. Th.M. Fries                                   1                   
Person  1196    2016-09-20 09:50:51 25ec909a-63c7-41df-9c17-4d0c5357845f                            1   Kogame              Kogame                                  1                   
Person  1205    2016-09-20 09:50:51 1f048b01-8512-4e89-a9ca-222c9baad928                            1   Tognetto                Tognetto                                    1                   
Person  2371    2018-04-25 08:15:00 6fc2921f-0845-4539-8625-f644e1024432    2018-04-25 08:18:25                     0   International Commission on Zoological Nomenclature             International Commission on Zoological Nomenclature                                 1       21  21      
Person  1320    2016-12-02 15:59:57 3fa82d24-6171-4857-9113-decb1c7333e1    2016-12-02 15:59:59                     1   Pfitzer             Pfitzer                                 1       10  10      
Person  1382    2016-12-05 09:50:13 c3fadbfa-b00e-4153-8482-c7babcccd7d1    2016-12-05 09:50:15                     1   L.              L.                                  1       10  10      
Person  1439    2016-12-05 14:27:24 fe252436-0860-4895-b6f5-154e1c8b3dcb    2016-12-05 14:27:25                     1   Berthold                Berthold                                    1       10  10      
Person  1461    2016-12-05 15:02:03 8ba80994-8592-4500-90da-8f55718d0adb    2016-12-05 15:23:35                     1   Bourrelly               Bourrelly                                   1       10  10      
Person  1533    2017-01-23 15:19:18 6b53ff0c-577d-4304-bb49-5a5f687b9065    2017-01-23 15:19:20                     1   Perty               Perty                                   1       21  21      
Person  1554    2017-01-23 16:50:36 400219e9-8553-4b1c-a702-6fe622c662e6    2017-01-23 16:50:37                     1   Lemoine             Lemoine                                 1       21  21      
Person  2414    2018-06-11 13:08:54 03aaf454-2e35-4a80-b699-6181de607864    2018-06-11 13:12:09                     0   Kulikovskiy             Kulikovskiy                                 1       21  21      
Person  2415    2018-06-11 13:08:54 ed5c4543-2b77-4fde-b37b-5976cadf168a    2018-06-11 13:12:09                     0   Lange-Bert.             Lange-Bert.                                 1       21  21      
Person  2158    2017-10-20 16:02:22 c291feb8-e402-48c9-aa83-5d25042ee713    2017-10-20 16:02:25                     1   Zerdoner                Zerdoner                                    1       21  21      

#12 Updated by Andreas Kohlbecker 11 months ago

  • Status changed from In Progress to Closed
  • % Done changed from 20 to 100

finally fixed! All changes applied to the phycobank production database

#13 Updated by Andreas Müller 9 months ago

  • Target version deleted (Release 5.2)

I guess this is only data related and therefore target version can be removed. Correct?

#14 Updated by Andreas Kohlbecker 9 months ago

correct!

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)