Hi Thanks, Unfortunately I tried that already - just changing to a MySQL database just copies the duplicated rows across to MySQL and the boot up still fails.
Any ideas how to completely remove an SQLite installation so I can start fresh? On Wed, Sep 22, 2010 at 10:33 PM, Teravus Ovares <[email protected]> wrote: > 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 >
_______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
