Hmmm.... After a little bit of diggin it looks like you drop database in SQLite by deleting the .db file.<br><br>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?<br>
<br>(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!)<br><br>Anyways, I'll try this later on to see what happens.<br>
<br><div class="gmail_quote">On Thu, Sep 23, 2010 at 4:29 AM, bodzette Coignet <span dir="ltr"><<a href="mailto:bodzettecoignet@gmail.com">bodzettecoignet@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Thanks,<br><br>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.<br><br>Any ideas how to completely remove an SQLite installation so I can start fresh?<div>
<div></div><div class="h5"><br>
<br><div class="gmail_quote">On Wed, Sep 22, 2010 at 10:33 PM, Teravus Ovares <span dir="ltr"><<a href="mailto:teravus@gmail.com" target="_blank">teravus@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Unfortunately, SQLite is broken on a mac post 0.6.9 because of a<br>
crypto library incompatibility with mac.<br>
<br>
I'd suggest dumping the database and setting it up on a mySQL server<br>
temporarily. It's been broken like this for about 4 months.<br>
<br>
Regards<br>
<br>
Teravus<br>
<div><div></div><div><br>
On Wed, Sep 22, 2010 at 11:28 PM, bodzette Coignet<br>
<<a href="mailto:bodzettecoignet@gmail.com" target="_blank">bodzettecoignet@gmail.com</a>> wrote:<br>
> Hi, on my mac I have somehow corrupted the db's when upgrading from 0.6.9 to<br>
> 0.7.<br>
> The problem now is it's irrevocably corrupted. Even if I drop the directory<br>
> and copy fresh files down from the open simulator site and run the install<br>
> again it somehow finds corruption from previous installs and chokes out.<br>
> I think there is a duplicate entry somewhere and I can't get rid of it.<br>
> Is there any way to either: uninstall sqlite and all sqlite databases<br>
> OR<br>
> force a clean install of 0.7?<br>
> FYI here are the errors I get:<br>
> 21:24:47 - [APPLICATION]:<br>
> APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs<br>
> Exception: System.Exception: There was a SQL error or connection string<br>
> configuration error when saving the region settings. This could be a bug,<br>
> it could also happen if ConnectionString is defined in the [DatabaseService]<br>
> section of StandaloneCommon.ini in the config_include folder. This could<br>
> also happen if the config_include folder doesn't exist or if the OpenSim.ini<br>
> [Architecture] section isn't set. If this is your first time running<br>
> OpenSimulator, please restart the simulator and bug a developer to fix this!<br>
> ---> Mono.Data.Sqlite.SqliteException: Abort due to constraint violation<br>
> column regionUUID is not unique<br>
> at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt)<br>
> [0x00000] in <filename unknown>:0<br>
> at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt)<br>
> [0x00000] in <filename unknown>:0<br>
> at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in <filename<br>
> unknown>:0<br>
> at (wrapper remoting-invoke-with-check)<br>
> Mono.Data.Sqlite.SqliteDataReader:NextResult ()<br>
> at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand<br>
> cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0<br>
> at (wrapper remoting-invoke-with-check)<br>
> Mono.Data.Sqlite.SqliteDataReader:.ctor<br>
> (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)<br>
> at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior)<br>
> [0x00000] in <filename unknown>:0<br>
> at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior<br>
> behavior) [0x00000] in <filename unknown>:0<br>
> at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior)<br>
> [0x00000] in <filename unknown>:0<br>
> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader<br>
> (CommandBehavior behavior) [0x00000] in <filename unknown>:0<br>
> at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[]<br>
> dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in<br>
> <filename unknown>:0<br>
> --- End of inner exception stack trace ---<br>
> at OpenSim.Data.SQLite.SQLiteRegionData.Commit () [0x00000] in <filename<br>
> unknown>:0<br>
> at OpenSim.Data.SQLite.SQLiteRegionData.StoreRegionSettings<br>
> (OpenSim.Framework.RegionSettings rs) [0x00000] in <filename unknown>:0<br>
> at OpenSim.Data.SQLite.SQLiteRegionData.LoadRegionSettings (UUID<br>
> regionUUID) [0x00000] in <filename unknown>:0<br>
> at OpenSim.Region.Framework.Scenes.Scene..ctor<br>
> (OpenSim.Framework.RegionInfo regInfo, OpenSim.Framework.AgentCircuitManager<br>
> authen, OpenSim.Region.Framework.Scenes.SceneCommunicationService<br>
> sceneGridService, OpenSim.Region.Framework.StorageManager storeManager,<br>
> OpenSim.Region.Framework.ModuleLoader moduleLoader, Boolean<br>
> dumpAssetsToFile, Boolean physicalPrim, Boolean SeeIntoRegionFromNeighbor,<br>
> IConfigSource config, System.String simulatorVersion) [0x00000] in <filename<br>
> unknown>:0<br>
> at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo<br>
> regionInfo, OpenSim.Region.Framework.StorageManager storageManager,<br>
> OpenSim.Framework.AgentCircuitManager circuitManager) [0x00000] in <filename<br>
> unknown>:0<br>
> at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo<br>
> regionInfo, Int32 proxyOffset, IConfigSource configSource,<br>
> IClientNetworkServer& clientServer) [0x00000] in <filename unknown>:0<br>
> at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo<br>
> regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene)<br>
> [0x00000] in <filename unknown>:0<br>
> at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo<br>
> regionInfo, Boolean portadd_flag, IScene& scene) [0x00000] in <filename<br>
> unknown>:0<br>
> at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise<br>
> () [0x00000] in <filename unknown>:0<br>
> at OpenSim.OpenSimBase.StartupSpecific () [0x00000] in <filename<br>
> unknown>:0<br>
> at OpenSim.OpenSim.StartupSpecific () [0x00000] in <filename unknown>:0<br>
> at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000] in<br>
> <filename unknown>:0<br>
> at OpenSim.Application.Main (System.String[] args) [0x00000] in <filename<br>
> unknown>:0<br>
> InnerException: Mono.Data.Sqlite.SqliteException: Abort due to constraint<br>
> violation<br>
> column regionUUID is not unique<br>
> at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt)<br>
> [0x00000] in <filename unknown>:0<br>
> at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt)<br>
> [0x00000] in <filename unknown>:0<br>
> at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in <filename<br>
> unknown>:0<br>
> at (wrapper remoting-invoke-with-check)<br>
> Mono.Data.Sqlite.SqliteDataReader:NextResult ()<br>
> at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand<br>
> cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0<br>
> at (wrapper remoting-invoke-with-check)<br>
> Mono.Data.Sqlite.SqliteDataReader:.ctor<br>
> (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)<br>
> at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior)<br>
> [0x00000] in <filename unknown>:0<br>
> at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior<br>
> behavior) [0x00000] in <filename unknown>:0<br>
> at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior)<br>
> [0x00000] in <filename unknown>:0<br>
> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader<br>
> (CommandBehavior behavior) [0x00000] in <filename unknown>:0<br>
> at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[]<br>
> dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in<br>
> <filename unknown>:0<br>
> Application is terminating: True<br>
><br>
</div></div>> _______________________________________________<br>
> Opensim-users mailing list<br>
> <a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
> <a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
><br>
><br>
_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@lists.berlios.de" target="_blank">Opensim-users@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br>
</blockquote></div><br>
</div></div></blockquote></div><br>