Re: [Treebase-devel] Some results of testing with a user

[William P. <wil...@ya...>]

On Mar 18, 2010, at 9:06 PM, Vladimir Gapeyev wrote:

> (1) Unexpected different results on the Taxa tab -- a feature or a bug? E.g., find a single study, e.g. 10051. 
>     -- Click the study (which goes to Citation tab), then to Taxa tab ==> "Nothing to display"
>     -- Go to Matrices tab; click on "View Taxa" in the table ==> it goes back to the Taxa tab, showing lots of stuff
>     -- Go back to Citation tab; then Taxa tab  ==> "Nothing found to display" 
>    -- Go to Trees tab; click on "View Taxa" in the table ==> it goes back to the Taxa tab, showing lots of stuff.

It looks as though the taxon intel data did not get uploaded properly. Study 10051 has the taxon label "Polystichum acutidens DQ202419" which in my latest TI dump maps to the taxon variant "Polystichum acutidens" (namebankid 5977443) and that, in turn, maps to the taxon "Polystichum acutidens" (taxid 265680). But going through the browser shows no results under the taxon tab.

10052 has no taxon mappings (even though my TI tables do)
10053 has no taxon mappings (even though my TI tables do)
etc. 

I queried treebase-stage with this:

select * from taxonlabel join taxonvariant using (taxonvariant_id) where taxonlabel = 'Coniothyrium clematidis-rectae CBS 507.63'

Because 'Coniothyrium clematidis-rectae CBS 507.63' is one of the taxon labels in 10053 that fails to map to a taxonvariant. To my surprise, the results of the query show that the mapping is in place --  taxonlabel 'Coniothyrium clematidis-rectae CBS 507.63' is mapped to taxonvariant_id 562599 in the database.

So something is quite wrong here.  It looks like the March migration starts at S9931 -- I examined that one and the browser shows no taxon mapping. So then I looked prior to that, and only be the time I reached S2256 did the mapping work again. 

This is affecting too many records, and I'm worried that it is a harbinger of other problems. I think we need to resolve this.  

bp