Sorry, I was wrong. PrimaryKey is default '00000000-0000-0000-0000-000000000000';
On Wed, Aug 27, 2014 at 2:49 PM, Rick Anderson <[email protected]> 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 <[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 > -- 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
