Our website is made possible by displaying online advertisements to our visitors.
Please consider supporting us by disabling your ad blocker.
Please consider supporting us by disabling your ad blocker.
OpenSimWorld is the directory of 3D Virtual Worlds based on OpenSimulator and connected through the HyperGrid. Learn More
New Members
27535, TaliaStargarden, Edward10, Luna_Skye, Alvial, Emision1, Online Custom Gaming, BlancaRosa, Surpriisee, AvaCeleste, Annasweet, RebelNebula, Ghostmachinesing, AurrieLynne, Xmatttezx, EmiraBloom, SugarSweetTimeFix, LanKyro, Kiokoridore, LaylahLikes
Reposting this as it is an important fix any grid can and should run. There is a patch in core Opensimulator code as of 2/15 to allow outfits to load correctly without breaking links. This has been a bug forever, and was caused by loading IARs. For the those grids that do not use core's latest 0.9.3.1 dev (PBR), I have SQL for grid owners to fix their broken links in outfits. DreamGrid has this patch for future uploads, and also will run this SQL to repair all old outfits. You need do nothing except update to the latest DreamGrid 6.02 (Non PBR) or 7.02 (PBR). DreamGrid will automatically fix old as well as IAR uploads, even in V6 series which is Opensim 0.9.2 ( Non PBR )
Mysql SQL code is this:
use robust; //with whatever your database is. For standalones it may be 'opensim' as there is no robust.
show databases; // will show you which databases you have and their names.
use robust;
update inventoryfolders set type = 47 where foldername='My Outfits' and type = -1;
This fixes all old links. You need the patched Opensim to fix future links, OR you can run this again after loading an IAR. You do not have to do this, links can be fixed in the viewer but it's a tad tedious.
Grids will need to compile dev master from Feb 15 or later to make this automatic fix when loading of IARS. If you can't do that, just run this SQL after any IAR load.
Please be aware you should backup your robust database first, just in case. The details for coders is at http://opensimulator.org/mantis/view.php?id=9180
Mysql SQL code is this:
use robust; //with whatever your database is. For standalones it may be 'opensim' as there is no robust.
show databases; // will show you which databases you have and their names.
use robust;
update inventoryfolders set type = 47 where foldername='My Outfits' and type = -1;
This fixes all old links. You need the patched Opensim to fix future links, OR you can run this again after loading an IAR. You do not have to do this, links can be fixed in the viewer but it's a tad tedious.
Grids will need to compile dev master from Feb 15 or later to make this automatic fix when loading of IARS. If you can't do that, just run this SQL after any IAR load.
Please be aware you should backup your robust database first, just in case. The details for coders is at http://opensimulator.org/mantis/view.php?id=9180
Liked by: 
Comments
Is there a possibility that the broken links are the result of certain versions of Firestorm writing incorrectly to the database, and that the damage to the outfit folder is actually just a symptom of a much larger problem?
like(0)
Maybe not - but it can make invalid api calls to the server. If it sends invalid data regarding folder types (-1 instead of 47) to MyOutfits in api calls - its effectively the same thing even if the client doesnt itself write to the database.
like(0)
I will add that while I stand by the fact that the viewer can and does make api calls - and a "valid" api call may still not make "sense".... it does seem strange that if this is caused by uploading IAR files - which are after all created on the server - NOT the viewer - and then restored to the server - not the viewer - why is this viewer related?
Is it that the viewer is creating the incorrect folders in the first place - so when you make the IAR it doesnt have the correct date to create the IAR with - so when you restore it the data is incorrect? In which case - if the viewer creates the folders originally with the incorrect data in - but still SHOWS them correctly - why is saving and restoring the IAR - in essense (maybe) restoring the incorrect data to the place where the incorrect data was before......... causing an issue? Incorrect data before was "ok" but after save and load is no longer "ok"?
It doesnt "totally" add up for me - not that it has to ofc :)
like(1)
Is it that the viewer is creating the incorrect folders in the first place - so when you make the IAR it doesnt have the correct date to create the IAR with - so when you restore it the data is incorrect? In which case - if the viewer creates the folders originally with the incorrect data in - but still SHOWS them correctly - why is saving and restoring the IAR - in essense (maybe) restoring the incorrect data to the place where the incorrect data was before......... causing an issue? Incorrect data before was "ok" but after save and load is no longer "ok"?
It doesnt "totally" add up for me - not that it has to ofc :)
Nothing to do with viewer. The My Outfits folder in the database is only one level deep. It has a parent-child relationship between items. The items in that folder were being set to -1, User defined when an outfit was read from the IAR. It was simple supposed to be "Outfit"m i.e, 47 Its been a known bug for ever, but thought to be something else, perhaps the viewer. See Valr30's post on the Mantis, as he spotted the proper fix. http://opensimulator.org/mantis/view.php?id=9180
The SQL is designed to fix old outfits. the patch fixes new IARS loads. DreamGrid does both now, automatically.
like(2)
The SQL is designed to fix old outfits. the patch fixes new IARS loads. DreamGrid does both now, automatically.
I did notice this when I recently saved an IAR on 9.2.1 and loaded it on 9.3.0 (Linux)
Thankfully it wasn't hard to find the outfit folders in my inventory that were missing the coat hanger icon. I just wore the contents of each folder, copied the folder name and saved each outfit again using the original folders name. I only had about 12 outfits to save so it was sorted in 5 minutes. I then deleted the outfit folders that didn't have the coat hanger icons.
I'm not comfortable or competent enough to alter my database manually, or compile open sim from scratch so my method above was much easier to deal with for me. I mean how often do I reload IAR's anyway.
Its nice to know it will be fixed in the next release version though.
like(0)
Thankfully it wasn't hard to find the outfit folders in my inventory that were missing the coat hanger icon. I just wore the contents of each folder, copied the folder name and saved each outfit again using the original folders name. I only had about 12 outfits to save so it was sorted in 5 minutes. I then deleted the outfit folders that didn't have the coat hanger icons.
I'm not comfortable or competent enough to alter my database manually, or compile open sim from scratch so my method above was much easier to deal with for me. I mean how often do I reload IAR's anyway.
Its nice to know it will be fixed in the next release version though.
I was able to repair them when I moved between grids in the viewer. You open two inventory windows. Search in one for bkoekn links. Click one and press f2 to edit the name,. then do a ctrl -C to copy it.
Search in the other windows for that name by pasting the name in. In there will be many broken links, and the original item.
Drag and drop that original to the other inventory window and save it. Repeat, wash and rinse.
like(1)
Search in the other windows for that name by pasting the name in. In there will be many broken links, and the original item.
Drag and drop that original to the other inventory window and save it. Repeat, wash and rinse.
Doing that for every item in an outfit, across multiple outfits sounds like a lot of work.
All I did was right click the broken outfit folder and "Replace current outfit" to wear it. Then open the appearance window and save as "folder name" for that outfit. Repeat for all the outfits. Then when done delete all the outfit folders that don't have the coat hanger icon.
It took me 5 minutes to wear and save about 12 outfits.
like(0)
All I did was right click the broken outfit folder and "Replace current outfit" to wear it. Then open the appearance window and save as "folder name" for that outfit. Repeat for all the outfits. Then when done delete all the outfit folders that don't have the coat hanger icon.
It took me 5 minutes to wear and save about 12 outfits.
Yes, I wish I had known that before as years ago, I moved about 100 outfits. In our testing, one dev found all you have to do was move the load IAR "outfits into the actual Outfit.My Outfits folder. It was really even simpler that anyone realized. II think it needs to be in a book, called "Come You Nigh", - Kay Shuns. I've know about this for years but never puzzled it out. There have been several "long term" bugs still still being spotted. Materials not loading in OARs, this one, a major security issue, and still bugs like anyone can impersonate another.
like(1)
Thanks Fred, that's very useful. Sub-Version is somewhat behind on an older 0.9.3. I've not had issues with this myself as I've not USED the "Outfits" folder myself for some time probably due to this very issue. It may be time to look at this again in light of this fix!
Not related but what I REALLY want for outfits - is an implimentation of "Wardrobe" (https://www.carlyletheassolutions.com/wardrobe.php) for OpenSim - but someone would have to make a backend service for it - and who would people trust with their outfit knowledge?? Unlikely to ever be a thing but WOULD be pretty awesome!! Wishful thinking I am sure.
like(0)
Not related but what I REALLY want for outfits - is an implimentation of "Wardrobe" (https://www.carlyletheassolutions.com/wardrobe.php) for OpenSim - but someone would have to make a backend service for it - and who would people trust with their outfit knowledge?? Unlikely to ever be a thing but WOULD be pretty awesome!! Wishful thinking I am sure.
That's interesting. I used to run a web service like this in SL. You could put textures or sculpts in it, and they would show up on the web. You could click them on the web site and the box would show them in world from your inventory. SL exposes all textures and sculpts by UUID to a search service. I shut it down as people would use it to copy no-copy sculpts. And I could not stop them.
like(2)