Difference between revisions of "Knowledge:Migration from 6.2.6 to 6.2.7"
From OpenKM Documentation
m |
m |
||
Line 41: | Line 41: | ||
* Go to '''Administration''' > '''Scripting''' and execute this script: | * Go to '''Administration''' > '''Scripting''' and execute this script: | ||
− | <source lang=" | + | <source lang="java"> |
com.openkm.dao.NodeBaseDAO.getInstance().fixNodePath(); | com.openkm.dao.NodeBaseDAO.getInstance().fixNodePath(); | ||
</source> | </source> |
Revision as of 13:52, 12 December 2012
- 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();
- 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 |