Missing table(s)

[accretics]

I installed openkm-ce using standard instructions on Ubuntu / Mariadb. While exploring I want to test automation functions. Instructions at https://docs.openkm.com/kcenter/view/ok ... tions.html require inserting records in database table OKM_AUTO_METADATA which seems to be missing. I have tried to change the cfg and have application recreate the database without success. Here is complete list of 108 tables in current okmdb.
Is automation not supported in CE? Are there any other tables missing as part of this problem?
Appreciate any help.

Code: Select all

+----------------------------+
| Tables_in_okmdb            |
+----------------------------+
| JBPM_ACTION                |
| JBPM_BYTEARRAY             |
| JBPM_BYTEBLOCK             |
| JBPM_COMMENT               |
| JBPM_DECISIONCONDITIONS    |
| JBPM_DELEGATION            |
| JBPM_EVENT                 |
| JBPM_EXCEPTIONHANDLER      |
| JBPM_JOB                   |
| JBPM_LOG                   |
| JBPM_MODULEDEFINITION      |
| JBPM_MODULEINSTANCE        |
| JBPM_NODE                  |
| JBPM_POOLEDACTOR           |
| JBPM_PROCESSDEFINITION     |
| JBPM_PROCESSINSTANCE       |
| JBPM_RUNTIMEACTION         |
| JBPM_SWIMLANE              |
| JBPM_SWIMLANEINSTANCE      |
| JBPM_TASK                  |
| JBPM_TASKACTORPOOL         |
| JBPM_TASKCONTROLLER        |
| JBPM_TASKINSTANCE          |
| JBPM_TOKEN                 |
| JBPM_TOKENVARIABLEMAP      |
| JBPM_TRANSITION            |
| JBPM_VARIABLEACCESS        |
| JBPM_VARIABLEINSTANCE      |
| OKM_ACTIVITY               |
| OKM_AUTO_ACTION            |
| OKM_AUTO_ACTION_PARAMS     |
| OKM_AUTO_RULE              |
| OKM_AUTO_VALIDATION        |
| OKM_AUTO_VALIDATION_PARAMS |
| OKM_BOOKMARK               |
| OKM_CONFIG                 |
| OKM_CRON_TAB               |
| OKM_CSS                    |
| OKM_DASHBOARD              |
| OKM_DASHBOARD_ACTIVITY     |
| OKM_DB_METADATA_SEQUENCE   |
| OKM_DB_METADATA_TYPE       |
| OKM_DB_METADATA_VALUE      |
| OKM_EXTENSION              |
| OKM_FORUM                  |
| OKM_FORUM_POST             |
| OKM_FORUM_TOPIC            |
| OKM_LANGUAGE               |
| OKM_MAIL_ACCOUNT           |
| OKM_MAIL_FILTER            |
| OKM_MAIL_FILTER_RULE       |
| OKM_MAIL_IMPORT_ERROR      |
| OKM_MESSAGE_RECEIVED       |
| OKM_MESSAGE_SENT           |
| OKM_MIME_TYPE              |
| OKM_MIME_TYPE_EXTENSION    |
| OKM_NODE_BASE              |
| OKM_NODE_CATEGORY          |
| OKM_NODE_DOCUMENT          |
| OKM_NODE_DOCUMENT_VERSION  |
| OKM_NODE_FOLDER            |
| OKM_NODE_KEYWORD           |
| OKM_NODE_MAIL              |
| OKM_NODE_MAIL_BCC          |
| OKM_NODE_MAIL_CC           |
| OKM_NODE_MAIL_REPLY        |
| OKM_NODE_MAIL_TO           |
| OKM_NODE_NOTE              |
| OKM_NODE_PROPERTY          |
| OKM_NODE_ROLE_PERMISSION   |
| OKM_NODE_SUBSCRIPTOR       |
| OKM_NODE_USER_PERMISSION   |
| OKM_OMR                    |
| OKM_OMR_PROPERTY           |
| OKM_PENDING_TASK           |
| OKM_PLUGIN                 |
| OKM_PROFILE                |
| OKM_PROFILE_MSC_EXTENSION  |
| OKM_PROFILE_MSC_REPORT     |
| OKM_PROFILE_MSC_WORKFLOW   |
| OKM_PROFILE_WZRD_PROP_GRP  |
| OKM_PROFILE_WZRD_WORKFLOW  |
| OKM_PROFILING              |
| OKM_PROP_QUERY_RECEIVED    |
| OKM_PROP_QUERY_SENT        |
| OKM_PROP_SUB_RECEIVED      |
| OKM_PROP_SUB_SENT          |
| OKM_QUERY_PARAMS           |
| OKM_QUERY_PARAMS_CATEGORY  |
| OKM_QUERY_PARAMS_KEYWORD   |
| OKM_QUERY_PARAMS_PROPERTY  |
| OKM_QUERY_PARAMS_SHARED    |
| OKM_REG_PROPERTY           |
| OKM_REG_PROPERTY_GROUP     |
| OKM_REPORT                 |
| OKM_ROLE                   |
| OKM_STAPLE                 |
| OKM_STAPLE_GROUP           |
| OKM_TRANSLATION            |
| OKM_TWITTER_ACCOUNT        |
| OKM_USER                   |
| OKM_USER_CONFIG            |
| OKM_USER_ITEMS             |
| OKM_USER_NODE              |
| OKM_USER_NODE_KEYWORD      |
| OKM_USER_ROLE              |
| OKM_WIKI_PAGE              |
| OKM_ZOHO_TOKEN             |
+----------------------------+

108 rows in set (0.001 sec)

[jllort]

Sorry, this documentation section only makes sense in OpenKM version 6.3.6 and older ( documentation was not explaining this detail ). Latest versions come with a plugin architecture and are not necessary to register in the database. I have updated the information in these sections of the documentation. You have all the tables you need.

Information about how to create plugins
https://docs.openkm.com/kcenter/view/ok ... ction.html

I suggest our personal development environment what comes with some samples ( https://www.openkm.com/en/download.html )

[accretics]

Thank you for the clarification. Will try that.