[Opensim-users] Recovering from Groups misconfiguration, need to generate folderID

[Rick Anderson]

Sorry, I was wrong. PrimaryKey is default
 '00000000-0000-0000-0000-000000000000';



On Wed, Aug 27, 2014 at 2:49 PM, Rick Anderson <rianders at docs.rutgers.edu>
wrote:

> Ok. folderID is a primary key and should create a unique identifier when I
> insert a new line.
>
> --Rick
>
>
> On Wed, Aug 27, 2014 at 2:46 PM, Rick Anderson <rianders at docs.rutgers.edu>
> wrote:
>
>>
>> I misconfigured the groups module then create users that were unable to
>> get a "My Inventory" folder. These users can't log in right now. I could
>> delete them and start over. However, I was looking to repair them.
>>
>> Find the problem users in MySQL:
>> select PrincipalID, FirstName, LastName from useraccounts where
>> PrincipalID NOT IN (select agentID from inventoryFolders);
>>
>> Review the users with good inventory in MySQL:
>> select *  from inventoryFolders where   type='9';
>>
>> Example Result:
>>
>> | folderName   | type | version | folderID                             |
>> agentID                              | parentFolderID
>> |
>>
>>
>> +--------------+------+---------+--------------------------------------+--------------------------------------+--------------------------------------+
>>
>> | My Inventory |    9 |      18 | 15f6ef74-647e-466c-b374-125c162109e5 |
>> aa011451-9b44-4133-af1e-2bcfb66bbfeb | 00000000-0000-0000-0000-000000000000
>> |
>>
>>
>> Issue:
>> I need to generate a folderID.
>>
>> Questions:
>> Is there a way to generate inventory folders from the command line?
>>
>> How do I get a no colliding folderID?
>>
>>
>> Thanks,
>>
>> --Rick
>>
>> --
>> Rick Anderson
>> Director of Virtual Worlds
>> Division of Continuing Studies (DoCS)
>> Rutgers University
>> (732) 586-3265
>>
>
>
>
> --
> Rick Anderson
> Director of Virtual Worlds
> Division of Continuing Studies (DoCS)
> Rutgers University
> (732) 586-3265
>



-- 
Rick Anderson
Director of Virtual Worlds
Division of Continuing Studies (DoCS)
Rutgers University
(732) 586-3265
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20140827/feaa1cf2/attachment.html>