<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>That message means the agent you are trying to delete is also a
user of the staff interface. The database is set up to prevent
deletion of rows in the "agent_person" table if doing so would
leave a dangling reference in the "user" table. To delete the
user, and with it their associated agent record, go to System >
Manage Users, find the user in the list (which might be tricky if
their username is different to their real name), edit, and click
Delete.<br>
</p>
<p>Andrew.</p>
<p><br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 30/08/2022 19:48, Wendy Scheir
wrote:<br>
</div>
<blockquote type="cite" cite="mid:CAOPA1J5n_U65AaCWJ9aLRR9jedgA5LZJn8vrcZLatanL5ZyVtQ@mail.gmail.com">
<div dir="ltr">
<pre style="box-sizing:border-box;overflow:auto;font-family:Menlo,Monaco,Consolas,"Courier New",monospace;padding:9.5px;margin-top:0px;margin-bottom:10px;line-height:1.42857;word-break:break-all;color:rgb(51,51,51);background-color:transparent;border:none;border-radius:4px"><span style="color:rgb(0,0,0);font-family:arial;white-space:normal">Hello,</span><span style="color:rgb(0,0,0);font-family:arial;white-space:normal">
</span></pre>
<pre style="box-sizing:border-box;overflow:auto;font-family:Menlo,Monaco,Consolas,"Courier New",monospace;padding:9.5px;margin-top:0px;margin-bottom:10px;line-height:1.42857;word-break:break-all;color:rgb(51,51,51);background-color:transparent;border:none;border-radius:4px"><span style="color:rgb(0,0,0);font-family:arial;white-space:normal">Can someone help us interpret this error message we're getting when trying to delete an agent? </span>
</pre>
<pre style="box-sizing:border-box;overflow:auto;font-family:Menlo,Monaco,Consolas,"Courier New",monospace;font-size:13px;padding:9.5px;margin-top:0px;margin-bottom:10px;line-height:1.42857;word-break:break-all;color:rgb(51,51,51);background-color:transparent;border:none;border-radius:4px">Record deletion failed: Java::JavaSql::SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`archivesspace`.`user`, CONSTRAINT `user_ibfk_1` FOREIGN KEY (`agent_record_id`) REFERENCES `agent_person` (`id`))
</pre>
<div>
<div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<p style="color:rgb(0,0,0);font-family:arial;font-size:10px;padding:5px
0px 0px
5px;margin:0px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><br>
</span></p>
<p style="color:rgb(0,0,0);font-family:arial;font-size:10px;padding:5px
0px 0px
5px;margin:0px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">Many
thanks,</span></p>
<p style="color:rgb(0,0,0);font-family:arial;font-size:10px;padding:5px
0px 0px
5px;margin:0px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">Wendy</span></p>
<p style="color:rgb(0,0,0);font-family:arial;font-size:10px;padding:5px
0px 0px
5px;margin:0px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">____________________________________</span><span style="color:rgb(232,46,33)"><br>
</span></p>
<p style="font-family:arial;padding:5px
0px 0px
5px;margin:0px"><span style="font-size:10px;color:rgb(172,147,110);font-weight:bold">WENDY
SCHEIR</span><br>
</p>
<p style="color:rgb(34,34,34);background:none
0% 0% repeat
scroll
transparent;margin:0px;padding:5px
0px 0px
5px;border:0px
none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor
none 0px"><span style="color:rgb(0,0,0);margin:0px;padding:0px;border:0px
none;background:none
0% 0% repeat
scroll
transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor
none
0px;text-transform:uppercase">director</span><br>
<span style="color:rgb(232,46,33);margin:0px;padding:0px;border:0px
none;background:none 0% 0% repeat scroll
transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor
none
0px;text-transform:uppercase">THE
NEW SCHOOL </span><span style="color:rgb(102,102,102);margin:0px;padding:0px;border:0px
none;background:none
0% 0% repeat
scroll
transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor
none
0px;text-transform:uppercase">ARCHIVES
& SPECIAL
COLLECTIONS</span></p>
<p style="color:rgb(34,34,34);background:none
0% 0% repeat
scroll
transparent;margin:0px;padding:5px
0px 0px
5px;border:0px
none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor
none 0px"><span style="background-color:transparent;font-family:inherit;font-style:inherit;font-weight:inherit;color:rgb(102,102,102);text-transform:uppercase">66
FIFTH AVENUE,
NEW YORK, NY
10011</span></p>
<p style="color:rgb(34,34,34);background:none
0% 0% repeat
scroll
transparent;margin:0px;padding:5px
0px 0px
5px;border:0px
none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor
none 0px"><a href="https://www.newschool.edu/email-signature-generator/robinsa1@newschool.edu" style="background-color:transparent;color:rgb(102,102,102);text-transform:lowercase" target="_blank" moz-do-not-send="true">scheirw@newschool.edu</a></p>
<p style="background:none
0% 0% repeat
scroll
transparent;margin:0px;padding:10px
0px 0px
5px;border:0px
none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor
none
0px;color:rgb(102,102,102);text-transform:uppercase"><span style="margin:0px;padding:0px;border:0px none;background:none 0% 0%
repeat scroll
transparent;font-style:inherit;font-variant:inherit;font-weight:bold;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor
none
0px;color:rgb(0,0,0)">T</span> 212-229-5942</p>
<p style="background:none
0% 0% repeat
scroll
transparent;margin:0px;padding:10px
0px 0px
5px;border:0px
none;font-stretch:inherit;line-height:16.5px;font-family:arial;font-size:11px;vertical-align:baseline;outline:currentcolor
none
0px;color:rgb(0,0,0);text-transform:uppercase"><a href="http://archives.newschool.edu" style="text-transform:none;color:rgb(172,147,110)" target="_blank" moz-do-not-send="true">Explore the Archives</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><span style="text-transform:none;font-size:10px">| </span><a href="http://digitalarchives.library.newschool.edu/" style="text-transform:none;color:rgb(172,147,110)" target="_blank" moz-do-not-send="true">Digital
Collections
from the
Archives</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><span style="text-transform:none;font-size:10px">| </span><a href="http://newschoolhistories.org/" style="text-transform:none;color:rgb(172,147,110)" target="_blank" moz-do-not-send="true">New
School
Histories</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><font style="text-transform:none;font-size:10px" color="#000000">|</font><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><a href="https://twitter.com/tnsarchives" style="text-transform:none;color:rgb(172,147,110)" target="_blank" moz-do-not-send="true">@tnsarchives</a><br>
</p>
<p style="font-family:arial;padding:5px
0px 0px
5px;margin:0px"><img src="https://www.newschool.edu/edu-assets/marketing-communication/signature-tns.jpg" alt="THE NEW
SCHOOL" style="background:none
0% 0% repeat
scroll
transparent;margin:0px;padding:15px
0px 0px
3px;border:0px
none;font-stretch:inherit;line-height:inherit;font-family:neue,"Helvetica
Neue",Helvetica,Arial,sans-serif;font-size:17px;vertical-align:baseline;outline:currentcolor
none
0px;color:rgb(25,25,25);width:262px" moz-do-not-send="true"></p>
<div>
<div>
<p style="vertical-align:baseline;outline-width:0px;margin:0in
0in 0.0001pt"><font size="1" face="Arial,
sans-serif" color="#999999"><span style="line-height:18px"></span></font></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Archivesspace_Users_Group mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a>
<a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a>
</pre>
</blockquote>
</body>
</html>