[Archivesspace_Users_Group] Database migration error creating table

[Crimi, Nick]

Thank you! I had to drop many tables and the upgrade got to migration 158. It wanted me to delete the ark_uniq_check table. Now it says I have an unknown column external _ark_url in the field list. My guess is that a row has illegal characters? How do I track down the bad apple?

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Blake Carver <blake.carver at lyrasis.org>
Sent: Friday, May 19, 2023, 10:17 AM
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 blake.carver at lyrasis.org. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>
This email originated from outside ECU.

Your DB is in a bad place.
It has tables from the failed upgrade, so every time you try to run it again it sees those tables and says "nope, can't keep going, you have this one already"
Make sure you do this on a COPY of the DB and not the live site.
drop table lang_material
./scripts/setup-database.sh
it will probably fail with another "already exists" error
now drop lang_material AND that new one. You'll need to drop both because they get recreated each time you run setup again.
Keep doing that until it finishes up. There will be probably 4 or 5.
Hopefully that'll do the trick and the DB isn't messed up in any other ways.
You may also need to delete some enumeration values in there also.

ArchivesSpace expects certain things to be in certain places, and certain other things to NOT be in certain places when upgrading, if the upgrade fails only some of those things are in the right place, so it can't get past that weird state.

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Crimi, Nick <CRIMIN at ecu.edu>
Sent: Thursday, May 18, 2023 4:17 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Database migration error creating table

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/20230519/0f4d0ce8/attachment-0001.html>