aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLInventoryData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-05-19Some more corrections after MySQL connector updateAlexRa1-1/+1
2010-05-19All (?) MySQL stores fixed to use DBGuid.FromDB()AlexRa1-20/+13
This was needed if we want to update to the latest MySQL connector dll. It automatically converts CHAR(36) to Guids, so getting them as strings no longer works. By using DBGuid.FromDB(), we unlink from any particular storage format of GUIDs, could even make them BINARY(16) if we like. Actually not all MySql units are touched, but the remaining ones don't seem to be affected (they don't read GUIDs from DB)
2010-04-28Just a bit of spellchecking in the commentsAlexRa1-2/+2
2010-02-05Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim1-511/+336
This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
2010-02-05* Fixed the Cable Beach inventory server to save the CreatorID as well as ↵OpenSim Master1-2/+2
properly handling null item names and descriptions * Fixed the MySQL reader to safely handle null values in string columns that can be null
2010-02-05* Fixed the Cable Beach inventory server to save the CreatorID as well as ↵OpenSim Master1-2/+2
properly handling null item names and descriptions * Fixed the MySQL reader to safely handle null values in string columns that can be null
2010-02-06* Fixed the Cable Beach inventory server to save the CreatorID as well as ↵OpenSim Master1-2/+2
properly handling null item names and descriptions * Fixed the MySQL reader to safely handle null values in string columns that can be null
2010-01-04Formatting cleanup. Add copyright headers.Jeff Ames1-3/+3
2010-01-01Prevent the creation of duplicate inventory folders in the case of a loginMelanie1-1/+1
database issue. Now the login will instaead fail later.
2009-12-13* Implements OSSL function: osGetSimulatorMemory - returns the current ↵Adam Frisby1-0/+3
amount of memory allocated to the simulator process (Moderate Threat Level). * Cleans redundant information out of the Simulator Version. Versions now look like: "OpenSimulator 0.6.9(dev) Unix/Mono" * [Minor] additional log info for MySQLInventoryData
2009-11-23* Implements SQL Rollback support to Inventory Service for quicker backup ↵Adam Frisby1-0/+154
restoration. * Can optionally replace the OpenGridMode committed earlier. * Will create a series of incrementing restore SQL files, one per user, in folders listed per-day. * For MySql Section of InventoryService INI: rollback = "true" rollbackdir = "/absolute/path/to/rollback/storage/dir"
2009-11-23* Adds a modicum of additional checking to the Inventory Service (MySQL only)Adam Frisby1-5/+22
* Enable "opengridmode=true" in your Inventory Connector (where the mysql connection strings are) to enable if you are running a 'wide-open-grid'. * More comprehensive rollback support being implemented, should be available later today.
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman1-166/+169
the grid server after running for several hours
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman1-169/+166
Local member in MySQLAssetData * First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
2009-10-01Formatting cleanup.Jeff Ames1-6/+6
2009-08-17Add copyright headers. Formatting cleanup. Fix a compiler warning.Jeff Ames1-1/+1
2009-08-16* Fixed MySQL/MySQLAssetData.cs to properly do updates * Removed an extra ↵Kunnis1-1/+1
parameter from MySQL/MySQLInventoryData.cs * Fixed a bug in SQLite/SQLiteAssetData.cs that was causing a NRE when updating an asset. * Improved the BasicAssetTest.cs to do full create/update/get testing * Improved the BasicInventoryTest.cs to do full create/update/get of both a folder and an item * Moved the null ref tests to the start of the PropertyCompareConstraint.cs, so that it doesn't throw when passing in a null item
2009-08-16Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis1-5/+6
2009-07-24* Apply asset and inventory name and description bound checks to MySQLJustin Clarke Casey1-3/+24
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-05-08now that creatorID is no longer a strict UUID, and the column can still be NULL,Sean Dague1-1/+10
we lost protection from NULL strings. This puts some protection in for that case. This may address many of the inventory issues that are being seen intermitently.
2009-04-08* Make it possible to store creator strings in user inventory items as well ↵Justin Clarke Casey1-7/+5
as UUIDs * All existing functionality should be unaffected. * Database schemas have not been changed.
2009-03-23Committing partial work on passing folders across instances. This may crash.Melanie Thielker1-0/+5
2009-03-22MYSQL Only: Make items given while offline appear in inventory withoutMelanie Thielker1-0/+9
the need to clear cache.
2009-03-21Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker1-0/+5
MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
2009-02-12* optimized usings.lbsa711-1/+1
2008-11-14Add group permissions to agent inventory.Melanie Thielker1-2/+4
Contains a migration. May contain nuts. Please back up your inventory data store. This revision changes the interface version!! No older regions can connect to these new UGAIM, and the new regions can't connect to the old UGAIM. Fixes a long-standing issue of permissions loss Currently persisted on MySQL only.
2008-11-13make inventory item listing more robust. It turns out that a bad itemSean Dague1-8/+28
(one that won't parse right) will prevent all other items in that folder to load when inventory is requested. This is very careful to no longer add inventory items that return as null to the hash table for getInventoryInFolder, as well as be more careful parsing UUIDs for fields that aren't marked not null in MySQL. The net result, you may see previously missing inventory items return after this checkin. Folders probably need to be hardened in the same way, but I'm out of time for today.
2008-09-28Update svn properties. Minor formatting cleanup. Fix a compiler warning. ↵Jeff Ames1-2/+2
Fix a UUID vs null comparison.
2008-09-24Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz1-0/+36
Active gestures are sent as part of the login-response. Added fetchActiveGestures to SQLite and MySQL; added an empty one for MSSQL and NHibernate. Using the empty ones won't cause errors, but doesn't provide persistence either, of course.
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-27/+27
* This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
2008-08-27remove pre-Migration upgrade pathsSean Dague1-92/+0
2008-08-18Formatting cleanup.Jeff Ames1-9/+9
2008-08-12Minor formatting cleanup.Jeff Ames1-1/+1
2008-08-10Mantis#1903. Thank you kindly, CMickeyb for a patch that:Charles Krinke1-5/+108
patch attached replaces the tree walk algorithm used to build the folder hierarchy with a single database query. That is, we replace 1 database query per folder with 1 query for the root folder's properties and 1 query to retrieve the entire collection of folders for a user.
2008-07-31Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur1-7/+13
PluginLoader. Fix issue 1871.
2008-07-03Mantis#1661. Thank you kindly, CMickeyb for a patch that:Charles Krinke1-0/+24
patch attached to check for timeouts on mysql connections *before* operations occur that are likely to timeout. if timeout occurs or the connections is down, it is reconnected before the operation fails.
2008-06-26Apply patch from bug #1601 -- more documentation for Data/MySQL. Thanks ↵Jeff Ames1-17/+40
kerunix_Flan!
2008-06-26Add patch from bug #1596 - adds Doxygen documentation in OpenSim.Data.MySQL ↵Jeff Ames1-2/+29
files. Thanks kerunix_Flan!
2008-06-13Update svn properties, clean up formatting, refactor out duplicate ↵Jeff Ames1-1/+1
hard-coded port numbers.
2008-06-12Fix mysql migrations. This is tested with an existing up to date schema,Sean Dague1-1/+1
and no schema. It should also work with a non up to date schema as well. Btw, meetings in which I can get code done are the right kind of meetings.
2008-06-12this, in theory, adds migration support to mysql for all Sean Dague1-4/+30
data sources besides the grid store. It is only lightly tested so the less adventurous should wait a couple of checkins before upgrading.
2008-05-30Update svn properties. Formatting cleanup.Jeff Ames1-1/+1
2008-05-28actually user the database_connect string for mysql. Sean Dague1-20/+19
This means you can run all the OpenSim grid services without needing a mysql_connection.ini
2008-05-16Formatting cleanup.Jeff Ames1-12/+12
2008-05-06De-tabify source.Jeff Ames1-1/+1
2008-05-01* Refactor: Remove the unused userID parameter that was being passed into ↵Justin Clarke Casey1-56/+7
almost every inventory method * This allows lots of redundant inventory methods with only slightly different names to be eliminated.
2008-05-01* In ur code. Making it static.Adam Frisby1-2/+2
* Converted a bunch of functions to static functions.
2008-05-01* Add more class cast exceptions to mysql read inventory item to cover all ↵Justin Clarke Casey1-3/+26
new fields - not just those I think are initially failing. * This is more likely to allow existing mysql databases to work temporarily, if the previous revision doesn't work
2008-05-01* Insert temporary cast exception catching code to deal with mantis 1099 - ↵Justin Clarke Casey1-3/+29
mysql inventoryitems table problem