[Opensim-users] Database issues after server crash

[Chris]

Oh I see... I am not sure other than using a pose script with animation 
or just simply scripting in a sit target in the prim that was meant to 
be sat on. Sorry :) But if there is such a setting in the configuration 
I would like to know as well.

On 9/6/2010 12:18 AM, Ben Faust wrote:
>  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
>>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>