<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body>
<div dir="auto">Thank you! I had to drop many tables and the upgrade got to migration 158. It wanted me to delete the ark_uniq_check table. Now it says I have an unknown column external _ark_url in the field list. My g<span>uess is that a row has illegal characters?
How do I track down the bad apple?</span></div>
<div id="mail-editor-reference-message-container" dir="auto"><br>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" style="font-size: 11pt;"><strong>From:</strong> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Blake Carver <blake.carver@lyrasis.org><br>
<strong>Sent:</strong> Friday, May 19, 2023, 10:17 AM<br>
<strong>To:</strong> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<strong>Subject:</strong> Re: [Archivesspace_Users_Group] Database migration error creating table<br>
</div>
<br>
<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; background-color: rgb(166, 166, 166);">
</td>
<td valign="middle" width="100%" bgcolor="#EAEAEA" cellpadding="7px 5px 7px 15px" color="#212121" style="width: 100%; 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; text-align: left; overflow-wrap: break-word; background-color: rgb(234, 234, 234); color: rgb(33, 33, 33);">
<div>You don't often get email from blake.carver@lyrasis.org. <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; padding: 7px 5px; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 12px; font-weight: normal; text-align: left; overflow-wrap: break-word; background-color: rgb(234, 234, 234); color: rgb(33, 33, 33);">
</td>
</tr>
</tbody>
</table>
<div>
<table class="tg" style="border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td class="tg-4n1y" style="font-family: Arial, sans-serif; padding: 1px; border-style: solid; border-width: 1px; overflow: hidden; word-break: normal; font-size: x-small; border-color: inherit; text-align: left; vertical-align: top;">
This email originated from outside ECU.</td>
</tr>
</tbody>
</table>
<br>
<div>
<div class="elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Your DB is in a bad place. </div>
<div class="elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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 class="elementToProof" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Make sure you do this on a COPY of the DB and not the live site.</div>
<div class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
drop table lang_material</div>
<div class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
./scripts/setup-database.sh</div>
<div class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
it will probably fail with another "already exists" error</div>
<div class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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 class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Keep doing that until it finishes up. There will be probably 4 or 5.</div>
<div class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hopefully that'll do the trick and the DB isn't messed up in any other ways.</div>
<div class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
You may also need to delete some enumeration values in there also.</div>
<div class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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 class="elementToProof ContentPasted0" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="appendonsend"></div>
<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 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>
<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; background-color: rgb(166, 166, 166);">
</td>
<td valign="middle" width="100%" bgcolor="#EAEAEA" cellpadding="7px 5px 7px 15px" color="#212121" style="width: 100%; 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; text-align: left; overflow-wrap: break-word; background-color: rgb(234, 234, 234); color: rgb(33, 33, 33);">
<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; padding: 7px 5px; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 12px; font-weight: normal; text-align: left; overflow-wrap: break-word; background-color: rgb(234, 234, 234); color: rgb(33, 33, 33);">
</td>
</tr>
</tbody>
</table>
<div>
<table class="x_x_tg" style="border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td class="x_x_tg-4n1y" style="font-family: Arial, sans-serif; padding: 1px; border-style: solid; border-width: 1px; overflow: hidden; word-break: normal; font-size: x-small; border-color: inherit; text-align: left; vertical-align: top;">
This email originated from outside ECU.</td>
</tr>
</tbody>
</table>
<br>
<div>
<div class="x_x_WordSection1">
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
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" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
--Benn</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<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" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
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" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
-Valerie</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<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" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<div>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="font-family:HelveticaNeue">Hi team,</span> </p>
<div>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="font-family:HelveticaNeue"> </span></p>
</div>
<div>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<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" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<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" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="font-family:HelveticaNeue"> </span></p>
</div>
<div>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="font-family:HelveticaNeue">Nick crimi </span></p>
</div>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="font-family:HelveticaNeue">East Carolina University </span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</body>
</html>