[prev in list] [next in list] [prev in thread] [next in thread] 

List:       opensim-users
Subject:    [Opensim-users] OpenSim threw an exception
From:       j_jamesk () hotmail ! com (James)
Date:       2011-01-25 0:11:48
Message-ID: SNT103-DS1357A4FFD9F8AF67B23B24E1FC0 () phx ! gbl
[Download RAW message or body]



I did see the mantis report, one thing that caught my eye was both myself
and Marauder Moe who reported the fault were both using 64bit windows,
downgrading MySQL to 5.1.54 does get around the issue which is what I have
done today. 

-----Original Message-----
From: opensim-users-bounces@lists.berlios.de
[mailto:opensim-users-bounces at lists.berlios.de] On Behalf Of Justin
Clark-Casey
Sent: 25 January 2011 00:03
To: opensim-users at lists.berlios.de
Subject: Re: [Opensim-users] OpenSim threw an exception

I just tried to reproduce this problem with MySQL 5.5.8 on the 0.7.0.2
source release and OpenSim master with WinXP 
32-bit.  In both cases everything worked okay.  More analysis (and debug
line numbers) are needed.  There is an ongoing 
mantis at

http://opensimulator.org/mantis/view.php?id=5294

for this.


On 24/01/11 18:41, Teravus Ovares wrote:
> Based on the error message, it seems that the mySQL driver was
automagically calling read previous to 5.1 and isn't
> anymore.
>
>
> Forcing the developer to call Read() is more in line with the rest of the
ADO.NET <http://ADO.NET> world.     This is
> only a 'system' bug if this is on a DataAdapter.  If that was the case
then it would be a bug in Mono's mySQL
> implementation.    If this is occurring on a DataReader, then this is an
OpenSimulator bug.   If this is a DataReader
> then OpenSimulator's mySQL Connector needs to call Read in order to get
access to the first row's data.
>
> Typically, accessing data via ADO.NET <http://ADO.NET> using a DataReader
looks like,
>
> MySqlDataReader da = cmd.ExecuteReader();
> using (da)
> {
> if (da.HasRows)
> {
>       while (da.Read())
>       {
>            // Work With Data
>       }
> }
> }
> // explicit close option
> // da.Close;
> // da.Dispose;
>
> Note how da.Read() is called once before the first row is accessed and
again for each row.    Read() returns true if
> there are more rows.   False if there are no more rows
>
> Regards
>
> Teravus
>
>
>
> On Mon, Jan 24, 2011 at 1:14 PM, DutchGlory <info at verwijs-pc.nl
<mailto:info at verwijs-pc.nl>> wrote:
>
>
>     it seems  mysql is trying to read a database field that isn't
created...
>     "Invalid attempt to access a field before calling Read()"  try to
close
>     opensim and start up again..
>     or check mysql connection strings (i think EstateStore connection
string)
>     within your configuration files...
>
>     if nothing works, switch to opensim git repository...  works great now
use
>     it every day... :)
>
>
>     -----
>
>     --
>     View this message in context:
>
http://opensim-users.2152040.n2.nabble.com/OpenSim-threw-an-exception-tp5941
095p5956073.html
>     Sent from the opensim-users mailing list archive at Nabble.com.
>     _______________________________________________
>     Opensim-users mailing list
>     Opensim-users at lists.berlios.de <mailto:Opensim-users at lists.berlios.de>
>     https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users


-- 
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc
_______________________________________________
Opensim-users mailing list
Opensim-users at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users



[prev in list] [next in list] [prev in thread] [next in thread]