Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] Subject with two subject_id

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] Subject with two subject_id


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Jared Hoffman <>, Gouper Users <>
  • Subject: RE: [grouper-users] Subject with two subject_id
  • Date: Wed, 12 Sep 2018 20:07:55 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:lCP5exb80B8h7nxArojwiUX/LSx+4OfEezUN459isYplN5qZrsmzbnLW6fgltlLVR4KTs6sC17KJ9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCa/bL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJVyJPHJ6yb5cBAeQCM+ZXrYj9qEcBohalHwagGP/jxyVUinPq36A31fkqHwHc3AwnGtIDqHrYotf1NaYTT++11rHExijdYvNWwzf96ZPIfh48qvyLWLJ/bcrRyEkuFgzblFWdso3lPyiJ2egXrmib9/RvVeSpi2I9tQ5+vyWvy94qh4LUhYwV0kjJ+TtkzIs0P9G1RlB3bcS5HJZTqi2WLYR7T8c6T211tis21qcKtJqmcCQQ1pgr2hrSZ+aaf4WK4x/vTOiRLil7iX55fb+yggi9/VSix+LnU8S51FVHriRBn9TJt30A1xje5taCR/tz+kquxy2A2gbO4e9eO080j7DUK5s5z74wiJUTtUPDEzfulkjqi6Gaakop9vG25ur+f7nqv5icOJRqhQ3kNaQuh9C/Dv8/MggTWWiU5P6w1KX5/U3+XLVFkOE5krXYsJDdI8QXvKm5AxJJ0oYn7Ba/CDSm3M4EknkAKVJJYBOHj473NFHSOP30E+qzjlW2nDpl2fzKJKDtD5bQInTZn7rsea5x60tGxwoyydBf6YhUCrYEIP/rX0/+qNzYDx84MgOq2ebqE9R91pgCVm6VH6+ZKL3dsVmO5u41PeaDeZIVtC7nK/c5//7ukWM5mVgFcKmmx5sXb224Hux4LEWDeHbsn8wBHnkQvgolV+HqjFyCUSVPZ3apQa4w/DA7CIS6DYjdXICthqKO3DulEpFMeG9JF02MQj/UcNCmUu0BZGqyJcFvlzUCHeyhTIEv0Biotif5xrx2KeyS9yEF49ar+99o/+DJ3Swp+CZvR5CSyWaQV2xu234TSiUt9KF5vUFnzFqfi+51j+EORvJJ4PYcGCcrJ5PGi6RRC8rzQUiJKtKCSEe0T8+OACo6CM8pztkIJUtxBoPx3Vj4wyO2DupNxPSwD5su//eZhiCpfZwvwmva1KQnk1gtS9dOMmvjnKNk6gzPHNCVwV6BmfOscqIRlG7W+WGPwHDGnXkQURU4EMCnFWsaelOQqN344k3YSLr7DL8nIxlM0+aDMaAMd8Xki1MASfv+a5zT
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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





Archive powered by MHonArc 2.6.19.

Top of Page