bug #7179
closedPhycobank: set protectedTitleCaches = 1 where Person contains no data
100%
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.
Updated by Andreas Kohlbecker over 6 years 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
Updated by Andreas Kohlbecker over 6 years 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)
Updated by Andreas Kohlbecker over 6 years ago
- Status changed from New to In Progress
Updated by Andreas Kohlbecker over 6 years 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
Updated by Andreas Kohlbecker over 6 years ago
- Status changed from Resolved to Closed
applied to the production database
Updated by Andreas Kohlbecker almost 6 years 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!
Updated by Andreas Kohlbecker almost 6 years 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
Updated by Andreas Kohlbecker almost 6 years 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
Updated by Andreas Kohlbecker almost 6 years ago
- Status changed from In Progress to Closed
- % Done changed from 20 to 100
finally fixed! All changes applied to the phycobank production database
Updated by Andreas Müller over 5 years ago
- Target version deleted (
Release 5.2)
I guess this is only data related and therefore target version can be removed. Correct?