Difference between revisions of "Migrating from 6.2.5 to 6.3"

From OpenKM Documentation
Jump to: navigation, search
Line 15: Line 15:
 
'''PostgreSQL'''
 
'''PostgreSQL'''
 
<source lang="sql">
 
<source lang="sql">
alter table OKM_MIME_TYPE add column MT_SEARCH char(1);
+
ALTER TABLE OKM_MIME_TYPE ADD COLUMN MT_SEARCH char(1);
update OKM_MIME_TYPE set MT_SEARCH='T';
+
UPDATE OKM_MIME_TYPE SET MT_SEARCH='T';
OKM_MIME_TYPE alter column MT_SEARCH set NOT NULL;
+
ALTER TABLE OKM_MIME_TYPE ALTER COLUMN MT_SEARCH SET NOT NULL;
 
</source>
 
</source>
  
Line 26: Line 26:
 
'''HSQL'''
 
'''HSQL'''
 
<source lang="sql">
 
<source lang="sql">
 
+
ALTER TABLE OKM_MIME_TYPE ADD COLUMN MT_SEARCH char(1);
 +
UPDATE OKM_MIME_TYPE SET MT_SEARCH='T';
 +
ALTER TABLE OKM_MIME_TYPE ALTER COLUMN MT_SEARCH SET NOT NULL;
 
</source>
 
</source>
  

Revision as of 12:58, 22 May 2014


Nota clasica.png This section is currently under development.


Nota advertencia.png There's a problem to automatically update a database filed in all database engines. With MySQL and PostgreSQL can be solved connecting directly to your database, with HSQL - embeded database - we suggest after starting OpenKM go to http://your_ip:8080/OpenKM/admin and execute the database update from Database Query view.

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

PostgreSQL

ALTER TABLE OKM_MIME_TYPE ADD COLUMN MT_SEARCH char(1);
UPDATE OKM_MIME_TYPE SET MT_SEARCH='T';
ALTER TABLE OKM_MIME_TYPE ALTER COLUMN MT_SEARCH SET NOT NULL;
  • Start Tomcat again
  • Go to Administration > Database Query, and remove obsolete configuration properties:

HSQL

ALTER TABLE OKM_MIME_TYPE ADD COLUMN MT_SEARCH char(1);
UPDATE OKM_MIME_TYPE SET MT_SEARCH='T';
ALTER TABLE OKM_MIME_TYPE ALTER COLUMN MT_SEARCH SET NOT NULL;
  • Enjoy OpenKM 6.3.0!

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.


Nota clasica.png Recommended to clear browser cache and Java Plugin cache