aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2015-03-044-8/+4
| | | | operation is very expensive
* One more migration fixCinder2015-03-042-2/+2
| | | | Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Chase latest change to asset description length with an update to ↵Cinder2015-03-042-2/+18
| | | | | | XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Revert "Chase latest change to asset description length with an update to ↵BlueWall2015-03-042-18/+2
| | | | | | XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
* Chase latest change to asset description length with an update to ↵Cinder2015-03-042-2/+18
| | | | | | XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Follow up to last commit, fix field lengthCinder2015-03-032-0/+7
| | | | Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Use ToString() on uuids returned in ↵Justin Clark-Casey (justincc)2015-01-141-5/+5
| | | | | | PGSQLUserProfilesData.GetUserImageAssets(). These are Guids rather than strings so casting to string generates a casting exception. Relates to http://opensimulator.org/mantis/view.php?id=7398
* Fix PGSQLUserProfilesData.GetUserPreferences error when no usersettings yet ↵Justin Clark-Casey (justincc)2015-01-131-0/+1
| | | | | | exist by inserting missing ID parameter. Relates to http://opensimulator.org/mantis/view.php?id=7398
* Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | PGSQLUserProfilesData.UpdateAvatarProperties()" This reverts commit fdecf4f610fc42205cb77c1cfa51f3e3d61cfdc9.
* Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | PGSQLUserProfilesData.UpdateAvatarInterests()" This reverts commit f31feef6c16cd79772e32b57a54f5cb6924a4df3.
* Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | PGSQLUserProfilesData.GetUserImageAssets()" This reverts commit bd9539c2a73901f063202bb244e556e7f6927bae.
* Revert "Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-2/+2
| | | | | | PGSQLUserProfilesData.GetUserAppData()" This reverts commit 0794a403783208fa1e137b624317f42ea65fbce7.
* Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | | | PGSQLUserProfilesData.SetUserAppData()" This reverts commit 59c0df962a9dcac896cae2ce9b908be37047825c. This is necessary to preserve the casing of column names, otherwise pgsql converts everything to lowercase. TIL, Unlike mysql, a quoted column still refers to the column itself...
* Fix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible ↵Justin Clark-Casey (justincc)2015-01-131-3/+3
| | | | | | casts. These should be left as bools, not converted to strings. Relates to http://opensimulator.org/mantis/view.php?id=7398
* Change PGSQLUserProfilesData.UpdateUserPreferences() to directly pass the ↵Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | | | | | UUID to the uuid parameter instead of its ToString() This may well be the cause behind "operator does not exist: uuid = character varying" pgsql errors. If so, the other instances will also be changed. Relates to http://opensimulator.org/mantis/view.php?id=7398
* Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly ↵Justin Clark-Casey (justincc)2015-01-132-2/+2
| | | | | | set the UserId parameter instead of the non-existing Id parameter when writing a record because none yet exists. SQLite version is already correct for this.
* Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData()Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | This may have been preventing it from working.
* Remove extraneous colon when setting TagId parameter in ↵Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | PGSQLUserProfilesData.GetUserAppData()
* Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-2/+2
| | | | PGSQLUserProfilesData.GetUserAppData()
* Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-5/+5
| | | | | | PGSQLUserProfilesData.GetUserImageAssets() This may have been preventing it from working.
* Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | | PGSQLUserProfilesData.UpdateAvatarInterests() This may have been preventing it from working. Relates to http://opensimulator.org/mantis/view.php?id=7398
* Remove quotes from column selection in ↵Justin Clark-Casey (justincc)2015-01-131-6/+6
| | | | | | PGSQLUserProfilesData.UpdateAvatarProperties() This may have been preventing it from working.
* Remove quotes from column selection in PGSQLUserProfilesData.GetAvatarNotes()Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | This may have been preventing it from working.
* Remove quotes from field selection in PGSQLUserProfilesData.GetAvatarPicks()Justin Clark-Casey (justincc)2015-01-131-1/+1
| | | | This may have been preventing it from working.
* minor: correct two exception messages in PGSQLUserProfilesData where I ↵Justin Clark-Casey (justincc)2015-01-131-2/+2
| | | | copy/pasted AgentInterestsUpdate twice
* Remove the locking in PGSQLUserProfilesData which was buggy (Lock object ↵Justin Clark-Casey (justincc)2015-01-121-30/+9
| | | | | | wasn't set!) and is unnecessary. Relates to http://opensimulator.org/mantis/view.php?id=7398
* Get PGSQL UserProfilesData to log the exception trace for debugging rather ↵Justin Clark-Casey (justincc)2015-01-091-46/+54
| | | | than just the exception message.
* Remove unmaintained MSSQL support.Justin Clark-Casey (justincc)2014-11-2833-9148/+0
| | | | | This has not been maintained for more than 2 years, is unimplemented for newer features (e.g. built-in groups) and has no core developers using it. If somebody fixes these issues then it could be reinstated.
* Fix whitespace hoping to avoid a floggingBlueWall2014-11-253-12/+12
|
* Re-work handling of email notifications settings.BlueWall2014-11-243-9/+0
|
* Fix handling of user preference updates where no email address is suppliedBlueWall2014-11-233-9/+24
|
* Add hypergrid teleporting support to user profiles picksBlueWall2014-10-272-3/+12
|
* Fix some typecasting in PgSQL Groups adapterBlueWall2014-10-161-4/+8
|
* Experimental XAssets Module PgSQL Adapter: Remove unused migration. Syntax ↵BlueWall2014-10-161-19/+0
| | | | error preventing migration from running.
* Touchup PgSQL XAssets adapterBlueWall2014-10-152-11/+28
|
* Fix over zealous chopping of text when editing (pilot error)BlueWall2014-10-151-1/+1
|
* Fix logging level to Error in exception handlersBlueWall2014-10-153-54/+54
|
* Cleanup unused codeBlueWall2014-10-151-30/+7
|
* Fix PgSQL adapter for UserProfilesBlueWall2014-10-152-178/+256
|
* Get V2 Groups working under PgSQL. Needed to re-create tables to satisy the ↵BlueWall2014-10-121-0/+107
| | | | generic handler type matching. There should be no existing data because it couldn't complete the first migration as-is.
* Make column names lower-case, change hash column type to bytea and remove ↵BlueWall2014-10-122-52/+80
| | | | old commented lines of code
* Fix some errors in PgSQL XAssets by changing some data types. Also make sql ↵BlueWall2014-10-102-21/+58
| | | | query syntax more in line with the PgSQL AssetData implementation.
* Remove database connection locking in MySQLXAssetData. This is unnecessary ↵Justin Clark-Casey (justincc)2014-08-221-186/+168
| | | | as connections aren't shared and transactions are already in place where necessary.
* Remove query locking in MySQLUserProfileData. This is not necessary as the ↵Justin Clark-Casey (justincc)2014-08-221-20/+8
| | | | connection is not shared.
* Remove some use of database connection locking from MySQLSimulationData - ↵Justin Clark-Casey (justincc)2014-08-221-318/+298
| | | | | | | | | this has not been necessary for some time as database connections are not shared. However, many locks remain since they may effectively be providing transactionality in some operations (e.g. prim updates across multiple tables). These are candidates for being replaced with proper database transactions, since this would not block unrelated operations (e.g. land save and object save) or unrelated operations on the same tables (e.g. storage of one linkset whilst another is being removed). In practice, any performance deg due to contention is probably rare and short lived as the major prim operations are performed in memory and only persisted some time afterwards.
* Remove lock in MySQLFramework. This is not necessary as the connection is ↵Justin Clark-Casey (justincc)2014-08-221-21/+12
| | | | not shared.
* Removing locking on requests in MySQLAssetData.Justin Clark-Casey (justincc)2014-08-221-161/+144
| | | | | | These locks are not necessary since the connection is taken from the underlying mysql pool and not shared. Such locking is already not done by some other parts of OpenSim.Data.MySQL. Pointed out by arribasim-dev
* Add missing parts to profiles - classified deleteBlueWall2014-07-211-7/+3
|
* Add code to GridService to check for overlapping of varregionsRobert Adams2014-07-201-2/+2
| | | | | | | | when registering a new region. Adds parameter "[GridService]SuppressVarRegionOverlapCheckOnRegistration=false" that can be turned on to suppress the error check if a simulator's database has old regions that overlap.
* fix all instances of "non-existant" to "non-existent" (spelling mistakes) ↵Michael Cerquoni2014-07-171-2/+2
| | | | thanks Ai Austin for pointing this out.