[Archivesspace_Users_Group] Issues with MySQL v8

[Wendy Scheir]

Hi Blake,

Thanks so much for following up. So far, we've gotten report errors for the
following 3 accessions reports:

   - Accession Report
   - Accession Receipt Report
   - Accessions and Linked Subjects, Names and Classifications


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.

All best,
Wendy

____________________________________

WENDY SCHEIR
*DIRECTOR*

66 5TH AVENUE, NEW YORK, NY 10011
scheirw at newschool.edu

T 212.229.5942 x2888

Explore the Archives <http://library.newschool.edu/archives> | Digital
Collections from the Archives
<http://digitalarchives.library.newschool.edu/> | New School Histories
<http://newschoolhistories.org/> | @tnsarchives
<https://twitter.com/tnsarchives>



On Wed, Mar 31, 2021 at 2:33 PM Blake Carver <blake.carver at lyrasis.org>
wrote:

> There are others running on 8, so far the only trouble seems to be
> reports. Here's a JIRA
>
> https://archivesspace.atlassian.net/jira/software/c/projects/ANW/issues/ANW-1200
> You're seeing it fail on two reports?
>
>
>
> ------------------------------
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of
> Wendy Scheir <scheirw at newschool.edu>
> *Sent:* Tuesday, March 30, 2021 4:15 PM
> *To:* Archivesspace Users Group <
> archivesspace_users_group at lyralists.lyrasis.org>
> *Subject:* [Archivesspace_Users_Group] Issues with MySQL v8
>
> Hi,
>
> 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."
>
> 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.
>
> Many thanks,
> Wendy
>
> ____________________________________
>
> WENDY SCHEIR
> *DIRECTOR*
>
> 66 5TH AVENUE, NEW YORK, NY 10011
> scheirw at newschool.edu
>
> T 212.229.5942 x2888
>
> Explore the Archives <http://library.newschool.edu/archives> | Digital
> Collections from the Archives
> <http://digitalarchives.library.newschool.edu/> | New School Histories
> <http://newschoolhistories.org/> | @tnsarchives
> <https://twitter.com/tnsarchives>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210331/bcf38205/attachment.html>