grouper-users - Re: [grouper-users] Subject with two subject_id
Subject: Grouper Users - Open Discussion List
List archive
- From: Jared Hoffman <>
- To: Chris Hyzer <>
- Cc: Gouper Users <>
- Subject: Re: [grouper-users] Subject with two subject_id
- Date: Thu, 13 Sep 2018 11:02:45 -0400
- Ironport-phdr: 9a23:dqw5EhXzrMtlZPOHXBySXnszXAzV8LGtZVwlr6E/grcLSJyIuqrYbBWHt8tkgFKBZ4jH8fUM07OQ7/i/HzRYqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjWwba9wIRmssQndqtQdjJd/JKo21hbHuGZDdf5MxWNvK1KTnhL86dm18ZV+7SleuO8v+tBZX6nicKs2UbJXDDI9M2Ao/8LrrgXMTRGO5nQHTGoblAdDDhXf4xH7WpfxtTb6tvZ41SKHM8D6Uaw4VDK/5KpwVhTmlDkIOCI48GHPi8x/kqRboA66pxdix4LYeZyZOOZicq/Ye94RWGhPUdtLVyFZDYy8YYkAAeoPM+hbsofzuUcBoACkCgWwHu7i0CNEimP00KA8zu8vERvG3AslH98WtHrbts/1O7kPXuuozqfIyjvDb/1T2Tjn7ojDbxcsofGLXbJ+f8rRzFMgFwXHjliLqozqITWV1+QKs2id9eZvS/+gi3M+pgx3vzOhxd8sh5HXio8U1lzJ9yB0wIg2KNKjVEJ2ZNGpHZhRuiyVMoZ6XN8uTmRttSknxLALuJi2dzUQxps93R7QcfmHfpCI4h39UOaRJi91hHd/d7K+gxa+6EmgyurhWsWt31dFsyRIn9jWunAC0BzT7ceHSv9j8Uu7xTmP0AXT5vlFIUAyi6XbN4YszqAxm5YPs0nOGyH2lUbtg6OKc0gp9eul5uXob7jjuJOQK4p5hwTjPakgm8GzGeE4PRIPX2if9+S8zrrj/UjhTbVKif02nKfZsJXAKsQdpK60GAxV3Zgl6xe/CDem1s4UkmcaI1JYYB6HlZTmO0nSIPDkCveym1uskC1sx/DbJr3uHI/NImHekLf6Y7l98VVcxRE3zdBe/JJUFqoBLOzpVk/wstzYEgE2Mxayw+n5FNVxyJkSVnySDa+EY+vutgqj5vguOKGsdZ0Yon6pLvMl9uzjl1c4glRbYLGk251RZXylSKdIOUKcNFjlmNoNWUcNsAQ7Reqi3F2FXzBWbnCwd6Ex4CA8DsSrAZqVFdPlu6CIwCruRs4eXWtBEF3ZVC6wL4g=
If one of them doesn’t have references in other tables (you will know from foreign keys), then you can delete from grouper_members. Note, I would copy that row beforehand exactly so you can recreate or have a reference to the uuids if needed
Thanks
Chris
From: <> On Behalf Of Jared Hoffman
Sent: Wednesday, September 12, 2018 3:57 PM
To: Gouper Users <>
Subject: [grouper-users] Subject with two subject_id
We have a user in grouper_members twice. Their subject_identifier0 is their email address, but they have 2 subject_id. We resolved the issue (account recreated with a new subject_id by mistake). All memberships point to the original subject_id.
What is the best way to remove Grouper's memory of the bad record? IE can we delete from grouper_members or is there a better way?
Thank you.
Jared
--
Jared Hoffman • Associate Director for Enterprise Infrastructure
Information Technology Services • LBIS • Kenyon College
• 740.427.5948
- [grouper-users] Subject with two subject_id, Jared Hoffman, 09/12/2018
- RE: [grouper-users] Subject with two subject_id, Hyzer, Chris, 09/12/2018
- Re: [grouper-users] Subject with two subject_id, Jared Hoffman, 09/13/2018
- RE: [grouper-users] Subject with two subject_id, Hyzer, Chris, 09/12/2018
Archive powered by MHonArc 2.6.19.