Difference between revisions of "Knowledge:Migration from 6.2.15 to 6.2.16"

Revision as of 17:36, 14 May 2013

OpenKM 6.2.16 is currently under development.

MySQL

PostgreSQL

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

Go to Administration > Database Query, and remove obsolete configuration properties:

If you have any weird problem try to stop Tomcat, delete these folders:

And start Tomcat again.

Recommended to clear browser cache and Java Plugin cache

@@ Line 12: / Line 12: @@
 '''MySQL'''
-If there is no automation defined:
 <source lang="sql">
--- Show table constraints
-DROP TABLE OKM_AUTO_ACTION_PARAMS;
-</source>
-If there is automation rules defined:
-<source lang="sql">
--- Show table constraints
-SHOW CREATE TABLE OKM_AUTO_ACTION_PARAMS;
--- Remove primary key
-ALTER TABLE OKM_AUTO_ACTION_PARAMS DROP PRIMARY KEY;
-ALTER TABLE OKM_AUTO_ACTION_PARAMS DROP INDEX FK1F747E2D5E55CCFF; -- Use from create table
-ALTER TABLE OKM_AUTO_ACTION_PARAMS DROP FOREIGN KEY FK1F747E2D5E55CCFF; -- Use from create table
--- Rename table field
-ALTER TABLE OKM_AUTO_ACTION_PARAMS CHANGE AAP_VALIDATION AAP_ACTION bigint(20);
--- Create primary key
-ALTER TABLE OKM_AUTO_ACTION_PARAMS ADD PRIMARY KEY (AAP_ACTION, AAP_ORDER);
 </source>
 '''PostgreSQL'''
-If there is no automation defined:
 <source lang="sql">
--- Show table constraints
-DROP TABLE OKM_AUTO_ACTION_PARAMS;
-</source>
-If there is automation rules defined:
-<source lang="sql">
--- NOT COMPLETED --
--- Rename table field
-ALTER TABLE OKM_AUTO_ACTION_PARAMS RENAME COLUMN AAP_VALIDATION TO AAP_ACTION;
 </source>