Knowledge:Migration from 6.2.6 to 6.2.7

• See changelog at Mantis

• Download update from http://openkm.com/download/okm/OpenKM-6.2.7.zip (password eMpg8eIjY5)

• 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:

MySQL

alter table OKM_NODE_NOTE modify NNT_TEXT longtext;

PostgreSQL

alter table OKM_NODE_NOTE alter NNT_TEXT TYPE text;

Oracle

alter table OKM_NODE_NOTE modify (NNT_TEXT clob);

If the ALTER TABLE sentence fails in Oracle with ORA-22858, you have another way:

alter table OKM_NODE_NOTE add NNT_TEXT_TMP CLOB;
update OKM_NODE_NOTE set NNT_TEXT_TMP = NNT_TEXT;
alter table OKM_NODE_NOTE drop NNT_TEXT;
alter table OKM_NODE_NOTE rename NNT_TEXT_TMP to NNT_TEXT;

• Start Tomcat again

• Go to Administration > Scripting and execute this script:

com.openkm.dao.NodeBaseDAO.getInstance().fixNodePath();

To see the progress, add this line to $TOMCAT_HOME/conf/log4j.properties:

log4j.loggercom.openkm.dao.NodeBaseDAO=DEBUG

• Enjoy OpenKM 6.2.7!

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