[Archivesspace_Users_Group] Issues with MySQL v8

[Blake Carver]

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

[https://docs.google.com/uc?export=download&id=16Nic6T4ZK1k1BhLOUToez7KP5Tzv8f9o&revid=0B4enrSUaFYtfdnV0R3E3bEkvek9LUVdsbkRIVUNJaXh1MU9VPQ]

66 5TH AVENUE, NEW YORK, NY 10011
scheirw at newschool.edu<mailto: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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210331/b0167a37/attachment.html>