aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data
diff options
context:
space:
mode:
authorCharles Krinke2008-06-05 13:57:58 +0000
committerCharles Krinke2008-06-05 13:57:58 +0000
commitc289c2b6d48cb9f46a7573ed70705a13dda9c772 (patch)
tree140dbd721114536369c97a0a0470ec16f13efc45 /OpenSim/Data
parentMantis#1451. Thank you kindly, Mikem for a patch that addresses: (diff)
downloadopensim-SC_OLD-c289c2b6d48cb9f46a7573ed70705a13dda9c772.zip
opensim-SC_OLD-c289c2b6d48cb9f46a7573ed70705a13dda9c772.tar.gz
opensim-SC_OLD-c289c2b6d48cb9f46a7573ed70705a13dda9c772.tar.bz2
opensim-SC_OLD-c289c2b6d48cb9f46a7573ed70705a13dda9c772.tar.xz
Mantis#1450. Thank you kindly, Boscata for a patch that addresses:
I have detected a bug of conversion data type in OpenSim.Data.MSSQL.MSSQLInventoryData.addInventoryItem(InventoryItemBase item) in the GroupOwned field. My sollution is to change the flield to bit in the table. In the readInventoryItem(IDataReader reader) change too item.Flags = (uint) reader["flags"]; to item.Flags = Convert.ToUInt32(reader["flags"]); Now Inventory runs fine.
Diffstat (limited to 'OpenSim/Data')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLInventoryData.cs2
-rw-r--r--OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql3
2 files changed, 3 insertions, 2 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLInventoryData.cs b/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
index 0c1c3f1..128fb8f 100644
--- a/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLInventoryData.cs
@@ -317,7 +317,7 @@ namespace OpenSim.Data.MSSQL
317 item.CreationDate = (int) reader["creationDate"]; 317 item.CreationDate = (int) reader["creationDate"];
318 item.GroupID = new LLUUID(reader["groupID"].ToString()); 318 item.GroupID = new LLUUID(reader["groupID"].ToString());
319 item.GroupOwned = Convert.ToBoolean(reader["groupOwned"]); 319 item.GroupOwned = Convert.ToBoolean(reader["groupOwned"]);
320 item.Flags = (uint) reader["flags"]; 320 item.Flags = Convert.ToUInt32(reader["flags"]);
321 321
322 return item; 322 return item;
323 } 323 }
diff --git a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
index 6f6bb43..7a76d47 100644
--- a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
+++ b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
@@ -22,7 +22,7 @@ CREATE TABLE [inventoryitems] (
22 [saleType] [tinyint] default NULL, 22 [saleType] [tinyint] default NULL,
23 [creationDate] [int] default NULL, 23 [creationDate] [int] default NULL,
24 [groupID] [varchar](36) default NULL, 24 [groupID] [varchar](36) default NULL,
25 [groupOwned] [tinyint] default NULL, 25 [groupOwned] [bit] default NULL,
26 [flags] [int] unsigned default NULL, 26 [flags] [int] unsigned default NULL,
27 PRIMARY KEY CLUSTERED 27 PRIMARY KEY CLUSTERED
28( 28(
@@ -43,3 +43,4 @@ CREATE NONCLUSTERED INDEX [folder] ON [inventoryitems]
43 43
44SET ANSI_PADDING OFF 44SET ANSI_PADDING OFF
45 45
46