[Archivesspace_Users_Group] Upgrade Problem

[Blake Carver]

    !!  #<Sequel::DatabaseError: Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'rights_statement_pre_088' already exists>                                                                                  !!


It looks like the upgrade worked but didn't make it? The DB is in a bad state, it has a table it shouldn't for some reason. Can you start over from a back up maybe?
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Tamara Broman <tbroman at saclibrary.org>
Sent: Friday, August 16, 2019 11:53 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Upgrade Problem


Thanks, Blake!  I have attached the output.  Any ideas?  Do I need to delete the table it is referring to?  I am not sure how to proceed.



Tamara



From: archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Blake Carver
Sent: Friday, 16 August, 2019 8:43 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Upgrade Problem



setup-databases.bat failed to run, try it again and watch for any errors.

________________________________

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 Tamara Broman <tbroman at saclibrary.org<mailto:tbroman at saclibrary.org>>
Sent: Friday, August 16, 2019 11:21 AM
To: archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org> <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] Upgrade Problem



Hello,



I upgraded this morning from v. 2.0.0 to v. 2.6.0.



I followed all the instructions in the “UPGRADING.MD” file, including running the “setup-databases.bat” file because we are on Windows here.



Now, when I launch Archivesspace, I get the following message in the logs, even though I did the setup-databases process.  Can anyone help me figure out how to fix this?



[cid:image001.png at 01D5540F.F16999D0]



Tamara Broman

IT Analyst

Sacramento Public Library

828 I Street, Sacramento, CA 95814

(916) 264-2714 | tbroman at saclibrary.org<mailto:tbroman at saclibrary.org>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20190817/26923bd9/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 535232 bytes
Desc: image001.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20190817/26923bd9/attachment.png>