* Added a hack-ish routine to add the State column to the primshapes table if it wasn't already there.

* Started OpenSim on SQLite to a mass of red 'unable to load prim' messages.
* If you are getting this message, after this update, when you start OpenSimulator, you'll get it one more time and then it'll work again.

1 files changed, 11 insertions, 1 deletions

diff --git a/OpenSim/Framework/Data.SQLite/SQLiteRegionData.cs b/OpenSim/Framework/Data.SQLite/SQLiteRegionData.cs
index d41dd55..b724337 100644
--- a/OpenSim/Framework/Data.SQLite/SQLiteRegionData.cs
+++ b/OpenSim/Framework/Data.SQLite/SQLiteRegionData.cs
@@ -1171,7 +1171,17 @@ namespace OpenSim.Framework.Data.SQLite
             s.ProfileEnd = Convert.ToUInt16(row["ProfileEnd"]);
             s.ProfileCurve = Convert.ToByte(row["ProfileCurve"]);
             s.ProfileHollow = Convert.ToUInt16(row["ProfileHollow"]);
-            s.State = Convert.ToByte(row["State"]);
+            try
+            {
+                s.State = Convert.ToByte(row["State"]);
+            }
+            catch (InvalidCastException)
+            {
+                m_conn.Open();
+                SqliteCommand cmd =
+                    new SqliteCommand("ALTER TABLE primshapes ADD COLUMN State Integer NOT NULL default 0;", m_conn);
+                cmd.ExecuteNonQuery();
+            }
             // text TODO: this isn't right] = but I'm not sure the right
             // way to specify this as a blob atm