<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
p.MsoNoSpacing, li.MsoNoSpacing, div.MsoNoSpacing
{mso-style-priority:1;
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EL link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US>Hi all!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>A couple of days ago I posted an email to the opensim users mailing list about a problem I had each time I turned an object into physical. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>In short, the error was:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>2011-02-21 04:23:44,802 DEBUG - OpenSim.Region.Framework.Scenes.SceneObjectGroup [SCENE]: Storing Wooden Crate, 0a0b9dfa-ca2e-44cb-bdad-89f6b4cd84e8 in Fokides 5<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>2011-02-21 04:23:44,805 ERROR - OpenSim.Data.MySQL.MySQLDataStore [REGION DB]: MySQL error in ExecuteNonQuery: Unknown column 'NaN' in 'field list'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>2011-02-21 04:23:44,807 ERROR - OpenSim.Region.Framework.Scenes.SceneObjectGroup [SCENE]: Storing of Wooden Crate, 0a0b9dfa-ca2e-44cb-bdad-89f6b4cd84e8 in Fokides 5 failed with exception MySql.Data.MySqlClient.MySqlException: Unknown column 'NaN' in 'field list'<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Since it couldn’t be saved in the database, every physical object simply disappeared from my sim after restarting the server.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>Teravus kindly replied making a couple of suggestions that unfortunately couldn’t fix the problem.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>The only thing that I’ve noticed is that in the SW region and in the region directly above. Physical prims were always working OK.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>So I decided to uninstall MySQL, delete the database, delete diva-r13981 folder and start from scratch an empty 4X4 regions totally flat estate which looks like this: <o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>4 8 12 16<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>3 7 11 15<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>2 6 10 14 <o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>1 5 9 13<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>The coordinates I’m using are:<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8100,8100<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8100,8101<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8100,8102<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8100,8103<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8101,8100<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8101,8101<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8101,8102<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8101,8103<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8102,8100<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8102,8101<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8102,8102<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8102,8103<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8103,8100<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8103,8101<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8103,8102<o:p></o:p></span></p><p class=MsoNoSpacing><span lang=EN-US>8103,8103<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>In each region I rezzed a simple cube (16 in total) and the only attributes I changed in each one was to tick: <o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>everyone can move<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>everyone can copy<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>show in search<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>physical<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Nothing more and no scripts. I also didn’t move them from their initial position.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>I checked the table prims in MySQL and all 16 prims were saved there.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>I used the quit command to shutdown the server.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Rechecked the table prims in MySQL and all 16 prims were saved.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Restarted the server and 6 out of 16 prims were missing.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Re-rezzed the missing ones and a couple of simple non physical cubes close to them. NaN problems started and not all could be saved to the database after a shutdown.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Restarted the server, 6 out of 16 were left.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Restarted once more, only 2 were left (in regions 1 and 2).<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Re-rezzed all 16 plus 16 non physical and as you might guess, after a restart, some were missing once again…<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>Tried MySQL 5.1.5.0 64bit, 5.1.5.0 32bit, 5.1.5.4 64bit each time with the same results.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>At this point I gave up hope in solving the problem.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>Opensim version: Diva r13981 <o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>OS: Win7 64bit.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Viewer: Imprudence 1.3.0 (Oct 7 2010 02:31:57)<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>The only changes that I made in Diva (besides myworld.ini and regionconfig.ini) are in opensim.ini where <o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>I enabled clouds<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>I enabled freeswitch (but that’s another story)<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Added the lines meshing=meshmerizer<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Usemeshiesphysics=true<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>Since I don’t know if I can post attachments, I’m uploading the OpenSim.32BitLaunch.log and an Excel file that contains the prims table of MySQL in the various states of restart and shutdown in the following address:<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><a href="http://www.rhodes.aegean.gr/ptde/personel/fokides/helpme.htm">http://www.rhodes.aegean.gr/ptde/personel/fokides/helpme.htm</a><o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>I don’t know if I’m doing something completely stupid which results in this problem, or if it’s a bug.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>So, any help will be much appreciated…<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>Regards<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Manos<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US> <o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></body></html>