search

kitodo / kitodo-production

Kitodo.Production is a workflow management tool for mass digitization and is part of the Kitodo Digital Library Suite.
http://www.kitodo.org/software/kitodoproduction/
GNU General Public License v3.0
58 stars 65 forks source link

Missing database table 'authority' #6112

Open stweil opened 6 days ago

stweil commented 6 days ago

A fresh installation of the latest Kitodo.Production fails when deployed by Tomcat:

        Caused by: org.hibernate.HibernateException: Schema-validation: missing table [authority]

There is indeed no table named authority in Kitodo/setup/*.sql.

stweil commented 6 days ago

After manually adding the authority table, there is another error for the next missing one:

        Caused by: org.hibernate.HibernateException: Schema-validation: missing table [batch]
stweil commented 6 days ago

Also missing: workflow, client, docket, folder, project, ruleset, template, process, batch_x_process and maybe more tables. How is it possible to run Tomcat with a new installation of Kitodo.Production?

BartChris commented 5 days ago

I suppose the baseline sql is this file: https://github.com/kitodo/kitodo-production/releases/download/kitodo-production-3.6.3/kitodo_3-6-3.sql The wikis give the sql file for an old version of the database. https://github.com/kitodo/kitodo-production/wiki/Installationsanleitung-f%C3%BCr-Kitodo.Production-3.4#6-datenbank-vorbereiten

We should probably release an installation guide for 3.6.x

stweil commented 4 days ago

I suppose the baseline sql is this file: https://github.com/kitodo/kitodo-production/releases/download/kitodo-production-3.6.3/kitodo_3-6-3.sql

I think it would be a good idea to replace the outdated SQL files in the repository by this one.