Migrating from 6.2.5 to 6.3

This section is currently under development.

There's a problem to automatically update a dabase filed in all database engines. With MySQL and PostgreSQL can be solved connecting directly to your database, with HSQL - embeded database - we suggest after starting OpenKM go to http://your_ip:8080/OpenKM/admin and execute the database update from Database Query view.

• Make a backup!!!

• Stop Tomcat

• Edit OpenKM.cfg and set hibernate.hbm2ddl to update

• Replace the OpenKM.war

• Run from your preferred SQL client these queries:

PostgreSQL

alter table OKM_MIME_TYPE add column MT_SEARCH char(1);
update OKM_MIME_TYPE set MT_SEARCH='T';
OKM_MIME_TYPE alter column MT_SEARCH set NOT NULL;

• Start Tomcat again

• Go to Administration > Database Query, and remove obsolete configuration properties:

HSQL

• Enjoy OpenKM 6.2.6!

If you have any weird problem try to stop Tomcat, delete these folders:

• $TOMCAT_HOME/webapps/OpenKM
• $TOMCAT_HOME/work/Catalina/localhost

And start Tomcat again.

Recommended to clear browser cache and Java Plugin cache