Difference between revisions of "Migration from 5.0-RC1 to 5.0"
From OpenKM Documentation
m |
|||
| Line 24: | Line 24: | ||
Now go to Mime types and click on ''reset'' to refresh the mime type icons. | Now go to Mime types and click on ''reset'' to refresh the mime type icons. | ||
| + | |||
| + | == MS SQLServer == | ||
| + | The table OKM_MIME_TYPE the column MT_IMAGE_CONTENT must be changed from image to VARCHAR(max) | ||
[[Category: Migration Guide]] | [[Category: Migration Guide]] | ||
Revision as of 18:36, 30 March 2011
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
The table OKM_MIME_TYPE the column MT_IMAGE_CONTENT must be changed from image to VARCHAR(max)
