Hmmm.... After a little bit of diggin it looks like you drop database in SQLite by deleting the .db file.
So in theory, if I re-download the 0.6.9 version, put it in a clean directory and delete the .db files it should create a fresh install? (Though for the life of me I can't figure out HOW it can find previous corrupted files from *somewhere* when I have deleted the entire directory!) Anyways, I'll try this later on to see what happens. On Thu, Sep 23, 2010 at 4:29 AM, bodzette Coignet <[email protected] > wrote: > 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
