Difference between revisions of "Migration from 5.0-RC1 to 5.0"
From OpenKM Documentation
(→MS SQLServer) |
|||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | 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: | |
| − | <source lang=" | + | <source lang="java"> |
| − | + | hibernate.hbm2ddl=update | |
</source> | </source> | ||
| − | + | Also change the configuration property from | |
| − | |||
| − | |||
<source lang="java"> | <source lang="java"> | ||
| Line 18: | Line 16: | ||
system.openoffice.path | system.openoffice.path | ||
</source> | </source> | ||
| + | |||
| + | Go to Administration and Database query. Execute this SQL query: | ||
| + | |||
| + | <source lang="sql"> | ||
| + | ALTER TABLE OKM_MIME_TYPE DROP COLUMN MT_ACTIVE; | ||
| + | </source> | ||
| + | |||
| + | 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)'''. | ||
[[Category: Migration Guide]] | [[Category: Migration Guide]] | ||
Latest revision as of 18: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).
