Difference between revisions of "Knowledge:Migration from 6.2.23 to 6.2.24"

From OpenKM Documentation
Jump to: navigation, search
(Created page with "{{Note|OpenKM 6.2.24 is currently under development.}} * See [http://issues.openkm.com/changelog_page.php?version_id=83 changelog at Mantis] * Download update from http://op...")
 
Line 30: Line 30:
 
* Go to Administration > Database Query, and update configuration properties:
 
* Go to Administration > Database Query, and update configuration properties:
  
 +
'''Solve ampersand problem converting & to & ( internal datastore change );'''
 
<source lang="sql">
 
<source lang="sql">
 +
SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%&%';
 +
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%&%';
 +
SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%>%';
 +
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%>%';
 +
SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%<%';
 +
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%<%';
 +
</source>
 +
 +
Execute the result script
 +
<source lang="java">
 +
import com.openkm.api.OKMDocument;
 +
import com.openkm.api.OKMFolder;
 +
// Add here
 
</source>
 
</source>
  

Revision as of 10:55, 9 December 2013


Nota clasica.png OpenKM 6.2.24 is currently under development.

  • Make a backup!!!
  • Stop Tomcat
  • Run from your preferred SQL client these queries:


  •  Edit OpenKM.cfg and set hibernate.hbm2ddl to update


  •  Replace the OpenKM.war


  •  Review file descriptor limit and, eventually, increase it.


  •  Start Tomcat again


  •  Check for database errors:


$ grep "ERROR .*hbm2ddl" $TOMCAT_HOME/logs/catalina.log



  •  Go to Administration > Database Query, and update configuration properties:


Solve ampersand problem converting & to & ( internal datastore change );



SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%&%';
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%&%';
SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%>%';
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%>%';
SELECT concat('OKMDocument.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_DOCUMENT) AND NBS_NAME LIKE '%<%';
SELECT concat('OKMFolder.getInstance().rename(null, "', NBS_UUID, '","',  NBS_NAME, '");') FROM OKM_NODE_BASE WHERE NBS_UUID IN (SELECT NBS_UUID FROM OKM_NODE_FOLDER) AND NBS_NAME LIKE '%<%';



Execute the result script



import com.openkm.api.OKMDocument;
import com.openkm.api.OKMFolder;
// Add here




  •  Enjoy OpenKM 6.2.24!


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.






Nota clasica.png
Recommended to clear browser cache and Java Plugin cache











Retrieved from "https://www.openkm.com/wiki/index.php?title=Knowledge:Migration_from_6.2.23_to_6.2.24&oldid=11005"