View source for Knowledge:Migration from 6.2.10 to 6.2.11

* See [http://issues.openkm.com/changelog_page.php?version_id=68 changelog at Mantis]

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

* Make a backup!!!

* Stop Tomcat

* Run from your preferred SQL client these queries:

<source lang="sql">
update OKM_CONFIG set CFG_VALUE='<b>Message: </b>${notificationMessage}<br/><b>User: </b>${userId}<br/><#list documentList as doc><b>Document: </b><a href="${doc.url}">${doc.path}</a><br/></#list>' where CFG_KEY='notification.message.body';
update OKM_CONFIG set CFG_VALUE='OpenKM - NOTIFICATION' where CFG_KEY='notification.message.subject';
</source>

'''MySQL'''
<source lang="sql">
-- Describe table
describe OKM_PENDING_TASK;

-- Expand column
alter table OKM_PENDING_TASK modify PTK_PARAMS varchar(1024);
</source>

'''PostgreSQL'''
<source lang="sql">
-- Describe table
select column_name, udt_name, character_maximum_length from INFORMATION_SCHEMA.COLUMNS where table_name = 'okm_pending_task';

-- Expand column
alter table OKM_PENDING_TASK alter column PTK_PARAMS type varchar(1024);
</source>

'''Oracle'''
<source lang="sql">
-- Describe table
select * from user_tab_columns where table_name = 'OKM_PENDING_TASK' order by column_id;

-- Expand column
alter table OKM_PENDING_TASK modify (PTK_PARAMS varchar2(1024));
</source>

* Edit [[OpenKM.cfg]] and set '''hibernate.hbm2ddl''' to '''update'''

* Replace the OpenKM.war

* Review file descriptor limit and, eventually, [http://okm07.openkmcloud.com/OpenKM/index.jsp?docPath=%2Fokm%3Aroot%2FKnowledge+Base%2FSet+ulimit+in+Ubuntu.html increase it].

* Start Tomcat again

* Check for database errors:

<source lang="bash">
$ grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log
</source>

* Go to Administration > Configuration, and add '''okm_searchImage''' to '''tinymce.theme.buttons1''' parameter.

* Go to Administration > Database Query, and execute this query for cleaning orphaned bookmarks:

<source lang="sql">
delete from Bookmark bm where bm.node not in (select nb.uuid from NodeBase nb);
</source>

* Remove deprecated translation:

<source lang="sql">
delete from OKM_TRANSLATION where TR_KEY='user.info.chat.user.yet.logged';
</source>

* Set installation customer at [http://update.openkm.com/admin/license_list.php License Manager].

* Enjoy OpenKM 6.2.11!

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.

{{Note|Recommended to clear browser cache and [http://www.java.com/en/download/help/plugin_cache.xml Java Plugin cache]}}