PhycoBank

02/14/2018

02:18 PM bug #7177 (Closed): Fix protectedTitleCache for Agents which have no data except the cache

Andreas Kohlbecker

02:15 PM bug #7177: Fix protectedTitleCache for Agents which have no data except the cache

applied to all databases! Andreas Kohlbecker

02:13 PM bug #7177: Fix protectedTitleCache for Agents which have no data except the cache

and the query to fix the data:
~~~sql
UPDATE AgentBase a left join AgentBase_AgentBase a_a on a_a.Team_id = a.id
... Andreas Kohlbecker

02:04 PM bug #7177: Fix protectedTitleCache for Agents which have no data except the cache

sql to test
~~~sql
select * from AgentBase a
where DTYPE = 'Person'
and a.lastname is null AND a.firstn... Andreas Kohlbecker

01/31/2018

01:29 PM bug #7177 (Resolved): Fix protectedTitleCache for Agents which have no data except the cache

already solved in the production data? Andreas Kohlbecker