Difference between revisions of "Migrating from 6.2.5 to 6.3"
From OpenKM Documentation
| Line 1: | Line 1: | ||
{{Note|This section is currently under development.}} | {{Note|This section is currently under development.}} | ||
| − | {{Warning|There's a problem | + | {{Warning|There's a problem when you update a table adding a new column with a "not null" constraint, if the table already has some rows. With MySQL and PostgreSQL can be solved connecting directly to your database. With HSQL - which is an embeded database - we suggest going to OpenKM go to '''Administration''' > '''Database Query''' and execute the database update.}} |
* Make a backup!!! | * Make a backup!!! | ||
Revision as of 14:13, 22 May 2014
 |
This section is currently under development. |
 |
There's a problem when you update a table adding a new column with a "not null" constraint, if the table already has some rows. With MySQL and PostgreSQL can be solved connecting directly to your database. With HSQL - which is an embeded database - we suggest going to OpenKM go to Administration > Database Query and execute the database update. |
- 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.
|
Recommended to clear browser cache and Java Plugin cache |
