<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">And then restart ArchivesSpace and try Accession reports again? </div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Actually, more than a hunch now that I googled for this doc:</div><div class=""><br class=""></div><div class=""><a href="https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-F" class="">https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-F</a></div><div class=""><br class=""></div><div class="">And see: </div><div class=""><br class=""></div><div class=""><ul class="itemizedlist" style="box-sizing: inherit; margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; font-size: 14.255999565124512px; vertical-align: baseline; caret-color: rgb(85, 85, 85); color: rgb(85, 85, 85); font-family: "Open Sans", Arial, Helvetica, sans-serif;"><li class="listitem" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; vertical-align: middle; list-style: disc outside none; line-height: 1.75;"><p style="box-sizing: inherit; margin: 0px 0px 15px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; line-height: 1.75;" class=""><code class="literal" style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 13.54319953918457px; vertical-align: baseline; color: rgb(0, 0, 0); font-family: "Courier New", Courier, fixed, monospace;">FUNCTION</code> (R); became reserved in 8.0.1</p></li></ul><div class=""><br class=""></div></div><div class="">Pretty sure that is the problem!</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">— Steve Majewski</div><div class=""><br class=""></div><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Mar 31, 2021, at 2:49 PM, Wendy Scheir <<a href="mailto:scheirw@newschool.edu" class="">scheirw@newschool.edu</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div dir="ltr" class="">Hi Blake,<div class=""><br class=""></div><div class="">Thanks so much for following up. So far, we've gotten report errors for the following 3 accessions reports:</div><div class=""><ul title="" style="margin:10px 0px 0px;padding-left:22px;color:rgb(23,43,77);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Oxygen,Ubuntu,"Fira Sans","Droid Sans","Helvetica Neue",sans-serif;font-size:14px" class=""><li class="">Accession Report</li><li class="">Accession Receipt Report</li><li class=""><span style="color:rgb(51,51,51)" class="">Accessions and Linked Subjects, Names and Classifications</span></li></ul><div class=""><br class=""></div><div class="">I'm not sure if we've tested all of them, but definitely these 3 are erroring out. If you'd like to look at the error logs, I'd be glad to send them to you.</div><div class=""><br class=""></div><div class="">All best,</div><div class="">Wendy</div><div class=""><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div style="font-family: arial; font-size: 10px; padding: 5px 0px 0px 5px; margin: 0px;" class=""><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px" class="">____________________________________</span><span style="color:rgb(232,46,33)" class=""><br class=""></span></div><div style="font-family: arial; padding: 5px 0px 0px 5px; margin: 0px;" class=""><span style="font-size:10px;color:rgb(172,147,110);font-weight:bold" class="">WENDY SCHEIR<br class=""></span><b style="font-size:10px" class=""><font color="#666666" class="">DIRECTOR</font></b><br class=""></div><div style="font-family: arial; padding: 5px 0px 0px 5px; margin: 0px;" class=""><img src="https://docs.google.com/uc?export=download&id=16Nic6T4ZK1k1BhLOUToez7KP5Tzv8f9o&revid=0B4enrSUaFYtfdnV0R3E3bEkvek9LUVdsbkRIVUNJaXh1MU9VPQ" width="420" height="37" style="color:rgb(102,102,102);font-size:10px;margin-right:0px" class=""></div><div style="font-family: arial; padding: 5px 0px 0px 5px; margin: 0px;" class=""><span style="font-size:10px;color:rgb(102,102,102)" class="">66 5TH AVENUE, NEW YORK, NY 10011<br class=""></span><a href="mailto:scheirw@newschool.edu" style="font-size:10px;color:rgb(102,102,102)" target="_blank" class="">scheirw@newschool.edu</a></div><div style="padding: 5px 0px 0px 5px; margin: 0px;" class=""><span style="font-family: arial; font-size: 10px; font-weight: bold;" class="">T</span><span style="font-family:arial;font-size:10px;color:rgb(102,102,102)" class=""> 212.229.5942 x2888</span></div><div style="font-family: arial; font-size: 10px; padding: 10px 0px 0px 5px; margin: 0px;" class=""><a href="http://library.newschool.edu/archives" style="color:rgb(172,147,110);font-size:11px" target="_blank" class="">Explore the Archives</a> <span style="" class="">| </span><a href="http://digitalarchives.library.newschool.edu/" style="color:rgb(172,147,110);font-size:11px" target="_blank" class="">Digital Collections from the Archives</a> <span style="" class="">| </span><a href="http://newschoolhistories.org/" style="color:rgb(172,147,110);font-size:11px" target="_blank" class="">New School Histories</a> <font class="">|</font> <a href="https://twitter.com/tnsarchives" style="color:rgb(172,147,110);font-size:11px" target="_blank" class="">@tnsarchives</a></div><div class=""><div class=""><p style="vertical-align:baseline;outline-width:0px;margin:0in 0in 0.0001pt" class=""><font color="#999999" face="Arial, sans-serif" size="1" class=""><span style="line-height:18px" class=""></span></font></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Mar 31, 2021 at 2:33 PM Blake Carver <<a href="mailto:blake.carver@lyrasis.org" class="">blake.carver@lyrasis.org</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr" class="">
<div style="" class=""><font face="Calibri, Arial, Helvetica, sans-serif" class="">There are others</font><span style="font-size:14px" class=""> running
on 8, so far the only trouble seems to be reports. Here's a JIRA</span><br class="">
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;" class="">
<span style="font-size:14px;background-color:rgb(255,255,255);display:inline" class=""><a href="https://archivesspace.atlassian.net/jira/software/c/projects/ANW/issues/ANW-1200" target="_blank" class="">https://archivesspace.atlassian.net/jira/software/c/projects/ANW/issues/ANW-1200</a><br class="">
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;" class="">
You're seeing it fail on two reports?</div>
<div class="">
<div id="gmail-m_-8106573045910109163Signature" class="">
<div class="">
<div id="gmail-m_-8106573045910109163divtagdefaultwrapper" dir="ltr" style="background-color: rgb(255, 255, 255);" class="">
</div>
</div>
</div>
</div>
<div id="gmail-m_-8106573045910109163appendonsend" class=""></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;" class="">
<br class="">
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;" class="">
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;" class="">
<br class="">
</div>
<hr style="display:inline-block;width:98%" class="">
<div id="gmail-m_-8106573045910109163divRplyFwdMsg" dir="ltr" class=""><font face="Calibri, sans-serif" style="font-size:11pt" class=""><b class="">From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank" class="">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>> on behalf of Wendy Scheir
<<a href="mailto:scheirw@newschool.edu" target="_blank" class="">scheirw@newschool.edu</a>><br class="">
<b class="">Sent:</b> Tuesday, March 30, 2021 4:15 PM<br class="">
<b class="">To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank" class="">archivesspace_users_group@lyralists.lyrasis.org</a>><br class="">
<b class="">Subject:</b> [Archivesspace_Users_Group] Issues with MySQL v8</font>
<div class=""> </div>
</div>
<div class="">
<div dir="ltr" class="">
<div class="">
<div class="">Hi,</div>
<div class=""><br class="">
</div>
<div class="">When we installed ArchivesSpace last summer, we used MySQL v8 for our database. The documentation has instructions that read, "if using for MySQL 8+..." leading us to believe that MySQL 8 was a supported version. However, we've been having issues running
Accession and Shelflist reports that the Lyrasis team has told us is caused by running MySQL 8 instead of MySQL 5. In the interim, Lyrasis has updated the documentation to say that "ArchivesSpace is currently able to run on MySQL version 5.x."</div>
<div class=""><br class="">
</div>
<div class="">Has anyone else installed ArchivesSpace with MySQL 8? We are concerned about downgrading to 5 versus waiting for a future version that works with 8, but in the meantime we are unable to run a number of desired reports.</div>
</div>
<div class=""><br class="">
</div>
<div class="">Many thanks,</div>
<div class="">Wendy<br class="">
</div>
<div class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div class="">
<div dir="ltr" class="">
<div class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class="">
<div dir="ltr" class=""><div style="font-family: arial; font-size: 10px; padding: 5px 0px 0px 5px; margin: 0px;" class="">
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px" class="">____________________________________</span><span style="color:rgb(232,46,33)" class=""><br class="">
</span></div><div style="font-family: arial; padding: 5px 0px 0px 5px; margin: 0px;" class=""><span style="font-size:10px;color:rgb(172,147,110);font-weight:bold" class="">WENDY SCHEIR<br class="">
</span><b style="font-size:10px" class=""><font color="#666666" class="">DIRECTOR</font></b><br class="">
</div><div style="font-family: arial; padding: 5px 0px 0px 5px; margin: 0px;" class=""><img width="420" height="37" style="color: rgb(102, 102, 102); font-size: 10px; margin-right: 0px;" src="https://docs.google.com/uc?export=download&id=16Nic6T4ZK1k1BhLOUToez7KP5Tzv8f9o&revid=0B4enrSUaFYtfdnV0R3E3bEkvek9LUVdsbkRIVUNJaXh1MU9VPQ" class=""></div><div style="font-family: arial; padding: 5px 0px 0px 5px; margin: 0px;" class=""><span style="font-size:10px;color:rgb(102,102,102)" class="">66 5TH AVENUE, NEW YORK, NY 10011<br class="">
</span><a href="mailto:scheirw@newschool.edu" style="font-size:10px;color:rgb(102,102,102)" target="_blank" class="">scheirw@newschool.edu</a></div><div style="padding: 5px 0px 0px 5px; margin: 0px;" class=""><span style="font-family: arial; font-size: 10px; font-weight: bold;" class="">T</span><span style="font-family:arial;font-size:10px;color:rgb(102,102,102)" class=""> 212.229.5942 x2888</span></div><div style="font-family: arial; font-size: 10px; padding: 10px 0px 0px 5px; margin: 0px;" class="">
<a href="http://library.newschool.edu/archives" style="color:rgb(172,147,110);font-size:11px" target="_blank" class="">Explore the Archives</a> <span style="" class="">| </span><a href="http://digitalarchives.library.newschool.edu/" style="color:rgb(172,147,110);font-size:11px" target="_blank" class="">Digital
Collections from the Archives</a> <span style="" class="">| </span><a href="http://newschoolhistories.org/" style="color:rgb(172,147,110);font-size:11px" target="_blank" class="">New School Histories</a> <font class="">|</font> <a href="https://twitter.com/tnsarchives" style="color:rgb(172,147,110);font-size:11px" target="_blank" class="">@tnsarchives</a></div>
<div class="">
<div class=""><p style="vertical-align:baseline;outline-width:0px;margin:0in 0in 0.0001pt" class=""><font color="#999999" face="Arial, sans-serif" size="1" class=""><span style="line-height:18px" class=""></span></font></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank" class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br class="">
</blockquote></div>
_______________________________________________<br class="">Archivesspace_Users_Group mailing list<br class=""><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br class=""></div></blockquote></div><br class=""></body></html>