[Archivesspace_Users_Group] Unable to delete agent?

[Andrew Morrison]

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.

Andrew.



On 30/08/2022 19:48, Wendy Scheir wrote:
> Hello,
> Can someone help us interpret this error message we're getting when 
> trying to delete an agent?
> 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`))
>
>
> Many thanks,
>
> Wendy
>
> ____________________________________
>
> WENDY SCHEIR
>
> director
> THE NEW SCHOOL ARCHIVES & SPECIAL COLLECTIONS
>
> 66 FIFTH AVENUE, NEW YORK, NY 10011
>
> scheirw at newschool.edu 
> <https://www.newschool.edu/email-signature-generator/robinsa1@newschool.edu>
>
> T 212-229-5942
>
> Explore the Archives <http://archives.newschool.edu>| Digital 
> Collections from the Archives 
> <http://digitalarchives.library.newschool.edu/>| New School Histories 
> <http://newschoolhistories.org/>|@tnsarchives 
> <https://twitter.com/tnsarchives>
>
> THE NEW SCHOOL
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20220831/ed13280c/attachment.html>