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: [email protected] [mailto:[email protected]] On Behalf Of Justin Clark-Casey Sent: 25 January 2011 00:03 To: [email protected] 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 <[email protected] <mailto:[email protected]>> 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 > [email protected] <mailto:[email protected]> > https://lists.berlios.de/mailman/listinfo/opensim-users > > > > > _______________________________________________ > Opensim-users mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users -- Justin Clark-Casey (justincc) http://justincc.org/blog http://twitter.com/justincc _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
