Difference between revisions of "Migration from 5.0-RC1 to 5.0"
From OpenKM Documentation
(→MS SQLServer) |
(→MS SQLServer) |
||
| Line 26: | Line 26: | ||
== MS SQLServer == | == MS SQLServer == | ||
| − | In the table OKM_MIME_TYPE, the column MT_IMAGE_CONTENT must be changed from BLOB to VARCHAR(max) | + | In the table '''OKM_MIME_TYPE''', the column '''MT_IMAGE_CONTENT''' must be changed from '''BLOB''' to '''VARCHAR(max)'''. |
[[Category: Migration Guide]] | [[Category: Migration Guide]] | ||
Latest revision as of 19:32, 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
In the table OKM_MIME_TYPE, the column MT_IMAGE_CONTENT must be changed from BLOB to VARCHAR(max).
