aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-01-29* If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey1-12/+21
is no prim where UUID = SceneGroupID), then force one prim to have UUID = SceneGroupID. * A warning is posted about this on startup giving the location of the object * This should allow one class of persistently undeletable prims to be removed * This change should not cause any issues, but I still suggest that you backup your database beforehand * If this doesn't work for previously linked objects, then you could also try the workaround in http://opensimulator.org/mantis/view.php?id=3059 * This change has been made to mysql and mssql, but sqlite appears to work in a different way
2009-01-19* Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey1-2/+0
* Since this is a db change, as always I strongly recommend that you backup your database before updating to this revision * Haven't touched MSSQL in case I get it wrong - looking for some kind soul to take care of this.
2009-01-14* Apply http://opensimulator.org/mantis/view.php?id=2995Justin Clarke Casey1-2/+2
* This fixes MSSQL for user friends lookups * Thanks StrawberryFride
2009-01-12* Apply http://opensimulator.org/mantis/view.php?id=2965Justin Clarke Casey1-0/+1
* Adds first version of MsSql2005Dialect support for NHibernate * Thanks mpallari
2009-01-12* Apply http://opensimulator.org/mantis/view.php?id=2980Justin Clarke Casey1-0/+4
* Add single conversion to MSSQLManager.DbTypeFromType * May resolve storage of prim information under MSSQL * Thanks SirKimba
2009-01-08Update svn properties, minor formatting cleanup.Jeff Ames1-5/+5
2009-01-07Thank you kindly, StrawberryFride for a patch that:Charles Krinke3-629/+592
Solves the problem of unable to load prim items on region start in MSSQL. The error was in the MSSQLRegionData code that loads objects from the database, due to reliance on the ParentID field that is not used.
2009-01-05* Stop bothering to populate and retrieve the parent local ids for MSSQL, as ↵Justin Clarke Casey1-2/+0
was done for SQLite and MySQL in r7586 * This may resolve http://opensimulator.org/mantis/view.php?id=2939
2008-12-28Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-1/+6
Persists appearance with MSSQL more properly.
2008-12-20Mantis#2881. Thank you kindly, SirKimba for a patch that:Charles Krinke1-5/+5
Solves inserting Wolrdparameters in SQL Database with OpenSim.Data.MSSQL.dll always crash cause there were missing some fields in the Insert-String
2008-12-01Mantis#2730. Thank you kindly, StrawberryFride for a patch that:Charles Krinke1-2/+2
MSSQL Fix to accommodate random ParentIDs. uint values now cleanly converted to ints and vice versa to hopefully prevent outofrange exceptions on prim storage.
2008-11-27* Remove unused and largely unimplemented UpdateUserCurrentRegion()Justin Clarke Casey1-11/+0
* please say if this causes you a problem
2008-11-23Plumb in the presence notifications and region shutdown/restart messagesMelanie Thielker1-0/+4
from the presence module to the message server, through the user server and on into the database. This should fix the "Already logged in" issue that grids see after a sim crashes, or a user crashes out of a sim. Not yet a 100% solution for friends, but getting there.
2008-11-21* Comment out unused access time method in MSSQLJustin Clarke Casey1-18/+18
* This should probably be being called in FetchAsset() instead as for all the other databases, but I lack the means to test MSSQL
2008-11-21* refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey1-1/+1
* SceneObjectPartInventory.cs isn't a particularly good name but it's probably not got a long life * A proper inventory interface to follow * Parallel changes for other inventory partial classes to follow at a later date
2008-11-21Update svn properties, minor formatting cleanup.Jeff Ames3-19/+19
2008-11-19Mantis#2658. Thank you kindly, StrawberryFride for a patch that:Charles Krinke2-0/+12
Keeping up with MySQL and SQLite. Small code changes and another resource file to add.
2008-11-19Mantis#2657. Thank you kindly, StrawberryFride for a patch that:Charles Krinke4-57/+70
Added access_time and create_time, plus the new sun position data to MSSQL code.
2008-11-17cleaning up warnings in MSSQL code.Dr Scofield3-3/+3
2008-11-15Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.Homer Horwitz17-782/+14
2008-11-15Mantis#2552: Thanks idb, for a patch that fixes persistence of physical prims.Homer Horwitz1-2/+1
(added a fix for the broken build from last commit, too)
2008-11-14Mantis #2618Melanie Thielker3-2/+10
Thank you, StrawberryFride, for a patch that adds group permission support to MSSQL. Contains a migration, back up your database.
2008-11-10* refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey1-2/+2
RootPart and adding the part separately * Make RootPart read only
2008-11-09Update svn properties. Add copyright headers. Minor formatting cleanup.Jeff Ames2-50/+50
2008-11-09Mantis#2591. Thank you kindly, Ruud Lathrop for a patch that:Charles Krinke2-0/+50
This patch is two script that fixes a issue when adding more then 1 avatar to estateban/estatemanager list. It removes a key and adds a index to the tables.
2008-11-08Remove empty OSUUID.cs file. Add copyright headers. Minor formatting cleanup.Jeff Ames1-1/+28
2008-11-05Update svn properties, minor formatting cleanup.Jeff Ames1-5/+5
2008-11-05added missing file from mantis #2555Dahlia Trimble1-0/+5
2008-11-04* Apply http://opensimulator.org/mantis/view.php?id=2555Justin Clarke Casey1-4/+7
* Add new e-mail field to users table for MSSQL * Thanks StrawberryFride
2008-11-01Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz1-0/+33
on-/offline updates, calling cards for friends. This adds methods in the DB layer and changes the MessagingServer, so a full update (incl. UGAIM) is necessary to get it working. Older regions shouldn't break, nor should older UGAIM break newer regions, but friends/presence will only work with all concerned parts (UGAIM, source region and destination region) at this revision (or later). I added the DB code for MSSQL, too, but couldn't test that. BEWARE: May contain bugs.
2008-10-27Update svn properties, minor formatting cleanup.Jeff Ames1-5/+5
2008-10-27Thank you kindly, Ruud Lathrop for a patch that solves:Charles Krinke3-157/+187
Primary Key violation when just linked a lot of prims using MSSQL.
2008-10-18Add a resource file on Strawberry's patch I missedMelanie Thielker1-0/+7
2008-10-18Thank you, Strawberry Fride, for a patch that brings MSSQL even with MySQLMelanie Thielker1-31/+35
2008-10-15* minor: comment out persisting prim inventory log messagesJustin Clarke Casey1-1/+1
2008-10-03Add the missing bits for the new region-search:Homer Horwitz1-0/+27
- Added lookup in the data-layer - MySQL works - SQLite doesn't have a grid-db, so it won't work there - I added MSSQL-code to the best of my knowledge; but I don't know MSSQL :-) - Added the plumbing up to OGS1GridServices. This speaks with the grid-server via XMLRPC. - Modified MapSearchModule to use the new data. It's backward compatible; if used with an old grid-server, it just returns one found region instead of a list. - Refactored a bit. Note: This updates data, grid-server and region code. No new files.
2008-09-29* Add missing mssql migration files from ↵Justin Clarke Casey3-0/+76
http://opensimulator.org/mantis/view.php?id=2295 * Sorry about that
2008-09-29* Apply http://opensimulator.org/mantis/view.php?id=2295Justin Clarke Casey4-72/+103
* Updated MSSQL to reflect resend changes * Added the new columns in prims table. * Created a implementation for getting gestures. * Remove configurable table names for user. * Thanks Ruud Lathorp
2008-09-28Mantis#2291. Thank you kindly, StrawberryFride for a patch that solves:Charles Krinke3-53/+0
User server won't start up for a MSSQL grid migrating from a significantly older version to current version due to duplication in three of the migrations code files. Patch included takes out the duplicated code from the three files so a smooth update should happen on start up.
2008-09-26* Patch from JHurlimanTeravus Ovares2-3/+3
* Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
2008-09-24Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz1-0/+5
Active gestures are sent as part of the login-response. Added fetchActiveGestures to SQLite and MySQL; added an empty one for MSSQL and NHibernate. Using the empty ones won't cause errors, but doesn't provide persistence either, of course.
2008-09-18- Add Dispose method to IRegionDataStoreHomer Horwitz1-0/+5
- Add necessary dummy Dispose-methods where they are missing - Implement the SQLite Dispose-methods (currently only used for unit tests, in the next commit)
2008-09-14Mantis #2124Melanie Thielker20-1716/+2534
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-12* Make fix to MSSQLRegionData.cs in LoadLandObjects as recommended by ↵Justin Clarke Casey1-1/+1
Garrett Hussey in Re: [Opensim-dev] MSSQL runtime error in latest build.. * Thanks!
2008-09-09Update svn properties, formatting cleanup.Jeff Ames1-2/+2
2008-09-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares7-197/+197
* This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
2008-09-06* Blind fix what looks like a bug in the new land MSSQL codeJustin Clarke Casey1-1/+1
* The data returned from the db was never inserted in the list to be processed and return * This is an example where a warning has revealed a bug
2008-09-06* Remove lots of warnings from the CMS moduleJustin Clarke Casey2-3/+2
* Remove a few other miscellaneous warnings
2008-09-02Committing the missing resource file for MSSQL. Sorry...Melanie Thielker1-0/+161
2008-09-02Mantis #2102Melanie Thielker2-8/+10
Thank you, RuudL, for a patch that supplements the previous MSSQL patch.
generated by cgit v1.1 at 2024-10-31 09:34:48 +0000