<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
First time I hear about this.<br>
According to this:<br>
<a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/refman/5.1/en/connector-net-connection-options.html">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 class="literal">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.<br>
<br>
On 5/12/2011 8:37 PM, Caia Naxos wrote:
<blockquote
cite="mid:BANLkTinWN3rBDZiZd07cMHAZGD3TMh2mEQ@mail.gmail.com"
type="cite">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 class="Apple-style-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; orphans: 2; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px; font-size:
medium;"><span class="Apple-style-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
class="Apple-style-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; orphans: 2; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; font-size: medium;"><span
class="Apple-style-span" style="font-family:
Verdana,Arial,Helvetica,sans-serif; font-size: 13px;"><a
moz-do-not-send="true" name="bugnotes" id="bugnotes">
<div id="bugnotes_open" style="padding: 3px;">
<table class="width100" style="width: 1333px; border: 1px
solid rgb(0, 0, 0);" cellspacing="1">
<tbody>
<tr class="bugnote" id="c18385" style="vertical-align:
top;">
<td class="bugnote-note-public" 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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
<br>
</body>
</html>