<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
  </head>
  <body>
    <p>If the system isn't currently connected to the MySQL database,
      then it is likely it wasn't when the <a href="https://archivesspace.github.io/tech-docs/administration/upgrading.html#run-the-database-migrations">data
        migrations script</a> was run. If so, that will need to be
      (re-)run once config.rb has been set up with the correct db_url.
      Once it has been, searching both PUI and staff interface won't
      find anything until a <a moz-do-not-send="true" href="https://archivesspace.github.io/tech-docs/administration/indexes.html">full
        re-index</a> has been done.<br>
    </p>
    <p><br>
    </p>
    <p>Andrew.</p>
    <p><br>
    </p>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 14/07/2021 21:21, Blake Carver
      wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:DM6PR22MB2309ED97B38C4E5A73833DA89F139@DM6PR22MB2309.namprd22.prod.outlook.com">
      
      <style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        It's hard to know for sure what's going on with this.</div>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        You were running 1.3 with MySQL and everything was fine?</div>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        They did the upgrade, you login and see everything is gone and
        it's running on Apache Derby... EEK!</div>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        You let them know, they connect it to MySQL again and now it's
        in this state.</div>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        So they probably hooked you up with your old 1.3 DB that has
        been upgraded to 2.8.1. </div>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        Or maybe it's set to talk to the wrong DB, and it's empty. If
        it's empty, maybe they have a backup of the old DB?</div>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        My guess is that they brought over the /data/ directory. That
        directory has all the solr stuff in it, and if they did bring
        that over, things are likely in this weird state.</div>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        I'd start by asking them a couple of questions</div>
      <div style="font-family: Calibri, Arial, Helvetica, sans-serif;
        font-size: 12pt; color: rgb(0, 0, 0);">
        <ol>
          <li><span>Did they indeed hook you back to the old db that is
              now upgraded? Are they sure the config is updated to talk
              to the right DB? They should be able to search the DB
              directly to see what's in there. </span></li>
          <li>Did they copy over all the stuff in /data/ ? If so, you
            don't want all that stuff. Tell them to empty that directory
            and restart it.</li>
        </ol>
      </div>
      <div>
        <div id="Signature">
          <div>
            <div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0);
              background-color:rgb(255,255,255)">
            </div>
          </div>
        </div>
      </div>
      <hr style="display:inline-block;width:98%" tabindex="-1">
      <div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b>
          <a class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
          <a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a>
          on behalf of Merryman, Ann <a class="moz-txt-link-rfc2396E" href="mailto:MERRYMAA@uscupstate.edu"><MERRYMAA@uscupstate.edu></a><br>
          <b>Sent:</b> Wednesday, July 14, 2021 4:02 PM<br>
          <b>To:</b> Archivesspace Users Group
          <a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group@lyralists.lyrasis.org"><archivesspace_users_group@lyralists.lyrasis.org></a><br>
          <b>Subject:</b> [Archivesspace_Users_Group] Unable to edit /
          delete accessions or resources after upgrade to MySQL database</font>
        <div> </div>
      </div>
      <style>@font-face
        {font-family:Helvetica}@font-face
        {font-family:Wingdings}@font-face
        {font-family:"Cambria Math"}@font-face
        {font-family:Calibri}@font-face
        {font-family:Garamond}p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif}a:link, span.x_MsoHyperlink
        {color:#0563C1;
        text-decoration:underline}a:visited, span.x_MsoHyperlinkFollowed
        {color:#954F72;
        text-decoration:underline}p.x_MsoListParagraph, li.x_MsoListParagraph, div.x_MsoListParagraph
        {margin-top:0in;
        margin-right:0in;
        margin-bottom:0in;
        margin-left:.5in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri",sans-serif}span.x_EmailStyle17
        {font-family:"Calibri",sans-serif;
        color:windowtext}.x_MsoChpDefault
        {font-family:"Calibri",sans-serif}div.x_WordSection1
        {}ol
        {margin-bottom:0in}ul
        {margin-bottom:0in}</style>
      <div link="#0563C1" vlink="#954F72" lang="EN-US">
        <div class="x_WordSection1">
          <p class="x_MsoNormal">Good afternoon hive mind…long time
            lurker, first time writer. 
            <span style="font-family:Wingdings">J</span>  I’m going to
            try to make this question concise:
          </p>
          <p class="x_MsoNormal"> </p>
          <p class="x_MsoListParagraph" style="text-indent:-.25in"><span style="font-family:Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">       
                </span></span></span>I have just been upgraded to v2.8.1
            (from v1.3.0…don’t judge!  Lol) on a locally-hosted instance
            of AS, managed by my university’s IT department.
          </p>
          <p class="x_MsoListParagraph" style="text-indent:-.25in"><span style="font-family:Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">       
                </span></span></span>When my instance was upgraded, I
            got the following warning message:
          </p>
          <p class="x_MsoNormal"><b><span style="font-size:10.5pt;
                font-family:"Helvetica",sans-serif;
                color:#8A6D3B; background:#FCF8E3">Database Warning:</span></b><span style="font-size:10.5pt;
              font-family:"Helvetica",sans-serif;
              color:#8A6D3B; background:#FCF8E3"> You are currently
              using the embedded database (Apache Derby). The embedded
              database is for testing/demo purposes only. You should use
              MySQL for any data intended for production, including data
              in a test instance that you intend to move over to a
              production instance.</span><span style="color:#1F497D"></span></p>
          <p class="x_MsoNormal"><span style="color:#1F497D"> </span></p>
          <p class="x_MsoListParagraph" style="margin-left:38.5pt;
            text-indent:-.25in"><span style="font-family:Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt
                  "Times New Roman"">       
                </span></span></span>The vendor let us know that there
            were not any upgrade paths from the demo database to MySQL,
            and the information would have to be re-entered (this is
            fine, as I had backed up everything and could re-enter)</p>
          <p class="x_MsoListParagraph" style="margin-left:38.5pt;
            text-indent:-.25in"><span style="font-family:Symbol"><span style="mso-list:Ignore">·<span style="font:7.0pt
                  "Times New Roman"">       
                </span></span></span>Once IT built the MySQL database,
            however, all the accession and resource records  actually
            showed up.  ??? 
          </p>
          <p class="x_MsoNormal"> </p>
          <p class="x_MsoNormal">The problem is, while I can *<b>see</b>*
            the records on the back end, I can’t edit or delete them. 
            However, they are visible and searchable on the PUI.  I’ve
            attached a few images for reference. 
          </p>
          <p class="x_MsoNormal"> </p>
          <p class="x_MsoNormal">I’m trying to determine what the best
            course of action might be before I go back to my IT
            department, as I’m going to have to explain what the issue
            is to them as best I can (they’re not really familiar with
            AS or archival processes, unfortunately).  I’m not clear on
            why the data pulled over if there wasn’t a path, and I’m not
            tech savvy enough to guess at what my IT department did.  I
            could also email AS tech support, but I thought I’d start
            here to see if anyone has seen this or has something to try
            first.  </p>
          <p class="x_MsoNormal"> </p>
          <p class="x_MsoNormal">Any thoughts or suggestions from the
            group would be greatly appreciated, or even just sympathetic
            noises. 
            <span style="font-family:Wingdings">J</span>  </p>
          <p class="x_MsoNormal"> </p>
          <p class="x_MsoNormal">Thanks so much,</p>
          <p class="x_MsoNormal"> </p>
          <p class="x_MsoNormal">Ann    </p>
          <p class="x_MsoNormal"> </p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060">“For the things we have to learn before we
              can do them, we learn by doing them.” ~ Aristotle</span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060"> </span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060">Ann E. Merryman, MLIS</span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060">Associate Librarian</span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060">Coordinator of Archives and Special
              Collections</span><span style="color:#002060"></span></p>
          <p class="x_MsoNormal"><span style="color:#002060"><img id="x_Picture_x0020_1" style="width:1.825in;
                height:.9166in" data-outlook-trace="F:1|T:1" src="cid:part3.4DF38643.B83AEDA1@bodleian.ox.ac.uk" class="" width="175" height="88"></span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060">USC Upstate, Library 263</span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060">800 University Way</span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060">Spartanburg, SC 29303</span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060">Office:  864-503-5275</span></p>
          <p class="x_MsoNormal"><span style="font-family:"Garamond",serif;
              color:#002060"><a class="moz-txt-link-abbreviated" href="mailto:merrymaa@uscupstate.edu">merrymaa@uscupstate.edu</a></span></p>
          <p class="x_MsoNormal"> </p>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Archivesspace_Users_Group mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a>
<a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a>
</pre>
    </blockquote>
  </body>
</html>