Two problems: Wizard and German Umlauts

[dip]

Thanks for the link.
Before I can test 6.2.3 I have the following question: Since the property group wizard did not work I activated automation as described in the wiki pages and added the following excute scripting action which is based on the incremental autonumeric script described also in the wiki pages:

Code: Select all

import com.openkm.api.OKMPropertyGroup;
import com.openkm.api.OKMRepository;
import java.util.*;
import com.openkm.dao.DatabaseMetadataDAO;
 
String grpName = "okg:details";
String path = OKMRepository.getInstance().getNodePath(null,uuid);
 
OKMPropertyGroup.getInstance().addGroup(null, path, grpName);

With this script the property group "details" is automatically added when I add a new document even if this is done be scanning.

However, since I activated automation the wizards do not work anymore when I add a document using the "add document" button (which worked before). It seems that enabling automation disabled the wizards completely. Is this true and known?

So I think when I now upgrade to 6.2.3 I first have to disable automation to ensure that the wizards work when adding a document using the "add document" button (to have a clear start). But I have no idea how I disable automation again. I have no knowledge about java programming and about sql (I have only little experiences in C programming and this was 25 years ago).

So should I disable automation before testing 6.2.3 and if yes how can I do this?

And finally, in the link you provided it says:

Run from your preferred SQL client these queries:

HSQL

ALTER TABLE OKM_NODE_MAIL ALTER COLUMN NML_CONTENT clob;

MySQL

ALTER TABLE OKM_NODE_MAIL MODIFY NML_CONTENT longtext;

Should I use the HSQL or the MySQL line (I have a default installation). And I don't have a "preferred SQL client" (I don't have an SQL client at all). Can I enter the line in the Database query section of OpenKM?

Sorry for my lack of knowldedge but I will do my best to test the new version.

[jllort]

1- Always is better use Mysql than embeded HSQL.
2- When you enable automation wizards are disabled. Actually from comunity version should be made some modification to set the wizards flags from automation.

[dip]

How do I disable automation?

[dip]

I downloaded the OpenKM.war file but I do not know how to run the command

Code: Select all

ALTER TABLE OKM_NODE_MAIL ALTER COLUMN NML_CONTENT clob;

Could someone please explain what I have to do in ubuntu 12.04 to run this command.

And further, how can I disable automation that I can test the wizard.

Thanks a lot for your help.

[jllort]

In administration you got database search option http://wiki.openkm.com/index.php/Database_query you should execute from there.

[dip]

The migration steps say I should execute the code AFTER I have stopped tomcat. But after having stopped tomcat I cannot login into OpenKM and so I cannot execute the code from administration/Database_query.

Anyway, I stopped tomcat (by running bin/catalina.sh stop), changed in OpenKM.cfg "none" to "update" replaced the OpenKM.war file in tomcat/webapps and re-started tomcat. When I logged in the message appeared:

WARNING
hibernate.hbm2ddl = update
But has been automatically fixed

Then I looged in and selected administration/Database_query and typed

ALTER TABLE OKM_NODE_MAIL ALTER COLUMN NML_CONTENT clob;

I selected JDBC (is this correct or should I select Hibernate or Metadata?) then I clicked on "Send" and then on "Execute SQL" script (which is the correct one?).

Then I logged out, stopped and restarted tomcat. But after the next login under "about OpenKM" it still shows version 6.2.2 build 7815.

What did I wrong?

[jllort]

You should execute as jdbc.

if you do not change OpenKM.war file the openkm version should not change. If you have done it, you should remember removed OpenKM folder and /work/Catalina/localhost

[dip]

I stopped tomcat, deleted tomcat/webapps/OpenKM and tomcat/work/Catalina/localhost and restarted tomcat.
When I now try to access OpenKM, in the OpenKM window the following lines are shown

Starting loading OpenKM
Loading user values

and then it stops loading and nothing more happens (I cannot upload a screenshot since the board attachment quota has been reached).

How can I now access OpenKM?

[jllort]

I think the problem is on cache browser, sometimes happens in some major updates. Simply when the login be stopped, press the browser refresh button and browser cache will be refreshed.

[dip]

Thanks, this did the trick. Now login works again and it shows version 6.2.3.

However, the problem with the German umlauts is still there. When I scan a document and use a non ascii character in the filename, this character is replaced with a question mark (?).

And second, how can I disable automation to be able to test the wizard? At the moment the wizard does not show up since I previously enabled automation.

[jllort]

Is not possible to disable, you should delete all automation entries to disable. I think logic to switch profile wizard is based on looking for if it's present some automation definition, not any automation defitinion ( you can try disable all automation entries, but I'm not sure it going right ).

[dip]

Ok, I deleted all automation entries and verified that the wizard is activated in the user profile.

Then I first added a document with "add document" and the wizard showed up (as already previously in version 6.2.2).

Then I added a document by scanning and the wizard did still not show up. That means that this bug has unfortunately NOT been solved in version 6.2.3.

[jllort]

I know the feature is present on professional version but probably has not been propagated to community. Really it was not a bug. Initial openkm 6.x version and 5.x do not allows boths actions scanner and wizard, and from some 6.2.x professional version has been introduced.

[dip]

Thanks for the clarification, so I have to wait until it is propagated into the community version

But what is with the German umlaut problem? Is this a bug which will be fixed in the community version?

[jllort]

Sincerally I'm lost in this post try to not merge on same post several issues because then we got this kind of problems. I think the other question should be solved changing table column size or not ?