[Archivesspace_Users_Group] Database migration error creating table

[Crimi, Nick]

Thank you! I tried running the setup database script for 2.7.0 and 2.7.1. Both want to create the lang_material table but it already exists.
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Benn Joseph <benn.joseph at northwestern.edu>
Sent: Thursday, May 18, 2023 3:43:28 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Database migration error creating table

You don't often get email from benn.joseph at northwestern.edu. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>
This email originated from outside ECU.


Wasn’t there also a version somewhere around 2.7 where the data model changed re: languages? I remember having to upgrade to 2.7 (and running some sort of tool) before going to 2.8, a couple of upgrades ago.

--Benn



From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Valerie Addonizio
Sent: Thursday, May 18, 2023 2:27 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Database migration error creating table



Nick I’m not sure it’s related, but aspace-import-excel (the plugin) was added to core code as of 2.8.0, so you can drop that plugin and enjoy that functionality without it.



-Valerie



From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Crimi, Nick
Sent: Thursday, May 18, 2023 3:10 PM
To: archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Database migration error creating table



Hi team,



My library is trying to upgrade AS from 2.51 to 3.3.1. We are using mysql for the dB and aspace-import-excel is enabled for plug-in.

The dB migration throws an error that table lang_material already exists. Please let me know how to complete the upgrade. Maybe I need to upgrade to the latest 2.x version first?



Nick crimi

East Carolina University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230518/e8adebac/attachment.html>