[Opensim-dev] multiple, empty, root inventory folders

[Charles Krinke]

The situation exists where a number of avatars have multiple root inventory folders on OSGrid, and I suspect on other grids as well. One of the implications is that this obscures the inventory as our search stops at the first root inventory folder it finds, that is the first one whose parentFolderId == zeroes.

Having a query to identify and then remove completely empty root inventory folders might help make this situation better, but it involves a fairly complex mysql query that is currently beyond my abilities. I am hoping someone could help out a little here with a query that can be used to identify multiple root inventory folders in a grids mysql database and a query to would allow them to be deleted, perhaps one by one, that would be fine.

This query involves finding all those avatars with inventoryfolders entries where more then one parentFolderID is zeroes.