Hi

I just got a new RTE 3075:

Syntax error (missing operator) in query expression 'TaxonomyID IN (20)AND (DatePart('y', [When Seen]) >=1 AND DatePart('y', [When Seen])<=366 AND ObserverID=4 AND LocationID=ANY(Select DescendantIDFrom LocationDescendants Where LocationID=1) AND[Sightings.ThingID] IN ()'.

Hi Diana,

This bug is fixed in v3.7 - due out [no-date-yet]. This was reported in another post several months ago.

Thanks for typing the entire error message. It really helps. A screen shoot would have been just as effective and easier on your fingers.  

It has to do with attempting to View a Thing which is not in the selected taxonomic list.

Thanks,

Jeff

Hi Jeff,

I got another RTE 3075 while trying to work with "blue grouse".

I see no sightings for this bird or its splits when I look for it in View/Edit. 

But first: I went to Rosetta Stone to find out its new names.  In 'Thing Description', I typed 'Blue Grouse' and clicked Lookup.  In Tax: Clements World 08.  in the bottom field 'Dendragapus' shows up, but when I double clicked it I got a fatal error:

Could not find value "Dendragapus" in field 'Scientific Name for ssdbc Scientific Name. Latest Error Properties: 0=

Then I tried to find it in View/Edit. Filters: check Ignore year, X out dates, Me as observer,Location: World Name: Sooty Grouse, check ssp.  In the Ambiguous entry window I select Sooty Grouse, and since there is no option for Clements 08, I choose Clements 04, and I get the fatal error.  Same thing happens if I choose ABA list.  How do I find what happened to my sightings of blue grouse,  Dusky or Sooty?

Hi Diana,

Thanks much for the screenshots!

Same problem. Sooty Grouse did not exist in Clements 04. Nor in ABA before 2006.

So, be sure to use the latest versions of those tax lists in the View/Edit Setup window and then you will find your grouse sightings - but use Blue Grouse as the name to look for with the "SSP" checkbox checked (the checkbox to the right of the Name field).

The error you found in the Rosetta Stone is a true error! Never found before. Fixed for 3.7. It happens when you attempt to open a thing, as you found out, in the bottom grid which is a Genus-level thing; as Blue Grouse is in Clements 08.

Thanks!

Jeff

Hi Jeff,

I have the latest Clements Installed.  As you can see from the screen shot I used Clements 08 to search for Sooty Grouse, but Clements does not appear in the list of Tax Lists Referenced in the middle pane of the Ambiguous window.  If I proceed from the point of the screenshot I get the meltdown.  Same with trying to use other Tax lists from the choices in the middle pane.

I tried to find sightings by typing 'blue grouse', but I get nothing.  I have generated reports for Oregon and Colorado, where I know I have seen blue grouse and several other states and provinces where I likely saw it but the reports have no sightings for blue, dusky or sooty grouse.  Where did they go?

Diana

Hi Diana,

You must have added the Sooty Grouse thing. I fear you have gotten yourself into trouble by messing with things and taxonomic lists in BD. I strongly urge folks not to mess around with these settings as they are rather complicated - unless you are certain you understand them (which usually comes with an understanding of relational databases).

The tax lists work correctly out-of-the-box without modifications. You have modified things incorrectly and now are suffering the ramifications. BD is unlimited in its ability to modify most all things. Unfortunately with this ability comes the ability to shoot yourself in the foot and get unintended results.

In your example, you want to choose the Ambiguous thing Blue Grouse fuliginosous instead of the Sooty Grouse that you created and attached to Clements 2004 and 2005. This is the Thing which stands for Sooty Grouse in Clements 2008, and has since Clements 2004.

Let's start here and see if this gets you on the right path.

Let me know please. We will get you back to square one.

Jeff

Hi Diana,

Yes - unless you add specific species to the new locations you created, there are no things associated with them. What you should do, is simply use the Galapagos Islands location itself as your Location Filter. This will contain all species necessary for your data entry session.

As for where to go now, use Clements 08 only, as it seems that you have not modified it yet and move forward. If you have move some of your sightings to the thing that you created "Sooty Grouse", then do this:

1. In View/Edit Sightings Setup
2. Select Clements 05
3. Select Sooty Grouse and in the Ambiguous window, select your "sooty Grouse" thing. Since this thing is referenced in your Clements 05 tax list, it will find all such sightings and display them in the View/Edit Grid.
4. Now, select all those sightings and click Edit
5. Change them all to "Blue Grouse fuliginosous" in the Name field (be sure to check the checkbox to the left of the name field) - this will correctly change all of your sightings back to the thing they should be under ABA 2008 and Clements 08

That will get you back to square one with the latest tax lists.

Let me know if you have more questions.

Jeff

Hi Diana,

I don't understand, where - exactly - are you getting this RTE? Walk me through it please.

Jeff

Hi Diana,

Nice detail. (smiley face intended)

As we now know, the RTE in the View/Edit Setup window is due to selecting a thing and a tax list in the setup where the thing is not in the tax list selected.

What your details show me is that:

1. Your created Sooty thing is not in Clements 08 - we knew that
2. Your created Dusky thing is not in Clements 08 - also knew that

Your results above are what I expect based on the changes you made and the known RTE (fixed in 3.7) with View/Edit setup.

We also know,

1. You created two new things: dusky grouse and sooty grouse
2. And you added those to Clements 05 but not 08
3. And that Clements 08 references instead "blue grouse fuliginosous" and "blue grouse obscurus"

Make sense?

Jeff