• Migration guide problem

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
OpenKM has many interesting features, but requires some configuration process to show its full potential.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #7900  by geantVert
 
I have a problem to execute the alter table statements as explained in the migration guide 5.0 beta to 5.0-RC1.
It is impossible to run the statements, using the JDBC driver.

I get the following error while running the following statement:
ALTER TABLE OKM_PROFILE CHANGE PRF_MISC_ADVANCED_FILTERS PRF_MSC_ADVANCED_FILTERS bit(1) DEFAULT 0;
from the Database Query from the admin tool:

Class: java.sql.SQLException
Message: Unexpected token: CHANGE in statement [ALTER TABLE OKM_PROFILE CHANGE]

Apparently the syntax is not correct ?!?
 #7915  by jllort
 
If you're on default OpenKM configuration, then you're on hypersonic, I suggest use some dbms client like data studio and connect directly to hipersonic ( jboss must be stopped ).
 #8271  by pavila
 
Did you executed the SQL sentence already?

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.