<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Your DB is in a bad place. </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
It has tables from the failed upgrade, so every time you try to run it again it sees those tables and says "nope, can't keep going, you have this one already"</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Make sure you do this on a COPY of the DB and not the live site.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
drop table lang_material</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
./scripts/setup-database.sh</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
it will probably fail with another "already exists" error</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
now drop lang_material AND that new one. You'll need to drop both because they get recreated each time you run setup again.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Keep doing that until it finishes up. There will be probably 4 or 5.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
Hopefully that'll do the trick and the DB isn't messed up in any other ways.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
You may also need to delete some enumeration values in there also.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
ArchivesSpace expects certain things to be in certain places, and certain other things to NOT be in certain places when upgrading, if the upgrade fails only some of those things are in the right place, so it can't get past that weird state.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof ContentPasted0">
<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Crimi, Nick
<CRIMIN@ecu.edu><br>
<b>Sent:</b> Thursday, May 18, 2023 4:17 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Database migration error creating table</font>
<div> </div>
</div>
<div>Thank you! I tried running the setup database script for 2.7.0 and 2.7.1. Both want to create the lang_material table but it already exists.
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_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 Benn Joseph
<benn.joseph@northwestern.edu><br>
<b>Sent:</b> Thursday, May 18, 2023 3:43:28 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Database migration error creating table</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:HelveticaNeue}
p.x_x_MsoNormal, li.x_x_MsoNormal, div.x_x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
span.x_x_EmailStyle20
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
-->
</style>
<div lang="EN-US" style="word-wrap:break-word">
<table border="0" cellspacing="0" cellpadding="0" width="100%" align="left" style="border:0; display:table; width:100%; table-layout:fixed; border-collapse:seperate; float:none">
<tbody style="display:block">
<tr>
<td valign="middle" width="1px" bgcolor="#A6A6A6" cellpadding="7px 2px 7px 2px" style="padding:7px 2px 7px 2px; background-color:#A6A6A6">
</td>
<td valign="middle" width="100%" bgcolor="#EAEAEA" cellpadding="7px 5px 7px 15px" color="#212121" style="width:100%; background-color:#EAEAEA; padding:7px 5px 7px 15px; font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial,sans-serif; font-size:12px; font-weight:normal; color:#212121; text-align:left; word-wrap:break-word">
<div>You don't often get email from benn.joseph@northwestern.edu. <a href="https://aka.ms/LearnAboutSenderIdentification">
Learn why this is important</a></div>
</td>
<td valign="middle" align="left" width="75px" bgcolor="#EAEAEA" cellpadding="7px 5px 7px 5px" color="#212121" style="width:75px; background-color:#EAEAEA; padding:7px 5px 7px 5px; font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial,sans-serif; font-size:12px; font-weight:normal; color:#212121; text-align:left; word-wrap:break-word">
</td>
</tr>
</tbody>
</table>
<div><style type="text/css">
<!--
.x_x_tg
{border-collapse:collapse;
border-spacing:0}
.x_x_tg td
{font-family:Arial,sans-serif;
font-size:10px;
padding:1px 1px;
border-style:solid;
border-width:1px;
overflow:hidden;
word-break:normal;
border-color:black}
.x_x_tg td a
{color:rgb(255,255,255)}
.x_x_tg td a:visited
{color:rgb(255,255,255)}
.x_x_tg th
{font-family:Arial,sans-serif;
font-size:10px;
font-weight:normal;
padding:1px 1px;
border-style:solid;
border-width:1px;
overflow:hidden;
word-break:normal;
border-color:black}
.x_x_tg .x_x_tg-4n1y
{font-size:x-small;
background-color:#592A8A;
border-color:inherit;
text-align:left;
vertical-align:top;
color:rgb(255,255,255)}
-->
</style>
<table class="x_x_tg">
<tbody>
<tr>
<td class="x_x_tg-4n1y">This email originated from outside ECU.</td>
</tr>
</tbody>
</table>
<br>
<div>
<div class="x_x_WordSection1">
<p class="x_x_MsoNormal">Wasn’t there also a version somewhere around 2.7 where the data model changed re: languages? I remember having to upgrade to 2.7 (and running some sort of tool) before going to 2.8, a couple of upgrades ago.</p>
<p class="x_x_MsoNormal">--Benn</p>
<p class="x_x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_x_MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Valerie Addonizio<br>
<b>Sent:</b> Thursday, May 18, 2023 2:27 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Database migration error creating table</p>
</div>
</div>
<p class="x_x_MsoNormal"> </p>
<p class="x_x_MsoNormal">Nick I’m not sure it’s related, but aspace-import-excel (the plugin) was added to core code as of 2.8.0, so you can drop that plugin and enjoy that functionality without it.</p>
<p class="x_x_MsoNormal"> </p>
<p class="x_x_MsoNormal">-Valerie</p>
<p class="x_x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_x_MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Crimi, Nick<br>
<b>Sent:</b> Thursday, May 18, 2023 3:10 PM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Database migration error creating table</p>
</div>
</div>
<p class="x_x_MsoNormal"> </p>
<div>
<p class="x_x_MsoNormal"><span style="font-family:HelveticaNeue">Hi team,</span> </p>
<div>
<p class="x_x_MsoNormal"><span style="font-family:HelveticaNeue"> </span></p>
</div>
<div>
<p class="x_x_MsoNormal"><span style="font-family:HelveticaNeue">My library is trying to upgrade AS from 2.51 to 3.3.1. We are using mysql for the dB and aspace-import-excel is enabled for plug-in.</span></p>
</div>
<div>
<p class="x_x_MsoNormal"><span style="font-family:HelveticaNeue">The dB migration throws an error that table lang_material already exists. Please let me know how to complete the upgrade. Maybe I need to upgrade to the latest 2.x version first?</span></p>
</div>
<div>
<p class="x_x_MsoNormal"><span style="font-family:HelveticaNeue"> </span></p>
</div>
<div>
<p class="x_x_MsoNormal"><span style="font-family:HelveticaNeue">Nick crimi </span></p>
</div>
<p class="x_x_MsoNormal"><span style="font-family:HelveticaNeue">East Carolina University </span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>