[Archivesspace_Users_Group] ASpace database issues

[Tom Hanstra]

Is there any way that your version of MySQL got upgraded?  I see this in
the MySQL documentation:

https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8.html

which indicates that utf8mb3 is deprecated after Mysql 8.0.28.

I don't have any experience to say that this is where the problem is. I was
just looking around because I don't want to end up in a similar situation.

Tom

On Wed, Jan 18, 2023 at 2:23 PM Matthew Adair <mladair at umich.edu> wrote:

> Version 2.5.2 of ASpace.  Version 8.0.30 of MySQL
>
> We get the following error in the log file:
> "The following MySQL database tables are not set to use UTF-8 for their
> character encoding:"
> and then it lists all of the database tables, and fails with an unable to
> connect to database error
>
> Encoding on the database and all of the tables are utf8mb3_general_ci
>
> This problem seems to have just cropped up and there have been no
> changes that I am aware of.
>
> Thoughts?
> -Matt
>
> ----
> *Matt Adair*
> Archivist for Digital Imaging and Infrastructure
>
>
> Bentley Historical Library
> 1150 Beal Avenue
> Ann Arbor, Michigan 48109-2113
> 734-647-3537
> http://bentley.umich.edu
> @UmichBentley
>
> *The Bentley Historical Library acknowledges that coerced cessions of land
> by the Anishnaabeg and Wyandot made the University of Michigan possible,
> and we seek to reaffirm the ancestral and contemporary ties of these
> peoples to the lands where the University now stands.*
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>


-- 
*Tom Hanstra*
*Sr. Systems Administrator*
hanstra at nd.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230118/2aeee4f0/attachment.html>