aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
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.
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 Ames1-6/+6
2008-11-19Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2-0/+15
Attached patch implements llCollisionSound. Thanks T. Sado.
2008-11-18Fixed MySQL and SQLite so they will save theSean Dague2-0/+19
variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-11-16Make a quick stab at the "Open data reader" issue.Melanie Thielker1-8/+20
MySqlDataReader needs to be Close()d explicitly. Disposing it or letting it fall out of scope will not free it's hold on the connection.
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-14Add SQLite and the missing migrations files for last commitMelanie Thielker1-0/+5
2008-11-14Add group permissions to agent inventory.Melanie Thielker1-2/+4
Contains a migration. May contain nuts. Please back up your inventory data store. This revision changes the interface version!! No older regions can connect to these new UGAIM, and the new regions can't connect to the old UGAIM. Fixes a long-standing issue of permissions loss Currently persisted on MySQL only.
2008-11-13make inventory item listing more robust. It turns out that a bad itemSean Dague1-8/+28
(one that won't parse right) will prevent all other items in that folder to load when inventory is requested. This is very careful to no longer add inventory items that return as null to the hash table for getInventoryInFolder, as well as be more careful parsing UUIDs for fields that aren't marked not null in MySQL. The net result, you may see previously missing inventory items return after this checkin. Folders probably need to be hardened in the same way, but I'm out of time for today.
2008-11-13Update avatar picker search to work with OpenSearch people searchMelanie Thielker1-2/+2
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-08Mantis#2598: Thanks Fly-Man- for a patch that fixes a client-thread crash byHomer Horwitz1-1/+1
allowing landFlags bit 31 to be used (Int32 -> UInt32).
2008-11-08Remove empty OSUUID.cs file. Add copyright headers. Minor formatting cleanup.Jeff Ames1-1/+28
2008-11-06add create_time and access_time to asset db for mysql, as wellSean Dague2-2/+52
as the code to update these at the appropriate time. This isn't surfaced in AssetBase yet. Change the replace into to an insert into for asset create. Assets are not supposed to be updatable, and the replace into is more expensive. From: Sean Dague <sdague@gmail.com>
2008-11-06From: arthursv@linux.vnet.ibm.comSean Dague2-21/+21
Add more unit tests for user cases Persist more user fields into mysql that already had columns defined but weren't getting passed to the mysql manager.
2008-11-04add some null protection on emailSean Dague1-1/+1
From: Sean Dague <sdague@gmail.com>
2008-11-04implement email field for MySQL and SQLiteSean Dague3-15/+23
From: Sean Dague <sdague@gmail.com>
2008-11-01* Minor cleanupAdam Frisby1-1/+0
* Added additional error message when a Object/SOG DB save fails so we can trace why.
2008-11-01Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz1-0/+43
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-11-01Fix a compile warning about unreachable codeHomer Horwitz1-2/+0
2008-11-01A stab a getting the user server to act right. Move acquisition of theMelanie Thielker2-18/+21
locks to just before the try/catch/finally block, so that an exception thrown between taking the lock and entering the try doesn't leave a mutex locked
2008-10-31* Added some debug information to MySQL UserDataManager to help diagnose a ↵Adam Frisby2-18/+25
potential issue when in high load. Related to mantis #2508.
2008-10-30- Includes consistency test for new and updated objects, asSean Dague1-3/+2
some fixes in MySQL and SQLite From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>