[Archivesspace_Users_Group] Unable to edit / delete accessions or resources after upgrade to MySQL database

[Merryman, Ann]

Good afternoon hive mind...long time lurker, first time writer.  :)  I'm going to try to make this question concise:


*        I have just been upgraded to v2.8.1 (from v1.3.0...don't judge!  Lol) on a locally-hosted instance of AS, managed by my university's IT department.

*        When my instance was upgraded, I got the following warning message:
Database Warning: You are currently using the embedded database (Apache Derby). The embedded database is for testing/demo purposes only. You should use MySQL for any data intended for production, including data in a test instance that you intend to move over to a production instance.


*        The vendor let us know that there were not any upgrade paths from the demo database to MySQL, and the information would have to be re-entered (this is fine, as I had backed up everything and could re-enter)

*        Once IT built the MySQL database, however, all the accession and resource records  actually showed up.  ???

The problem is, while I can *see* the records on the back end, I can't edit or delete them.  However, they are visible and searchable on the PUI.  I've attached a few images for reference.

I'm trying to determine what the best course of action might be before I go back to my IT department, as I'm going to have to explain what the issue is to them as best I can (they're not really familiar with AS or archival processes, unfortunately).  I'm not clear on why the data pulled over if there wasn't a path, and I'm not tech savvy enough to guess at what my IT department did.  I could also email AS tech support, but I thought I'd start here to see if anyone has seen this or has something to try first.

Any thoughts or suggestions from the group would be greatly appreciated, or even just sympathetic noises.  :)

Thanks so much,

Ann

"For the things we have to learn before we can do them, we learn by doing them." ~ Aristotle

Ann E. Merryman, MLIS
Associate Librarian
Coordinator of Archives and Special Collections
[cid:image002.png at 01D778C9.9E3A4EE0]
USC Upstate, Library 263
800 University Way
Spartanburg, SC 29303
Office:  864-503-5275
merrymaa at uscupstate.edu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210714/aad62a8b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 39595 bytes
Desc: image002.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210714/aad62a8b/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ASpace resources image 1.JPG
Type: image/jpeg
Size: 137278 bytes
Desc: ASpace resources image 1.JPG
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210714/aad62a8b/attachment-0004.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ASpace resources image 2.JPG
Type: image/jpeg
Size: 104402 bytes
Desc: ASpace resources image 2.JPG
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210714/aad62a8b/attachment-0005.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ASpace PUI image 1.JPG
Type: image/jpeg
Size: 156526 bytes
Desc: ASpace PUI image 1.JPG
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210714/aad62a8b/attachment-0006.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ASpace PUI image 2.JPG
Type: image/jpeg
Size: 156097 bytes
Desc: ASpace PUI image 2.JPG
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210714/aad62a8b/attachment-0007.jpe>