aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2009-03-22MYSQL Only: Make items given while offline appear in inventory withoutMelanie Thielker1-0/+9
the need to clear cache.
2009-03-21Add a QueryItem method to the inventory subsystem. Currently implemented forMelanie Thielker1-0/+5
MySQL only, stubs for the others. This allows updating the cache with a single item from the database.
2009-03-09Implemented FetchAssetMetadataSet in DB backends.Mike Mazur1-0/+51
This method fetches metadata for a subset of the entries in the assets database. This functionality is used in the ForEach calls in the asset storage providers in AssetInventoryServer. With this implemented, frontends such as the BrowseFrontend should now work. - MySQL: implemented, sanity tested - SQLite: implemented, sanity tested - MSSQL: implemented, not tested - NHibernate: not implemented
2009-02-25* Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa711-4/+0
I do realize the setter has to be there for legacy reasons, but since the calls will never acually DO anyhting, I'm removing them. * So, SOP.FolderID is actually a cruft field that should be removed.
2009-02-22Mantis#3218. Thank you kindly, TLaukkan (Tommil) for a patch that:Charles Krinke7-12/+29
* Added log4net dependency to physxplugin in prebuild.xml. * Added missing m_log fields to classes. * Replaced Console.WriteLine with appropriate m_log.Xxxx * Tested that nant test target runs succesfully. * Tested that local opensim sandbox starts up without errors.
2009-02-21* Applied a patch that: Added estate ban table to migration scripts and ↵lbsa711-4/+4
nhibernate mapping. Refactored property getters and setters for estate ban object to support NHibernate. * Added estate ban table to migration scripts of all supported databases. * Added nhibernate mapping for EstateBans property of EstateSettings * Refactored property accessors for EstateBan object. * Added comments for EstateBan properties. * Ensured that NHibernate tests pass with NUnitGUI. * Ensured that nant test target passes. This fixes mantis #3210. Thank you, tlaukkan!
2009-02-20* Upped VersionInfo to 0.6.3 and in the process, changed assemblyinfo to ↵lbsa711-3/+3
0.6.3.* to better track down dll ref and overwrite problems.
2009-02-18Fix estate ban list persistence in MySQL and reenable testsMelanie Thielker1-1/+1
2009-02-18remove legacy pre-migration code for mysql grid adapter, who knew thisSean Dague1-55/+0
was still in there.
2009-02-17remove all the very old create and upgrade sql files, these wereSean Dague17-288/+0
outdated by migrations 6 months ago.
2009-02-17* Moved the nifty MySQLEstateData connectionstring password-stripper out ↵lbsa711-31/+15
into the Util project
2009-02-17- remove the Metadata property from AssetBase and return all previousMike Mazur1-17/+17
properties as before - prefix private variables with m_ in AssetBase.cs - related to Mantis #3122, as mentioned in https://lists.berlios.de/pipermail/opensim-dev/2009-February/005088.html - all services will likely need to be upgraded after this commit
2009-02-16AssetInventoryServer plugins can't be a dependency for the ↵Mike Mazur1-1/+0
OpenSim.Data.MySQL addin.
2009-02-16Rename NewAssetServer AssetInventoryServer and fully qualify withMike Mazur1-1/+1
OpenSim.Grid.AssetInventoryServer.
2009-02-16- add OpenSim.Grid.AssetServer.Plugins.OpenSim as a dependency for ↵Mike Mazur1-0/+1
OpenSim.Data.*.addin.xml - remove OpenSim.Grid.NewAssetServer.exe from bin/OpenSim.Data.addin.xml - add prebuild.xml section for OpenSim.Grid.AssetServer.Plugins.OpenSim.dll
2009-02-12* optimized usings.lbsa7114-77/+31
2009-02-09Update svn properties, minor formatting cleanup.Jeff Ames1-99/+99
2009-02-09Thank you kindly, TLaukkan (Timmil) for a patch that:Charles Krinke1-0/+99
* Fixed and added athursv's BasicEstateTest * Added MySQLEstateTest * Added SQLiteEstateTest
2009-02-06This changeset is the step 1 of 2 in refactoringDr Scofield7-9/+9
OpenSim.Region.Environment into a "framework" part and a modules only part. This first changeset refactors OpenSim.Region.Environment.Scenes, OpenSim.Region.Environment.Interfaces, and OpenSim.Region.Interfaces into OpenSim.Region.Framework.{Interfaces,Scenes} leaving only region modules in OpenSim.Region.Environment. The next step will be to move region modules up from OpenSim.Region.Environment.Modules to OpenSim.Region.CoreModules and then sort out which modules are really core modules and which should move out to forge. I've been very careful to NOT BREAK anything. i hope i've succeeded. as this is the work of a whole week i hope i managed to keep track with the applied patches of the last week --- could any of you that did check in stuff have a look at whether it survived? thx!
2009-02-04- add OpenSim.Framework.AssetMetadata class. AssetBase is now composed of itMike Mazur1-17/+17
- trim trailing whitespace
2009-02-03Rename IAssetProviderPlugin to IAssetDataPlugin aligning with the other data ↵Mike Mazur1-1/+1
plugins.
2009-01-29* If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey1-1/+15
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-28Slight cleanup of docs, removing trailing whitespace.Mike Mazur1-6/+5
2009-01-19* Remove unused prims.ParentID field from SQLite and MySQLJustin Clarke Casey1-0/+5
* 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-18Avoid an invalid cast on legacy dataMelanie Thielker1-1/+8
2009-01-14* Added MySQL Grid unit testsSean Dague1-0/+83
From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2009-01-07* Apply http://opensimulator.org/mantis/view.php?id=2948Justin Clarke Casey3-55/+55
* This fixes adding and updating user profiles in MySQL on platforms that have a commas as a decimal separator * Thanks Tommil!
2009-01-05change the drop order to see if this affects unit test failsSean Dague1-1/+1
From: Sean Dague <sdague@gmail.com>
2008-12-23* Fix http://opensimulator.org/mantis/view.php?id=2889Justin Clarke Casey1-2/+2
* Primshapes uuid wasn't being converted to raw (non-dashed) format before being used in primshapes delete command
2008-12-22Update the MySQL connector to 5.2.5. Fixes Mantids#2673. Thanks for the ↵Homer Horwitz1-1/+1
hint, jhurliman.
2008-12-08change a UUID cast to an actual new UUID call to be consistant withSean Dague1-1/+1
the rest of the assignments here.
2008-12-08fix an issue I found where primshapes weren't every being removedSean Dague1-9/+82
because of a logic error. attempt to speed up deletes a bit by batching up all the primitem deletes and primshape deletes into single delete statements. This removes the lock/release/lock/release/lock/release for loop.
2008-12-02* Resolve http://opensimulator.org/mantis/view.php?id=2743 and ↵Justin Clarke Casey1-5/+3
http://opensimulator.org/mantis/view.php?id=2739 by no longer bothering to store or retrieve the local parentID in the region database * The original issue is that the now randomly generated local ids do not fit into the int parentID datatype * However, as far as I know it's actually pointless to store this local parent ID anyway (we already store the groupUUID), especially as we don't bother to store the localID (as opposed to UUID itself). * Conservatively, the actual column will be removed in a later commit
2008-12-02Catch all possible exceptions in the mysql module. It throws non-mysqlMelanie Thielker1-2/+2
exceptions as well.
2008-12-01Fix the terrain loaderMelanie Thielker1-1/+1
2008-12-01More reverts. Revert the MySQL database module. This caused more issuesMelanie Thielker1-474/+513
than it solved by trying to use, and then exhausting, the connection pool
2008-11-30More changes to the MySQL adapter. take advantage of pooling and run lock-free.Melanie Thielker1-507/+472
This should finally kill the "There is already an open data reader associated with this connection, which must be closed first" error that makes people's builds not save
2008-11-30Update svn properties. Add copyright header. Minor formatting cleanup.Jeff Ames1-1/+1
2008-11-29Explicitly Dispose() all cmd objectsMelanie Thielker1-1/+15
2008-11-27* minor: remove mono compiler warningsJustin Clarke Casey1-1/+0
2008-11-27* Remove unused and largely unimplemented UpdateUserCurrentRegion()Justin Clarke Casey1-5/+0
* please say if this causes you a problem
2008-11-26* restore deleted method documentation, some to IRegionDataStore and some to ↵Justin Clarke Casey1-1/+10
MySQLRegionData * I would like to keep documentation on methods, even if it sometimes seems obvious (and not all of these are)
2008-11-26Yay for unit tests. Increased the type width of the prims and primshapesMelanie Thielker2-75/+79
tables, and changed the database modules to actually push these doubles down into the database layer.
2008-11-26A migration to make the floats in prims table be doublesMelanie Thielker1-0/+41
2008-11-26A migration to convert the floats int the database to doubles.Melanie Thielker2-0/+60
Maybe we don't have to say "Shift happens" as often anymore....
2008-11-26Fix 2 of the failed tests. Cause terrain queries to return null when noMelanie Thielker1-1/+1
terrain is found, rather than a default "0" terrain. Remove the "remove object wrong region" test. UUIDs either are unique or they're not. This test tested a bad behavior I have chosen not to duplicate.
2008-11-26Committing the LCO database layer. Native MySQL, no ADO. New reconnectMelanie Thielker2-1472/+746
mechanism to prevent prim loss. Preserve link order on sim restart and drag copy. Fix drag-copied prims' inventories. Fix persistence of child prim inventories.
2008-11-23Remove code from an experimantal patch that wasn't supposed to be committedMelanie Thielker1-39/+13
2008-11-23Don't serve texture preview from other people's objects if youMelanie Thielker1-13/+39
havenever seen that texture before.
2008-11-23Plumb in the presence notifications and region shutdown/restart messagesMelanie Thielker1-0/+26
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.