Knowledge:Migration from 6.2.23 to 6.2.24

• See changelog at Mantis

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

• Make a backup!!!

• Stop Tomcat

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

• Replace the OpenKM.war

• Review file descriptor limit and, eventually, increase it.

• Start Tomcat again

• Check for database errors:

$ grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log

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

Solve ampersand problem converting & to & ( internal datastore change );

SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%&%';
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%&%';
SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%>%';
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%>%';
SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%<%';
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%<%';

Execute the result script

import com.openkm.api.OKMDocument;
import com.openkm.api.OKMFolder;
// Add here

• Set installation customer at License Manager.

• Enjoy OpenKM 6.2.24!

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