<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} .ms-cui-menu {background-color:#ffffff;border:1px rgb(171, 171, 171) solid;font-family:'Segoe UI WPC', 'Segoe UI', Tahoma, 'Microsoft Sans Serif', Verdana, sans-serif;font-size:11pt;color:rgb(51, 51, 51);} .ms-cui-menusection-title {display:none;} .ms-cui-ctl {vertical-align:text-top;text-decoration:none;color:rgb(51, 51, 51);} .ms-cui-ctl-on {background-color:rgb(223, 237, 250);opacity: 0.8;} .ms-cui-img-cont-float {display:inline-block;margin-top:2px} .ms-cui-smenu-inner {padding-top:0px;} .ms-owa-paste-option-icon {margin: 2px 4px 0px 4px;vertical-align:sub;padding-bottom: 2px;display:inline-block;} .ms-rtePasteFlyout-option:hover {background-color:rgb(223, 237, 250) !important;opacity:1 !important;} .ms-rtePasteFlyout-option {padding:8px 4px 8px 4px;outline:none;} .ms-cui-menusection {float:left; width:85px;height:24px;overflow:hidden}--></style>
</head>
<body>
<div style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Steven,</p>
<p><br>
</p>
<p>Thanks for this. This is indeed a bug, I've replicated this, and I have made a ticket here =><br>
</p>
<p><a href="https://www.pivotaltracker.com/story/show/67289478">https://www.pivotaltracker.com/story/show/67289478</a><br>
</p>
<p><br>
</p>
<p>MySQL needs to be explicitly told to perform a cascade delete, so that all the children are deleted with the parent. This slipped through because the test suite runs on derby. Will get a fix in for this for an upcoming release...<br>
</p>
<p><br>
</p>
<p>The work around now is to delete the children first then the parent. <br>
</p>
<p>Apologize about the inconvenience. <br>
</p>
<p><br>
</p>
<p>Thanks again! very much appreciated. <br>
</p>
<p><br>
</p>
<p>best, chris fitzpatrick <br>
</p>
<p><br>
</p>
<div>
<p><br>
</p>
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | chris.fitzpatrick@lyrasis.org<br>
Developer, ArchivesSpace<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
<div style="color: #282828;">
<hr tabindex="-1" style="display: inline-block; width: 98%;">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size: 11pt;"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Steven Majewski
<sdm7g@virginia.edu><br>
<b>Sent:</b> Monday, March 10, 2014 9:55 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Subject:</b> [Archivesspace_Users_Group] Can't delete guide under mysql: foreign key constraint.</font>
<div> </div>
</div>
<div>
<div><br>
</div>
<div>With ArchivesSpace 1.0.7.1 using mysql, I Imported an EAD guide and then tried to delete it. </div>
<div><br>
</div>
<div>If I try to delete the collection from the View of Edit page, I get:</div>
<div><br>
</div>
<div>
<h1 style="font-size: 16px; color: #ff0000; line-height: 1.5em; font-family: arial, sans-serif; text-align: center; background-color: #ffffff; position: static; z-index: auto;">
We're sorry, but something went wrong.</h1>
<div><br>
</div>
</div>
<div><br>
</div>
<div>If I try to delete my checking it in the browse page and clicking delete, I get:</div>
<div><br>
</div>
<div><span style="color: #b94a48; font-family: 'helvetica neue', helvetica, arial, sans-serif; font-size: 13px; line-height: 20px; background-color: #f2dede;">Unable to delete records:</span><br style="color: #b94a48; font-family: 'helvetica neue', helvetica, arial, sans-serif; font-size: 13px; line-height: 20px;">
<span style="color: #b94a48; font-family: 'helvetica neue', helvetica, arial, sans-serif; font-size: 13px; line-height: 20px; background-color: #f2dede;">["{\"error\":\"Record deletion failed: Java::ComMysqlJdbcExceptionsJdbc4::MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails (`archivesspace/archival_object`, CONSTRAINT `archival_object_ibfk_5` FOREIGN KEY (`parent_id`) REFERENCES `archival_object` (`id`))\"}\n"] [/repositories/2/resources/3719]</span></div>
<div><br>
</div>
<div>I was finally able to delete the collection only after individually deleting all of it’s components. </div>
<div><br>
</div>
<div>I tried with another install of 1.0.7.1 on my laptop, using the development db instead of mysql.</div>
<div>I imported EAD and then deleted the top level collection with no problem. </div>
<div>Then I reconfigured it to use mysql, and I get the same errors as above. </div>
<div><br>
</div>
<div>— Steve Majewski</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</div>
</body>
</html>