lotek/opensim
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
33,374 Commits 5 Branches 12,734 Tags
master
Commit Graph

37 Commits

Author SHA1 Message Date
UbitUmarov
b02c65280e remove wrong uuid null tests 2022-10-02 12:10:41 +01:00
UbitUmarov
fa78a6fd90 fix some odd sql queries ap not in use 2018-01-12 18:07:37 +00:00
Melanie Thielker
b16abc8166 Massive tab and trailing space cleanup 2017-01-05 19:07:37 +00:00
Geir Nøklebye
1de8c3570d PGSQL migrations for IM_Store, UserProfiles, removal of casting exception 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>
 2015-07-31 15:57:22 +01:00
dahlia
3aa9e786de Thanks Gavin Hird for a fix for Mantis 0007604: DeleteClassifiedRecord exception PGSQL 2015-06-24 04:08:34 -07:00
AliciaRaven
1e444b1449 Change UserProfiles so that the parcel name is used for a ProfilePick and 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>
 2015-04-12 15:36:22 -04:00
Justin Clark-Casey (justincc)
9363d4c784 Use ToString() on uuids returned in 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-14 00:00:02 +00:00
Justin Clark-Casey (justincc)
02f2352ad5 Fix PGSQLUserProfilesData.GetUserPreferences error when no usersettings yet exist by inserting missing ID parameter. 
Relates to http://opensimulator.org/mantis/view.php?id=7398
 2015-01-13 23:52:52 +00:00
Justin Clark-Casey (justincc)
71d73777d9 Revert "Remove quotes from column selection in PGSQLUserProfilesData.UpdateAvatarProperties()" 
This reverts commit fdecf4f610.
 2015-01-13 21:53:28 +00:00
Justin Clark-Casey (justincc)
8f37a61912 Revert "Remove quotes from column selection in PGSQLUserProfilesData.UpdateAvatarInterests()" 
This reverts commit f31feef6c1.
 2015-01-13 21:53:18 +00:00
Justin Clark-Casey (justincc)
39989eda3b Revert "Remove quotes from column selection in PGSQLUserProfilesData.GetUserImageAssets()" 
This reverts commit bd9539c2a7.
 2015-01-13 21:53:04 +00:00
Justin Clark-Casey (justincc)
38f2b89248 Revert "Remove misstaken quotes from column selection in PGSQLUserProfilesData.GetUserAppData()" 
This reverts commit 0794a40378.
 2015-01-13 21:52:43 +00:00
Justin Clark-Casey (justincc)
f9d2121bcf Revert "Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData()" 
This reverts commit 59c0df962a.
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-13 21:50:11 +00:00
Justin Clark-Casey (justincc)
24695dc05b Fix PGSQLUserProfilesData.UpdateUserPreferences() imviaemail and visible casts. These should be left as bools, not converted to strings. 
Relates to http://opensimulator.org/mantis/view.php?id=7398
 2015-01-13 21:40:49 +00:00
Justin Clark-Casey (justincc)
46e8a99526 Change PGSQLUserProfilesData.UpdateUserPreferences() to directly pass the 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-13 21:13:57 +00:00
Justin Clark-Casey (justincc)
492d49eb08 Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to correctly 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-13 20:33:36 +00:00
Justin Clark-Casey (justincc)
59c0df962a Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData() 
This may have been preventing it from working.
 2015-01-13 20:27:37 +00:00
Justin Clark-Casey (justincc)
55ae9a7d10 Remove extraneous colon when setting TagId parameter in PGSQLUserProfilesData.GetUserAppData() 2015-01-13 20:15:37 +00:00
Justin Clark-Casey (justincc)
0794a40378 Remove misstaken quotes from column selection in PGSQLUserProfilesData.GetUserAppData() 2015-01-13 19:20:27 +00:00
Justin Clark-Casey (justincc)
bd9539c2a7 Remove quotes from column selection in PGSQLUserProfilesData.GetUserImageAssets() 
This may have been preventing it from working.
 2015-01-13 18:57:32 +00:00
Justin Clark-Casey (justincc)
f31feef6c1 Remove quotes from column selection in PGSQLUserProfilesData.UpdateAvatarInterests() 
This may have been preventing it from working.
Relates to http://opensimulator.org/mantis/view.php?id=7398
 2015-01-13 18:54:41 +00:00
Justin Clark-Casey (justincc)
fdecf4f610 Remove quotes from column selection in PGSQLUserProfilesData.UpdateAvatarProperties() 
This may have been preventing it from working.
 2015-01-13 18:52:49 +00:00
Justin Clark-Casey (justincc)
0cc75a0a3c Remove quotes from column selection in PGSQLUserProfilesData.GetAvatarNotes() 
This may have been preventing it from working.
 2015-01-13 18:50:34 +00:00
Justin Clark-Casey (justincc)
b38a552fd6 Remove quotes from field selection in PGSQLUserProfilesData.GetAvatarPicks() 
This may have been preventing it from working.
 2015-01-13 18:47:51 +00:00
Justin Clark-Casey (justincc)
43b094f549 minor: correct two exception messages in PGSQLUserProfilesData where I copy/pasted AgentInterestsUpdate twice 2015-01-13 18:42:04 +00:00
Justin Clark-Casey (justincc)
02dcfcf537 Remove the locking in PGSQLUserProfilesData which was buggy (Lock object wasn't set!) and is unnecessary. 
Relates to http://opensimulator.org/mantis/view.php?id=7398
 2015-01-12 23:39:27 +00:00
Justin Clark-Casey (justincc)
38590a4fad Get PGSQL UserProfilesData to log the exception trace for debugging rather than just the exception message. 2015-01-09 00:19:48 +00:00
BlueWall
a76aec8467 Fix whitespace hoping to avoid a flogging 2014-11-25 19:27:15 -05:00
BlueWall
41cc73233c Re-work handling of email notifications settings. 2014-11-24 11:00:47 -05:00
BlueWall
12108bf6e9 Fix handling of user preference updates where no email address is supplied 2014-11-23 14:25:48 -05:00
BlueWall
b45c929d66 Fix over zealous chopping of text when editing (pilot error) 2014-10-15 09:55:41 -04:00
BlueWall
5c9ef4d083 Fix logging level to Error in exception handlers 2014-10-15 09:42:29 -04:00
BlueWall
231cdc2dc1 Cleanup unused code 2014-10-15 09:31:39 -04:00
BlueWall
1812cecdb7 Fix PgSQL adapter for UserProfiles 2014-10-15 09:08:25 -04:00
BlueWall
1842388bb4 Add support for user preferences (im via email) 2013-12-06 02:52:13 -05:00
BlueWall
04f8fc1ce9 Adding profile partners fix to SQLite and PgSQL drivers 2013-12-05 20:25:28 -05:00
Fernando Oliveira
ff8a768258 Fernando Oliveira's Postgress SQL Server Data Connector as a single commit. 
* 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.
 2013-10-12 16:33:45 -05:00