<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p>Hi Jason,</p>
<p><br>
</p>
<p>No, I assuming this seems to be particular to your install. What most likely happened is that a previous migration did not complete and you're database was left in a state that was in an uncompleted state. Removing the tables in your case allowed for the
migration to continue.You can check the value in the schema_info table, which should be 59 in 1.4.0. </p>
<p><br>
</p>
<p>b,chris. <br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Jason Loeffler
<j@minorscience.com><br>
<b>Sent:</b> Tuesday, October 13, 2015 8:18 PM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Cc:</b> Lisette Gonzalez<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Migration from 1.2 to 1.4</font>
<div> </div>
</div>
<div>
<div dir="ltr">Can you confirm that the upgrade process entail removing the telephone, rde_temple, and default_values tables before running the setup-database script? I'd like to confirm whether or not this is a bug or isolated to our specific ASpace instance. <br>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature">
<div dir="ltr">
<div>
<div><font style="background-color:rgb(255,255,255)" face="garamond, serif" color="#666666" size="2">Jason Loeffler</font></div>
<div><font style="background-color:rgb(255,255,255)" face="garamond, serif" color="#666666" size="2">Principal</font></div>
<div><font style="background-color:rgb(255,255,255)" face="garamond, serif" color="#666666" size="2">Minor Science | Application Development & Metadata Strategy</font></div>
<div><font style="background-color:rgb(255,255,255)" face="garamond, serif" color="#666666" size="2">Brooklyn, New York</font></div>
</div>
<div><br>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Thu, Oct 8, 2015 at 9:50 PM, Jason Loeffler <span dir="ltr">
<<a href="mailto:j@minorscience.com" target="_blank">j@minorscience.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div>
<div>Hi Chris, </div>
<div><br>
</div>
<div>As a workaround, I simply removed those three tables, ran the script, and the three tables were created. Is this a known issue with the upgrade process? </div>
<div><br>
</div>
<div>Jason<br>
<br>
<div></div>
<br>
</div>
</div>
<div class="gmail_quote">_____________________________<br>
From: Chris Fitzpatrick <<a dir="ltr" href="mailto:chris.fitzpatrick@lyrasis.org" target="_blank">chris.fitzpatrick@lyrasis.org</a>><br>
Sent: Thursday, October 8, 2015 3:41 PM<br>
Subject: Re: [Archivesspace_Users_Group] Migration from 1.2 to 1.4<br>
To: Archivesspace Users Group <<a dir="ltr" href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
Cc: Lisette Gonzalez <<a dir="ltr" href="mailto:l.gonzalez@aarome.org" target="_blank">l.gonzalez@aarome.org</a>><br>
<br>
<br>
<div style="font-size:12pt; color:#000000; background-color:#ffffff; font-family:Calibri,Arial,Helvetica,sans-serif">
<p><br>
</p>
<p><br>
</p>
<p>Hi Jason,</p>
<p><br>
</p>
<p>After you ran the setup-database script, did the telephone, rde_template, and default_value tables get created? </p>
<p>If so, you should be good if the schema_info table has a value 59. </p>
<p><br>
</p>
<p>best,chris. <br>
</p>
<p><br>
</p>
<p><br>
</p>
<div>
<div>
<div><font size="2">
<div>Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font> <br>
Skype: chrisfitzpat | Phone: <a dir="ltr" href="tel:918.236.6048" target="_blank">
918.236.6048</a> <br>
<a dir="ltr" href="http://archivesspace.org/" target="_blank">http://archivesspace.org/</a>
<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr style="display:inline-block; width:98%">
<div dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b>
<a dir="ltr" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a dir="ltr" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of Jason Loeffler <<a dir="ltr" href="mailto:j@minorscience.com" target="_blank">j@minorscience.com</a>><br>
<b>Sent:</b> Wednesday, October 7, 2015 2:39 AM<br>
<b>To:</b> Archivesspace Users Group<br>
<b>Cc:</b> Lisette Gonzalez<br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Migration from 1.2 to 1.4</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div class="gmail_extra">
<div>
<div>
<div dir="ltr">
<div>I should add that the setup-database.sh script encountered errors against the following tables:
</div>
<div><br>
</div>
<div>telephone </div>
<div>rde_template </div>
<div>default_values </div>
<div><br>
</div>
<div>I temporarily removed these tables from the database and was able to run the upgrade process successfully.
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Tue, Oct 6, 2015 at 7:59 PM, Jason Loeffler <span dir="ltr">
<<a href="mailto:j@minorscience.com" target="_blank">j@minorscience.com</a>></span> wrote:
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div dir="ltr">
<div>Anyone else encounter the following migration error when upgrading from the 1.2 release to 1.4?
</div>
<div><br>
</div>
<div><a href="https://gist.github.com/anonymous/cc3d2ef586a07f3f341e" target="_blank">https://gist.github.com/anonymous/cc3d2ef586a07f3f341e</a>
</div>
<div><br>
</div>
<div>Thanks, Jason </div>
<span><font color="#888888"><br>
<div>
<div>
<div dir="ltr">
<div>
<div><font style="background-color:rgb(255,255,255)" face="garamond, serif" color="#666666" size="2">Jason Loeffler</font>
</div>
<div><font style="background-color:rgb(255,255,255)" face="garamond, serif" color="#666666" size="2">Principal</font>
</div>
<div><font style="background-color:rgb(255,255,255)" face="garamond, serif" color="#666666" size="2">Minor Science | Application Development & Metadata Strategy</font>
</div>
<div><font style="background-color:rgb(255,255,255)" face="garamond, serif" color="#666666" size="2">Brooklyn, New York</font>
</div>
</div>
<div><br>
</div>
</div>
</div>
</div>
</font></span></div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
<br>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</body>
</html>