Migration from 5.0-RC1 to 5.0

From OpenKM Documentation
Revision as of 18:32, 30 March 2011 by Pavila (talk | contribs) (MS SQLServer)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Stop JBoss and replace the $JBOSS_HOME/server/default/deploy/OpenKM.war archive with the last one. Before start JBoss, edit the OpenKM.cfg and set:

hibernate.hbm2ddl=update

Also change the configuration property from

system.openoffice

to

system.openoffice.path

Go to Administration and Database query. Execute this SQL query:

ALTER TABLE OKM_MIME_TYPE DROP COLUMN MT_ACTIVE;

Now go to Mime types and click on reset to refresh the mime type icons.

MS SQLServer

In the table OKM_MIME_TYPE, the column MT_IMAGE_CONTENT must be changed from BLOB to VARCHAR(max).