[Opensim-users] Database issues after server crash

[Ben Faust]

  Importing objects such as chairs and other things meant for sitting. 
Even the scripts often don't work correctly. If they don't have scripts 
(and no scripts are desired), then all the individual prims would need 
to be rotated, resized, re-textured, IF that would even work; however, 
on a default-sized box, the avatar sits sideways and in the ground, not 
on any side of the box. I was hoping there was a setting in the server 
itself so sitting works in a reasonable way for everyone.

On 9/6/2010 1:11 AM, Chris wrote:
> You could try putting a script in said prim and fiddle with the 
> llSitTarget function ( llSitTarget(<0.0, 0.0, 0.5>, ZERO_ROTATION); 
> for instance) I don't know if this will accomplish what you are trying 
> to do though. Just curious, what does it have to do with importing 
> objects?
>
> On 9/5/2010 11:20 PM, Ben Faust wrote:
>>  Please disregard this. I discovered the database files had simply 
>> become corrupted, and I had to delete them physically (from the 
>> server files) and start over. Another question though: does anyone 
>> know how to change the sit settings so they line up with Second Life 
>> or even OSgrid? I can't just create a box and sit on it, but sit low 
>> and sideways, and not even on the box at any rotation. This makes 
>> importing objects from elsewhere nearly impossible in some cases.
>>
>> On 9/5/2010 3:21 PM, Ben Faust wrote:
>>>  My server crashed (ran out of disk space), and it took awhile to 
>>> figure out how to get innoDB running again with MySQL... The 
>>> database appears to be in tact, except the `migrations` table is 
>>> missing... Now, when trying to start OpenSim, the following is part 
>>> of the startup logs. Anyone know how to fix this, or perhaps have 
>>> the mysql for recreating that table?
>>>
>>> Exception: System.Exception: Table 'migrations' already exists in 
>>> SQL: create table migrations(name varchar(100), version int)
>>>   at OpenSim.Data.Migration.ExecuteScript 
>>> (System.Data.Common.DbConnection conn, System.String[] script) 
>>> [0x00000] in <filename unknown>:0
>>>   at OpenSim.Data.Migration.ExecuteScript 
>>> (System.Data.Common.DbConnection conn, System.String sql) [0x00000] 
>>> in <filename unknown>:0
>>>   at OpenSim.Data.Migration.ExecuteScript (System.String sql) 
>>> [0x00000] in <filename unknown>:0
>>>   at OpenSim.Data.Migration.InitMigrationsTable () [0x00000] in 
>>> <filename unknown>:0
>>>   at OpenSim.Data.Migration.Update () [0x00000] in <filename unknown>:0
>>>   at OpenSim.Data.MySQL.MySQLEstateStore.Initialise (System.String 
>>> connectionString) [0x00000] in <filename unknown>:0
>>>   at OpenSim.Region.Framework.StorageManager..ctor (System.String 
>>> dllName, System.String connectionstring, System.String 
>>> estateconnectionstring) [0x00000] in <filename unknown>:0
>>>   at OpenSim.OpenSimBase.CreateStorageManager (System.String 
>>> connectionstring, System.String estateconnectionstring) [0x00000] in 
>>> <filename unknown>:0
>>>   at OpenSim.OpenSimBase.CreateStorageManager () [0x00000] in 
>>> <filename unknown>:0
>>>   at 
>>> OpenSim.Region.ClientStack.RegionApplicationBase.StartupSpecific () 
>>> [0x00000] in <filename unknown>:0
>>>   at OpenSim.OpenSimBase.StartupSpecific () [0x00000] in <filename 
>>> unknown>:0
>>>   at OpenSim.OpenSim.StartupSpecific () [0x00000] in <filename 
>>> unknown>:0
>>>   at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () 
>>> [0x00000] in <filename unknown>:0
>>>   at OpenSim.Application.Main (System.String[] args) [0x00000] in 
>>> <filename unknown>:0
>>>
>>>
>>
>> _______________________________________________
>> Opensim-users mailing list
>> 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
>