<div dir="ltr"><div><div><div><div>Hi All,<br><br></div>Just to clarify, after I encountered the error I did: <br><br></div>DROP DATABASE 2.1.2_dev<br>CREATE DATABASE 2.1.2_dev default character set utf8;<br><br></div><code>$ mysqldump 2.0.1_live > 2.0.1_live.sql<br></code></div><code>$ mysql 2.1.2_dev < 2.0.1_live.sql</code><br><pre class="gmail-m_-4042696031442669473gmail-highlight"><code>$ cd archivesspace-2.1.2\<wbr>archivesspace
$ scripts\setup-database.sh<br><br>rights_statement_pre_088 still exists. <br><br></code></pre><pre class="gmail-m_-4042696031442669473gmail-highlight"><code>- Chelsea<br></code></pre></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><span style="color:rgb(128,128,128)"><em><span style="font-size:small">---------------</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small">Chelsea Lobdell</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small">Library Web Developer/ Swarthmore College</span></em></span><br><span style="color:rgb(128,128,128)"><em><span style="font-size:small"><a href="mailto:clobdel1@swarthmore.edu" target="_blank">clobdel1@swarthmore.edu</a> / (610)690-6818</span></em></span></div></div></div></div>
<br><div class="gmail_quote">On Tue, Sep 19, 2017 at 2:44 PM, Lora Woodford <span dir="ltr"><<a href="mailto:lwoodford@jhu.edu" target="_blank">lwoodford@jhu.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div class="m_-8385770801550777523WordSection1">
<p class="MsoNormal"><span style="color:#1f497d">Heya, Christine/all,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">We haven’t upgraded yet, but I have a few 2.1.2 local test instances running with our production data in them to do some testing/api script rewrites in advance of upgrading. I can confirm that I have seen this
non-utf8 error message multiple times (but have ignored it since it didn’t impede my testing and aspace still booted up fine).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">But, yes, I’ve seen this warning.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Lora<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-<wbr>bounces@lyralists.lyrasis.org</a> [mailto:<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_<wbr>group-bounces@lyralists.<wbr>lyrasis.org</a>]
<b>On Behalf Of </b>Christine Di Bella<br>
<b>Sent:</b> Tuesday, September 19, 2017 2:39 PM<span class=""><br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@<wbr>lyralists.lyrasis.org</a>><br>
</span><b>Subject:</b> Re: [Archivesspace_Users_Group] DB Migration Question<u></u><u></u></p>
</div>
</div><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hi Chelsea,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Version 2.1 of ArchivesSpace included an expanded rights statements module and setup-database has a data migration to move previous rights data to the new model (migration 088). The purpose of the rights_statement_pre_088 table is to serve
as a backup of your previous rights statement data in case you find that your rights data did not migrate as expected. It is not needed if you’re happy with the way the data migrated.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">As to why ArchivesSpace would throw an error saying it was not set to UTF8, I would be curious if anyone else has experienced that during or post-upgrade. We have not heard of that occurring previously.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Christine<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1f497d">Christine Di Bella<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1f497d">ArchivesSpace Program Manager<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1f497d"><a href="mailto:christine.dibella@lyrasis.org" target="_blank"><span style="color:#0563c1">christine.dibella@lyrasis.org</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1f497d"><a href="tel:(800)%20999-8558" value="+18009998558" target="_blank">800.999.8558 x2905</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1f497d"><a href="tel:(678)%20235-2905" value="+16782352905" target="_blank">678-235-2905</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1f497d">cdibella13 (Skype)</span><span style="color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><img id="m_-8385770801550777523Picture_x0020_1" src="cid:image001.jpg@01D33155.BBF03860" alt="ASpaceOrgHomeMedium" width="267" border="0" height="61"><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">
archivesspace_users_group-<wbr>bounces@lyralists.lyrasis.org</a> [<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">mailto:archivesspace_users_<wbr>group-bounces@lyralists.<wbr>lyrasis.org</a>]
<b>On Behalf Of </b>Chelsea Lobdell<br>
<b>Sent:</b> Tuesday, September 19, 2017 2:25 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@<wbr>lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] DB Migration Question<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Aspace! <u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I just upgraded our instance of Archivesspace from v2.0.1 to v2.1.2 on our development server.
<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">After running setup-database.sh to migrate the data I noticed an odd table in the database called rights_statement_pre_088.<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">The application starts up and runs fine but recently a staff member was editing labels in en.yml and config.rb for the new PUI and had to force a re-index. After the re-index, Archivesspace was complaining that
rights_statement_pre_088 was not set to use UTF8 for its character encoding. <u></u>
<u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I was able to resolve the issue by dropping and then re-creating our dev DB from our live DB but I am curious about rights_statement_pre_088. The table still exists though no errors are currently being thrown.
<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Has anyone else encountered this or have any advice?
<u></u><u></u></p>
</div>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
</div>
<p class="MsoNormal">Chelsea <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-size:12.0pt;color:gray">---------------</span></i><br>
<i><span style="font-size:12.0pt;color:gray">Chelsea Lobdell</span></i><br>
<i><span style="font-size:12.0pt;color:gray">Library Web Developer/ Swarthmore College</span></i><br>
<i><span style="font-size:12.0pt;color:gray"><a href="mailto:clobdel1@swarthmore.edu" target="_blank">clobdel1@swarthmore.edu</a> / <a href="tel:(610)%20690-6818" value="+16106906818" target="_blank">(610)690-6818</a></span></i><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@<wbr>lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/<wbr>mailman/listinfo/<wbr>archivesspace_users_group</a><br>
<br></blockquote></div><br></div>