Unfortunately, SQLite is broken on a mac post 0.6.9 because of a crypto library incompatibility with mac.
I'd suggest dumping the database and setting it up on a mySQL server temporarily. It's been broken like this for about 4 months. Regards Teravus On Wed, Sep 22, 2010 at 11:28 PM, bodzette Coignet <[email protected]> wrote: > Hi, on my mac I have somehow corrupted the db's when upgrading from 0.6.9 to > 0.7. > The problem now is it's irrevocably corrupted. Even if I drop the directory > and copy fresh files down from the open simulator site and run the install > again it somehow finds corruption from previous installs and chokes out. > I think there is a duplicate entry somewhere and I can't get rid of it. > Is there any way to either: uninstall sqlite and all sqlite databases > OR > force a clean install of 0.7? > FYI here are the errors I get: > 21:24:47 - [APPLICATION]: > APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs > Exception: System.Exception: There was a SQL error or connection string > configuration error when saving the region settings. This could be a bug, > it could also happen if ConnectionString is defined in the [DatabaseService] > section of StandaloneCommon.ini in the config_include folder. This could > also happen if the config_include folder doesn't exist or if the OpenSim.ini > [Architecture] section isn't set. If this is your first time running > OpenSimulator, please restart the simulator and bug a developer to fix this! > ---> Mono.Data.Sqlite.SqliteException: Abort due to constraint violation > column regionUUID is not unique > at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) > [0x00000] in <filename unknown>:0 > at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) > [0x00000] in <filename unknown>:0 > at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in <filename > unknown>:0 > at (wrapper remoting-invoke-with-check) > Mono.Data.Sqlite.SqliteDataReader:NextResult () > at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand > cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0 > at (wrapper remoting-invoke-with-check) > Mono.Data.Sqlite.SqliteDataReader:.ctor > (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior) > at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior) > [0x00000] in <filename unknown>:0 > at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior > behavior) [0x00000] in <filename unknown>:0 > at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior) > [0x00000] in <filename unknown>:0 > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader > (CommandBehavior behavior) [0x00000] in <filename unknown>:0 > at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[] > dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in > <filename unknown>:0 > --- End of inner exception stack trace --- > at OpenSim.Data.SQLite.SQLiteRegionData.Commit () [0x00000] in <filename > unknown>:0 > at OpenSim.Data.SQLite.SQLiteRegionData.StoreRegionSettings > (OpenSim.Framework.RegionSettings rs) [0x00000] in <filename unknown>:0 > at OpenSim.Data.SQLite.SQLiteRegionData.LoadRegionSettings (UUID > regionUUID) [0x00000] in <filename unknown>:0 > at OpenSim.Region.Framework.Scenes.Scene..ctor > (OpenSim.Framework.RegionInfo regInfo, OpenSim.Framework.AgentCircuitManager > authen, OpenSim.Region.Framework.Scenes.SceneCommunicationService > sceneGridService, OpenSim.Region.Framework.StorageManager storeManager, > OpenSim.Region.Framework.ModuleLoader moduleLoader, Boolean > dumpAssetsToFile, Boolean physicalPrim, Boolean SeeIntoRegionFromNeighbor, > IConfigSource config, System.String simulatorVersion) [0x00000] in <filename > unknown>:0 > at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo > regionInfo, OpenSim.Region.Framework.StorageManager storageManager, > OpenSim.Framework.AgentCircuitManager circuitManager) [0x00000] in <filename > unknown>:0 > at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo > regionInfo, Int32 proxyOffset, IConfigSource configSource, > IClientNetworkServer& clientServer) [0x00000] in <filename unknown>:0 > at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo > regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene) > [0x00000] in <filename unknown>:0 > at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo > regionInfo, Boolean portadd_flag, IScene& scene) [0x00000] in <filename > unknown>:0 > at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise > () [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 > InnerException: Mono.Data.Sqlite.SqliteException: Abort due to constraint > violation > column regionUUID is not unique > at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) > [0x00000] in <filename unknown>:0 > at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) > [0x00000] in <filename unknown>:0 > at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in <filename > unknown>:0 > at (wrapper remoting-invoke-with-check) > Mono.Data.Sqlite.SqliteDataReader:NextResult () > at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand > cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0 > at (wrapper remoting-invoke-with-check) > Mono.Data.Sqlite.SqliteDataReader:.ctor > (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior) > at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior) > [0x00000] in <filename unknown>:0 > at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior > behavior) [0x00000] in <filename unknown>:0 > at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior) > [0x00000] in <filename unknown>:0 > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader > (CommandBehavior behavior) [0x00000] in <filename unknown>:0 > at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[] > dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in > <filename unknown>:0 > Application is terminating: True > > _______________________________________________ > 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
