aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2015-01-14Use ToString() on uuids returned in ↵Justin Clark-Casey (justincc)1-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
2015-01-13Fix PGSQLUserProfilesData.GetUserPreferences error when no usersettings yet ↵Justin Clark-Casey (justincc)1-0/+1
exist by inserting missing ID parameter. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarProperties()" This reverts commit fdecf4f610fc42205cb77c1cfa51f3e3d61cfdc9.
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarInterests()" This reverts commit f31feef6c16cd79772e32b57a54f5cb6924a4df3.
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.GetUserImageAssets()" This reverts commit bd9539c2a73901f063202bb244e556e7f6927bae.
2015-01-13Revert "Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)1-2/+2
PGSQLUserProfilesData.GetUserAppData()" This reverts commit 0794a403783208fa1e137b624317f42ea65fbce7.
2015-01-13Revert "Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-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...
2015-01-13Fix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible ↵Justin Clark-Casey (justincc)1-3/+3
casts. These should be left as bools, not converted to strings. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Change PGSQLUserProfilesData.UpdateUserPreferences() to directly pass the ↵Justin Clark-Casey (justincc)1-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
2015-01-13Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly ↵Justin Clark-Casey (justincc)2-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.
2015-01-13Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData()Justin Clark-Casey (justincc)1-5/+5
This may have been preventing it from working.
2015-01-13Remove extraneous colon when setting TagId parameter in ↵Justin Clark-Casey (justincc)1-1/+1
PGSQLUserProfilesData.GetUserAppData()
2015-01-13Remove misstaken quotes from column selection in ↵Justin Clark-Casey (justincc)1-2/+2
PGSQLUserProfilesData.GetUserAppData()
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-5/+5
PGSQLUserProfilesData.GetUserImageAssets() This may have been preventing it from working.
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarInterests() This may have been preventing it from working. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-13Remove quotes from column selection in ↵Justin Clark-Casey (justincc)1-6/+6
PGSQLUserProfilesData.UpdateAvatarProperties() This may have been preventing it from working.
2015-01-13Remove quotes from column selection in PGSQLUserProfilesData.GetAvatarNotes()Justin Clark-Casey (justincc)1-1/+1
This may have been preventing it from working.
2015-01-13Remove quotes from field selection in PGSQLUserProfilesData.GetAvatarPicks()Justin Clark-Casey (justincc)1-1/+1
This may have been preventing it from working.
2015-01-13minor: correct two exception messages in PGSQLUserProfilesData where I ↵Justin Clark-Casey (justincc)1-2/+2
copy/pasted AgentInterestsUpdate twice
2015-01-12Remove the locking in PGSQLUserProfilesData which was buggy (Lock object ↵Justin Clark-Casey (justincc)1-30/+9
wasn't set!) and is unnecessary. Relates to http://opensimulator.org/mantis/view.php?id=7398
2015-01-09Get PGSQL UserProfilesData to log the exception trace for debugging rather ↵Justin Clark-Casey (justincc)1-46/+54
than just the exception message.
2014-11-28Remove unmaintained MSSQL support.Justin Clark-Casey (justincc)33-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.
2014-11-25Fix whitespace hoping to avoid a floggingBlueWall3-12/+12
2014-11-24Re-work handling of email notifications settings.BlueWall3-9/+0
2014-11-23Fix handling of user preference updates where no email address is suppliedBlueWall3-9/+24
2014-10-27Add hypergrid teleporting support to user profiles picksBlueWall2-3/+12
2014-10-16Fix some typecasting in PgSQL Groups adapterBlueWall1-4/+8
2014-10-16Experimental XAssets Module PgSQL Adapter: Remove unused migration. Syntax ↵BlueWall1-19/+0
error preventing migration from running.
2014-10-15Touchup PgSQL XAssets adapterBlueWall2-11/+28
2014-10-15Fix over zealous chopping of text when editing (pilot error)BlueWall1-1/+1
2014-10-15Fix logging level to Error in exception handlersBlueWall3-54/+54
2014-10-15Cleanup unused codeBlueWall1-30/+7
2014-10-15Fix PgSQL adapter for UserProfilesBlueWall2-178/+256
2014-10-12Get V2 Groups working under PgSQL. Needed to re-create tables to satisy the ↵BlueWall1-0/+107
generic handler type matching. There should be no existing data because it couldn't complete the first migration as-is.
2014-10-12Make column names lower-case, change hash column type to bytea and remove ↵BlueWall2-52/+80
old commented lines of code
2014-10-10Fix some errors in PgSQL XAssets by changing some data types. Also make sql ↵BlueWall2-21/+58
query syntax more in line with the PgSQL AssetData implementation.
2014-08-22Remove database connection locking in MySQLXAssetData. This is unnecessary ↵Justin Clark-Casey (justincc)1-186/+168
as connections aren't shared and transactions are already in place where necessary.
2014-08-22Remove query locking in MySQLUserProfileData. This is not necessary as the ↵Justin Clark-Casey (justincc)1-20/+8
connection is not shared.
2014-08-22Remove some use of database connection locking from MySQLSimulationData - ↵Justin Clark-Casey (justincc)1-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.
2014-08-22Remove lock in MySQLFramework. This is not necessary as the connection is ↵Justin Clark-Casey (justincc)1-21/+12
not shared.
2014-08-22Removing locking on requests in MySQLAssetData.Justin Clark-Casey (justincc)1-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
2014-07-21Add missing parts to profiles - classified deleteBlueWall1-7/+3
2014-07-20Add code to GridService to check for overlapping of varregionsRobert Adams1-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.
2014-07-17fix all instances of "non-existant" to "non-existent" (spelling mistakes) ↵Michael Cerquoni1-2/+2
thanks Ai Austin for pointing this out.
2014-06-17Change assembly versions to 0.8.1Justin Clark-Casey (justincc)6-6/+6
2014-05-31Fix a bug where estate not found would result in a dummy estate record with ↵Diva Canto1-2/+9
erroneous information. Also, added conversion of EstateSettings from/to key-value pairs in preparation for robust net work connectors.
2014-05-30Moved these two estate-related interfaces to the projects where they belong.Diva Canto1-0/+120
2014-05-27Change Assembly verson of OpenSim.Data.PGSQL.dll to 0.8.0.* to match all ↵Justin Clark-Casey (justincc)1-1/+1
other assembly versions
2014-05-15minor: eliminate now unnecessary string.Format in postgresql RetrieveGroups ↵Justin Clark-Casey (justincc)1-1/+1
method
2014-05-15Escape find string in PgSQL core groups pluginJustin Clark-Casey (justincc)2-3/+25
generated by cgit v1.1 at 2024-08-23 23:20:43 +0000