[Opensim-users] Database issues after server crash

[Chris]

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
>