[Opensim-users] attempt to upgrade Diva to 0.7.1 from 0.7.0.2 - crash on login

[Diva Canto]

First time I hear about this.
According to this:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-connection-options.html
there is an Allow Zero Datetime option. According to Melanie, it looks 
like we need to add it to the connection string.

Edit your MyWorld.ini; your connection string should look like:
ConnectionString = "Data Source=localhost;Database=opensim;User 
ID=opensim;Password=***;Old Guids=true;|Allow Zero Datetime=true;|"

(don't forget the last ';')

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.

On 5/12/2011 8:37 PM, Caia Naxos wrote:
> 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: 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:
> The new connector has an option to allow a zero datetime, which needs 
> to be added to the connect string.
>
>
> 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.
>
> Thanks!
>
> -- 
> Caia
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20110512/c97fdb42/attachment.html>