aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/PGSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2015-07-26Update PGSQL groups handler to accept search queries from the viewerGeir Nøklebye3-17/+26
Update PGSQL groups handler to accept search queries from the viewer. Fixed malformed query strings. Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-07-23Add quotes aroung LandFlags as PGSQL seems to choke on the word whenMelanie Thielker1-1/+1
it's bare.
2015-07-14Correcting errors in previous change: MySQL needs int unsigned, notMelanie Thielker1-2/+2
unsigned int. PGSQL has no unsigned types, changing to bigint.
2015-07-14Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker1-0/+8
2015-06-26Applying Gavin Hird's patch to correct PGSQL group notices. Thatk you,Melanie Thielker1-1/+11
Gavin
2015-06-24Thanks Gavin Hird for a fix for Mantis 0007604: DeleteClassifiedRecord ↵dahlia1-123/+124
exception PGSQL
2015-06-24Thanks Gavin Hird for a fix for an exception when requesting an Estate Ban ↵dahlia1-3/+3
when using PGSQL.
2015-06-14Removed the pgsql table for AgentPrefs, because it is not working. For now ↵Diva Canto2-22/+12
the Agent Preferences feature will not work with PGSQL installations -- someone who uses PGSQL needs to send a table that works.
2015-06-14Mantis #7610. Changed AgentPrefs table in PGSQL to use uuid instead of ↵Diva Canto1-13/+14
varchar(36), to be consistent with the otehr pgsql tables. Since the first commit on this was yesterday, there's no migration; instead, the version starts at 2. If anyone created the table yesterday, it will be dropped and recreated. WARNING: untested. (I don't use pg)
2015-06-14Removing the Store methods in the DB layer of AgentPreferences, as they were ↵Diva Canto1-4/+0
simply calling the base ones.
2015-06-14Quell three new warnings I introduced with AgentPrefsData, return an empty ↵Cinder1-2/+2
llsd map instead of an empty llsd block when no AgentPrefs service is available to try and appease Firestorm Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13SQLite and PGSQL adapters for AgentPreferencesCinder2-0/+77
Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-04-29Updated all occurrences of AssemblyVersion("0.8.1.*") to ↵Diva Canto1-1/+1
AssemblyVersion("0.8.2.*")
2015-04-12Change UserProfiles so that the parcel name is used for a ProfilePick and ↵AliciaRaven1-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>
2015-03-04Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2-4/+2
operation is very expensive
2015-03-04One more migration fixCinder2-2/+2
Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-04Revert "Chase latest change to asset description length with an update to ↵BlueWall1-9/+1
XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
2015-03-04Chase latest change to asset description length with an update to ↵Cinder1-1/+9
XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
2015-03-03Follow up to last commit, fix field lengthCinder1-0/+4
Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
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)1-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.
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-25Fix whitespace hoping to avoid a floggingBlueWall1-4/+4
2014-11-24Re-work handling of email notifications settings.BlueWall1-3/+0
2014-11-23Fix handling of user preference updates where no email address is suppliedBlueWall1-3/+8
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 handlersBlueWall1-18/+18
2014-10-15Cleanup unused codeBlueWall1-30/+7