<div>Diva: Thank you. We put in that new bit to allow zero datetime and it seems to solve that problem - no more crashing on login, but... </div><div><br></div><div>I hate that there is a but and that this seems to be leading to another issue, perhaps - I am submitting another message titled "7.1 Diva Mesh Upload error?" in case <br>
</div><div>it needs to be looked at separately.</div><div><br></div><div>But your solution, Diva, does address the crash on login problem - we just saw another issue that seems to be related to uploading Mesh.<br></div><div>
<br></div><div><br></div><div class="gmail_quote">On Thu, May 12, 2011 at 10:58 PM, Diva Canto <span dir="ltr"><<a href="mailto:diva@metaverseink.com" target="_blank">diva@metaverseink.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#ffffff">
First time I hear about this.<br>
According to this:<br>
<a href="http://dev.mysql.com/doc/refman/5.1/en/connector-net-connection-options.html" target="_blank">http://dev.mysql.com/doc/refman/5.1/en/connector-net-connection-options.html</a><br>
there is an Allow Zero Datetime option. According to Melanie, it
looks like we need to add it to the connection string.<br>
<br>
Edit your MyWorld.ini; your connection string should look like:<br>
ConnectionString = "Data Source=localhost;Database=opensim;User
ID=opensim;Password=***;Old Guids=true;<code>Allow
Zero Datetime=true;</code>"<br>
<br>
(don't forget the last ';')<br>
<br>
Let me know if that solves the problem, and I'll add it to the
default connection string in the next release. Also in OpenSim inis.<div><div><br>
<br>
On 5/12/2011 8:37 PM, Caia Naxos wrote:
</div></div><blockquote type="cite"><div><div>Did a test installing 0.7.1 fresh, with a new
database. No problems. I decided to try upgrading the existing
installation. Didn't see any problems, so tried logging in. Ran
into an error: <span style="border-collapse:separate;color:rgb(0, 0, 0);font-family:Times;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:13px;text-align:left">Unable to convert MySQL date/time value to
System.DateTime - and then there's a crash. In researching I
found this Mantis record: #0005474 which seemed to mirror our
problem. I also saw a resolution: </span></span><span style="border-collapse:separate;color:rgb(0, 0, 0);font-family:Times;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;font-size:medium"><span style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:13px"><a name="12feef1c197f0961_12fe78153429f081_bugnotes">
<div style="padding:3px">
<table style="width:1333px;border:1px solid rgb(0, 0, 0)" cellspacing="1">
<tbody>
<tr style="vertical-align:top">
<td style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10pt;padding:4px;text-align:left;background-color:rgb(232, 232, 232);color:rgb(0, 0, 0);width:989px">
The new connector has an option to allow a zero
datetime, which needs to be added to the connect
string.</td>
</tr>
</tbody>
</table>
</div>
</a></span></span>
<div><br>
</div>
<div>What I need to know is which is the 'new connector' and how
do I format the data to be entered - just a bit of
clarification. <br clear="all">
</div>
<div><br>
</div>
<div>Thanks!</div>
<br>
-- <br>
Caia<br>
</div></div><pre>_______________________________________________
Opensim-users mailing list
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre> </blockquote>
<br>
</div>
<br>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Caia<br>