<div dir="ltr">I downloaded AS v 3.0.1 in my test environment in order to get AS working like in production prior to attempting the upgrade. The error is in the test environment, production is fine. I ran the setup-database script in test, no errors. I then tried to run AS in test, but I'm getting the wrong schema error. The error states that the schema for the DB is at is 153, but I don't see that schema number on the list you provided, so I'm supposing perhaps I downloaded the wrong version of AS, but I'm not sure what version I should be using.<div><br></div><font face="monospace">ArchivesSpace has encountered a problem with your database schema info version.<br><br>The schema info version should be 147 for ArchivesSpace version v3.0.1.<br> However, your schema info version is set at 153<br>Please ensure your migrations have been run and completed by using the setup-database script.</font></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 29, 2023 at 12:21 PM Blake Carver <<a href="mailto:blake.carver@lyrasis.org">blake.carver@lyrasis.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg7545520418250404035">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
"The schema info version should be 147 for ArchivesSpace version v3.0.1."</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I think you're missing part of the error, so I'm not sure if you're ahead or behind on that. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
That error is from the test env?</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
You have 3.4 on the test env? Did you run the setup-database script? That's usually the problem.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Every release has a schema version:</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<a href="https://github.com/archivesspace/tech-docs/blob/master/development/releases.md" target="_blank">https://github.com/archivesspace/tech-docs/blob/master/development/releases.md</a><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
(that's a bit behind the times I see)</div>
<div id="m_7693719265912522410Signature">
<div>
<div id="m_7693719265912522410divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0);background-color:rgb(255,255,255)">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" style="color:black"><span dir="ltr" style="font-size:12pt;background-color:white"><font size="2"><span style="font-size:11pt"><br>
</span></font></span></font></div>
</div>
</div>
</div>
</div>
<div id="m_7693719265912522410appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="m_7693719265912522410divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of Ludwig Possie
<<a href="mailto:ludwigpossie@weber.edu" target="_blank">ludwigpossie@weber.edu</a>><br>
<b>Sent:</b> Thursday, June 29, 2023 12:52 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] Database schema mismatch</font>
<div> </div>
</div>
<div>
<div dir="ltr">I'm trying to upgrade our version of Archivesspace and I have created a test environment in a virtual machine. When I import the database from production and I attempt to run AS, I get a database migration error, "The schema info version should
be 147 for ArchivesSpace version v3.0.1." I ran the database migration script "setup-database.sh" and it seems to have ran without issues, but I'm still getting the above-mentioned error when I attempt to run AS. I was told that we are currently running
AS v3.0.1. I'm supposing that the DB schema differs from different versions of AS. Am I missing a step or something? I would appreciate any advice anyone can provide. Thx.
<div><br>
</div>
<div><br>
<div><span>-- </span><br>
<div dir="ltr">
<div dir="ltr">Ludwig Possié
<div><font size="1">Systems Admin</font></div>
<div><font size="1">Stewart Library</font></div>
<div><font size="1">Weber State University</font></div>
<div><font size="1">801-626-8093</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</div></blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr">Ludwig Possié<div><font size="1">Systems Admin</font></div><div><font size="1">Stewart Library</font></div><div><font size="1">Weber State University</font></div><div><font size="1">801-626-8093</font></div></div></div>