Missing table(s)
PostPosted:Fri Oct 23, 2020 4:29 pm
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.
Is automation not supported in CE? Are there any other tables missing as part of this problem?
Appreciate any help.
Code: Select all
108 rows in set (0.001 sec)+----------------------------+
| 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 |
+----------------------------+