Knowledge:Migration from 6.2.4 to 6.2.5

• See changelog at Mantis

• Download update from http://openkm.com/download/okm/OpenKM-6.2.5.zip

• 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

• Set installation customer at License Manager.

• Go to Administration > Database Query and execute:

Register new automation and select available which have okm:folder should be 4 ( otherside there's some problem )

INSERT INTO OKM_AUTO_METADATA (AMD_AT, AMD_CLASS_NAME, AMD_NAME, AMD_GROUP, AMD_TYPE00, AMD_SRC00, AMD_DESC00, AMD_TYPE01, AMD_SRC01, AMD_DESC01 ) VALUES ('post','com.openkm.automation.validation.HasCategory', 'HasCategory', 'validation', 'text', 'okm:folder', 'String', '', '', '');
SELECT * FROM OKM_AUTO_METADATA where AMD_SRC00='okm:folder';

From sql get some values to be added on script:

SELECT CONCAT('map.put("',AVP_PARAM,'",OKMRepository.getInstance().getNodeUuid(null, "',AVP_PARAM,'");') FROM OKM_AUTO_VALIDATION_PARAMS where AVP_VALIDATION in (SELECT AVL_ID FROM OKM_AUTO_VALIDATION where AVL_TYPE in (SELECT AMD_ID FROM OKM_AUTO_METADATA where AMD_SRC00='okm:folder'));

Add the results of the last query on the script and execute, you'll get update SQL that should be executed

import com.openkm.api.OKMRepository;
import java.util.*;

Map map = new HashMap();
// ADD HERE THE RESULTS OF THE LAST QUERY !!!!!
// map.put("/okm:root/test/", OKMRepository.getInstance().getNodeUuid(null, "/okm:root/test/"));
for (String path : map.keySet()) {
    print("UPDATE OKM_AUTO_VALIDATION_PARAMS SET AVP_PARAM='"+map.get(path) +"' WHERE AVP_PARAM='" +path+"' and AVP_ID in (SELECT AVP_ID FROM OKM_AUTO_VALIDATION_PARAMS where AVP_VALIDATION in (SELECT AVL_ID FROM OKM_AUTO_VALIDATION where AVL_TYPE in (SELECT AMD_ID FROM OKM_AUTO_METADATA where AMD_SRC00='okm:folder')));");
}

• Go to Administration > Utilities > Cache Stats and reset the cache identified as xx.xx.xx.

• Enjoy OpenKM 6.2.5!

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 (prevents "The response could not be deserialized" errors) and Java Plugin cache