Can't deploy due to missing table "comment" in 3.0.0 beta 4

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

62 stars 63 forks source link

Can't deploy due to missing table "comment" in 3.0.0 beta 4 #3028

Closed mnscholz closed 4 years ago

mnscholz commented 4 years ago

I'm trying to install beta 4 of the 3.x branch using this tutorial.

When deploying the war file, I get an exception in tomcat caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [comment]

Since there is neither a sql dump nor a config dump file for beta 4, I used the ones from beta 3 and 2, respectively. I guess this is the problem.

Could someone provide the dump files for beta 4 or point to a how-to for creating them, please?

Thanks!

mnscholz commented 4 years ago

I managed to compile the sql file using this doc: https://kitodo-production.readthedocs.io/en/latest/gettingstarted/development-version/#build-development-version-of-kitodo-3x

fyi: I encountered two pitfalls in this doc when running the maven flyway commands:

The kitodo-api jar wasn't found by maven. I had to fake a repository for maven to find it.
The db migration creates indexes of varchar fields with length 255. By sure that your inno_db allows for index sizes greater than 767 bytes.