Hi, on my mac I have somehow corrupted the db's when upgrading from 0.6.9 to 0.7.<div>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.</div>
<div>I think there is a duplicate entry somewhere and I can't get rid of it.</div><div><br></div><div>Is there any way to either: uninstall sqlite and all sqlite databases</div><div>OR</div><div>force a clean install of 0.7?</div>
<div><br></div><div>FYI here are the errors I get:</div><div><div>21:24:47 - [APPLICATION]: </div><div>APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs</div><div><br></div><div>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</div>
<div>column regionUUID is not unique</div><div> at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00000] in <filename unknown>:0 </div><div> at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x00000] in <filename unknown>:0 </div>
<div> at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in <filename unknown>:0 </div><div> at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader:NextResult ()</div><div> at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0 </div>
<div> at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader:.ctor (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)</div><div> at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 </div>
<div> at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 </div><div> at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 </div>
<div> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 </div><div> at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[] dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in <filename unknown>:0 </div>
<div> --- End of inner exception stack trace ---</div><div> at OpenSim.Data.SQLite.SQLiteRegionData.Commit () [0x00000] in <filename unknown>:0 </div><div> at OpenSim.Data.SQLite.SQLiteRegionData.StoreRegionSettings (OpenSim.Framework.RegionSettings rs) [0x00000] in <filename unknown>:0 </div>
<div> at OpenSim.Data.SQLite.SQLiteRegionData.LoadRegionSettings (UUID regionUUID) [0x00000] in <filename unknown>:0 </div><div> 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 </div>
<div> at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo regionInfo, OpenSim.Region.Framework.StorageManager storageManager, OpenSim.Framework.AgentCircuitManager circuitManager) [0x00000] in <filename unknown>:0 </div>
<div> at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo regionInfo, Int32 proxyOffset, IConfigSource configSource, IClientNetworkServer& clientServer) [0x00000] in <filename unknown>:0 </div><div>
at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene) [0x00000] in <filename unknown>:0 </div><div> at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, IScene& scene) [0x00000] in <filename unknown>:0 </div>
<div> at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise () [0x00000] in <filename unknown>:0 </div><div> at OpenSim.OpenSimBase.StartupSpecific () [0x00000] in <filename unknown>:0 </div>
<div> at OpenSim.OpenSim.StartupSpecific () [0x00000] in <filename unknown>:0 </div><div> at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000] in <filename unknown>:0 </div><div> at OpenSim.Application.Main (System.String[] args) [0x00000] in <filename unknown>:0 </div>
<div>InnerException: Mono.Data.Sqlite.SqliteException: Abort due to constraint violation</div><div>column regionUUID is not unique</div><div> at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00000] in <filename unknown>:0 </div>
<div> at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x00000] in <filename unknown>:0 </div><div> at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in <filename unknown>:0 </div>
<div> at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader:NextResult ()</div><div> at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0 </div>
<div> at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader:.ctor (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)</div><div> at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 </div>
<div> at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 </div><div> at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 </div>
<div> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 </div><div> at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[] dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in <filename unknown>:0 </div>
<div><br></div><div>Application is terminating: True</div></div><div><br></div>