[Archivesspace_Users_Group] Upgrade to 1.3.0 fails with db_error

[KNOWLES Claire]

Hi Jason,

Did you run the setup-database.sh script to update your database tables? I had that error too. Now my setup-database.sh is failing to migrate jobs, has anyone else had problems updating their database for 1.3.0?

Cheers,

Claire

--
Claire Knowles
Library Digital Development Manager
Library and University Collections, Information Services
University of Edinburgh
Tel: 0131 6503023
Email: claire.knowles at ed.ac.uk


From: <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Jason Brock <Jason.Brock at georgetown.edu<mailto:Jason.Brock at georgetown.edu>>
Reply-To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Date: Monday, 20 July 2015 19:54
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 to 1.3.0 fails with db_error

When attempting to upgrade our ArchivesSpace instance either directly from 1.1.0 or incrementally from 1.1.0 to 1.1.2 to 1.2.0 to 1.3.0 we receive the following error when trying to start the service:

Connection to backend failed ({"error":{"db_error":["Database integrity constraint conflict: Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'position' in 'order clause'"]}}
).  Retrying...

We are running ArchivesSpace on RHEL 6 against a MySQL 5.6 database.

Any thoughts on this error are appreciated!

- Jason


--
Jason Brock
Sr. Systems Administrator
Georgetown University Library
202.687.5735<tel:202.687.5735>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150721/498d2b49/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150721/498d2b49/attachment.ksh>