<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body>
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 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 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_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:#0563C1;
text-decoration:underline}
span.x_EmailStyle20
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72" 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_tg
{border-collapse:collapse;
border-spacing:0}
.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_tg td a
{color:rgb(255,255,255)}
.x_tg td a:visited
{color:rgb(255,255,255)}
.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_tg .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_tg">
<tbody>
<tr>
<td class="x_tg-4n1y">This email originated from outside ECU.</td>
</tr>
</tbody>
</table>
<br>
<div>
<div class="x_WordSection1">
<p class="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_MsoNormal">--Benn</p>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="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_MsoNormal"> </p>
<p class="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_MsoNormal"> </p>
<p class="x_MsoNormal">-Valerie</p>
<p class="x_MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="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_MsoNormal"> </p>
<div>
<p class="x_MsoNormal"><span style="font-family:HelveticaNeue">Hi team,</span> </p>
<div>
<p class="x_MsoNormal"><span style="font-family:HelveticaNeue"> </span></p>
</div>
<div>
<p class="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_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_MsoNormal"><span style="font-family:HelveticaNeue"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-family:HelveticaNeue">Nick crimi </span></p>
</div>
<p class="x_MsoNormal"><span style="font-family:HelveticaNeue">East Carolina University </span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>