aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Massive tab and trailing space cleanupMelanie Thielker2017-01-051-6/+6
|
* PGSQL migrations for IM_Store, UserProfiles, removal of casting exception ↵Geir Nøklebye2015-07-311-1/+1
| | | | | | | | | | | | for UserProfiles and adding double precision to PGSQL Manager PGSQL migrations for IM_Store, UserProfiles, removal of casting exception for UserProfiles and adding double precision to PGSQL Manager. Fixes the Offline IM to Email toggle and prepares for fixing Offline IM. Signed-off-by: Oren Hurvitz <orenh@kitely.com>
* Thanks Gavin Hird for a fix for Mantis 0007604: DeleteClassifiedRecord ↵dahlia2015-06-241-123/+124
| | | | exception PGSQL
* Change UserProfiles so that the parcel name is used for a ProfilePick and ↵AliciaRaven2015-04-121-2/+2
| | | | | | not the parcel owners name. This change also fixes a bug where if the avatar enters and does not move, creating or editing a ProfilePick would set the parcelId as an empty UUID. This is because ScenePresence.currentParcelUUID is not set until the avatar moves. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.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-131-1/+1
| | | | | | 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.
* Fix whitespace hoping to avoid a floggingBlueWall2014-11-251-4/+4
|
* Re-work handling of email notifications settings.BlueWall2014-11-241-3/+0
|
* Fix handling of user preference updates where no email address is suppliedBlueWall2014-11-231-3/+8
|
* Fix over zealous chopping of text when editing (pilot error)BlueWall2014-10-151-1/+1
|
* Fix logging level to Error in exception handlersBlueWall2014-10-151-18/+18
|
* Cleanup unused codeBlueWall2014-10-151-30/+7
|
* Fix PgSQL adapter for UserProfilesBlueWall2014-10-151-177/+201
|
* Add support for user preferences (im via email)BlueWall2013-12-061-15/+14
|
* Adding profile partners fix to SQLite and PgSQL driversBlueWall2013-12-051-2/+0
|
* Fernando Oliveira's Postgress SQL Server Data Connector as a single commit.Fernando Oliveira2013-10-121-0/+1075
* Added PostGreSQL support * Added MySQL/MySQLXGroupData.cs * PostgreSQL data access implementation * PostgreSQL dll binarie and RegionStore.migrations * Migrations Scripts from MSSQL to POSTGRES * Postgres SQL Type fixes * Postgres SQL Connection string * Data type issues * more fixes * tests and +tests * UUID x string - FIGHT! * Fixed PG types to internal csharp types * More data type fix (PostgreSQL fields are case sensitive) :( * more field case sensitive fixes * changed the migration files to be case sensitive for fields. * fixed fields case * finished converting, now search for hidden bugs. * some more fixes * bool type fixed * more case fixes; * creatorID case fixed * case fields fixed * fixed default now() for TMStamp fields with don't allow nulls. * fix case sensitve for Region name and Estate name * fixed case for names for search * fix class name Error * Bug fixed on select and migrations * Un-Reverting my change due to Postgres issue with the ILIKE function * Fixed some issued for Diva Distro * Fixes for integration with Diva Distro * Added System.Core to prebuild.xml for PG project * Configured to make DIff for Push to OpenSim Project * Diffs only to PostgreSQL mods.