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 <[email protected]> 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
_______________________________________________ Opensim-users mailing list [email protected] http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
