<HTML>
<br>
<B>On Fri 29/05/09 6:31 PM , "Karl O. Pinc" kop@meme.com sent:<br>
</B>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #5167c6 2px solid; MARGIN-RIGHT: 0px">
<P>On 05/21/2009 12:05:41 PM, Niki Learn wrote:<br>
<SPAN style="COLOR: #666666">> -----Original Message-----</SPAN><br>
<SPAN style="COLOR: #666666">> From: <A href="mailto:babase-bounces@eeblistserv.Princeton.EDU">javascript:top.opencompose('babase-bounces@eeblistserv.Princeton.EDU','','','')</A></SPAN><br>
<SPAN style="COLOR: #666666">> [<A href="mailto:babase-bounces@eeblistserv.Princeton.EDU">javascript:top.opencompose('babase-bounces@eeblistserv.Princeton.EDU','','','')</A>] On Behalf Of kfenn</SPAN><br>
<SPAN style="COLOR: #666666">> Sent: Wednesday, May 20, 2009 12:37 PM</SPAN><br>
<SPAN style="COLOR: #666666">> To: The Baboon Database Project</SPAN><br>
<SPAN style="COLOR: #666666">> Subject: [Babase] VIV sexskin not uploading due to missing mdate</SPAN><br>
<SPAN style="COLOR: #666666">> </SPAN><br>
<SPAN style="COLOR: #666666">> Hi Karl,</SPAN><br>
<SPAN style="COLOR: #666666">> </SPAN><br>
<SPAN style="COLOR: #666666">> We have a perplexing question relation to uploading sexskin size date</SPAN><br>
<SPAN style="COLOR: #666666">> to</SPAN><br>
<SPAN style="COLOR: #666666">> the SEXSKINS_CYCLES view.</SPAN><br>
<SPAN style="COLOR: #666666">> </SPAN><br>
<SPAN style="COLOR: #666666">> One female, VIV, cycled in June of 2007 but shut down until October of</SPAN><br>
<SPAN style="COLOR: #666666">> </SPAN><br>
<SPAN style="COLOR: #666666">> the same year.</SPAN><br>
<SPAN style="COLOR: #666666">> </SPAN><br>
<SPAN style="COLOR: #666666">> Niki was trying to upload her October sizes and got the following</SPAN><br>
<SPAN style="COLOR: #666666">> error</SPAN><br>
<SPAN style="COLOR: #666666">> message:</SPAN><br>
<SPAN style="COLOR: #666666">> ERROR: Sxid 144307: Cid 27583: 2007-10-17: No Mdate found for this</SPAN><br>
<SPAN style="COLOR: #666666">> cycle</SPAN><br>
<SPAN style="COLOR: #666666">> </SPAN><br>
<SPAN style="COLOR: #666666">> OK, fair enough. We thought she was pregnant in June and entered her</SPAN><br>
<SPAN style="COLOR: #666666">> June Ddate into Pregs as a conceive date.</SPAN><br>
<SPAN style="COLOR: #666666">> </SPAN><br>
<SPAN style="COLOR: #666666">> However, in the following update period, I removed her pregnancy from</SPAN><br>
<SPAN style="COLOR: #666666">> PREGS when Jeanne decided this was not a real pregnancy.</SPAN><br>
<br>
I think Tabby nailed the problem: The automatic mdates were<br>
not updated when a pregnancy (PREGS row) was deleted.<br>
<br>
I believe I have (finally) fixed this. It would be good<br>
if somebody besides me would double check the fix by<br>
deleting a pregnancy and watching what happens to the<br>
automatic Mdates.</P>
<P style="COLOR: #0000cd"><SPAN style="COLOR: #000000">Cool. Lacey will still be working on her uploads for at least part of next week and Tabby and I are starting the process of determining the female ranks on Monday. I do have a false pregnancy from December I can delete to test this soon when I have a good opportunity.</SPAN></P>
<P>The next step is to fix the database. Either we need to<br>
remember all the pregnancies that have been deleted<br>
and manually make changes or we need to schedule a time<br>
for me to temporarily turn off all the data validation<br>
and rebuild the automatic Mdates.<br>
<br>
<SPAN style="COLOR: #0000cd">I should be able to figure out what other pregnancies have been deleted if that is the safer way to do this.</SPAN></P>
<P><SPAN style="COLOR: #666666">> FYI, today WEN has an mdate for the cycle in question - guess it just</SPAN><br>
<SPAN style="COLOR: #666666">> took a</SPAN><br>
<SPAN style="COLOR: #666666">> while for it to be automatically generated after we added her ddate.</SPAN><br>
<br>
That does not sound right. When a Ddate goes in there should always<br>
be an automatic Mdate right away. Did you see a time when there was<br>
a Ddate but not an automatic Mdate?</P>
<P style="COLOR: #0000cd">Hmm... It is possible that we only checked it once the day we added the ddate. If that is the case, we did it all it one query so perhaps it wouldn't have shown up until we did the query again. I will check this when I do the final upload on the 2007 sexskins in the next couple weeks and will let you know what I find.</P>
<P style="COLOR: #0000cd">Thanks!</P>
<P style="COLOR: #0000cd">Niki<br>
<br>
</P></BLOCKQUOTE></HTML>