[Opensim-users] OpenSim threw an exception

[Justin Clark-Casey]

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-tp5941095p5956073.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