by CM & Sugar

Creating individual workflow processes and define detailed automatization tasks for your CRM. Break out of the standard SuiteCRM workflow frame and extend your CRM with your very own, personal BI. No need of hiring external consultants doing your customizations; stop dealing with compatibility problems and communication issues that come with it. Save money and get done faster! Keep your CRM as it is meant to be, your CRM!

Cancel at any time!
Free Trial

#3667 - Not showing in admin menu

Closed Installation created by ross1 2 years ago

I have installed the add-in and done a quick repair but I don't see any option in the admin menu for CMS

  1. cm_sugar member avatar

    CM & Sugar Provider Affiliate

    2 years ago

    ![Do you have access to your environment? If yes, there should be a file located at /custom/Extension/modules/Administration/Ext/Administration/CMS_WorkflowManager_admin_menu.php. If that file is missing, please check log errors for writing and creating files.

    It should looks like this, if you use CMS Admin modules:

    Selection_022.png

  2. ross1 member avatar

    ross1

    2 years ago

    I see this error:

    Thu Jun 10 10:52:19 2021 [2621][e6831f1e-1ebe-7b07-23ee-5d971842ad4c][ERROR] Cannot create directory custom/Extension/application/Ext/Language/en_us.CMS_WorkflowManager.php cannot be touched

    also:

    Thu Jun 10 10:52:24 2021 [2621][e6831f1e-1ebe-7b07-23ee-5d971842ad4c][FATAL] Mysqli_query failed.

    and also:

    MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS cms_workflowconditions ( ' at line 28 Thu Jun 10 10:52:25 2021 [1530][e6831f1e-1ebe-7b07-23ee-5d971842ad4c][FATAL] CMSOutfittersLicense::doValidate() failed: Array ( [success] => [result] => Key could not be found locally. Please go to the license configuration tool and enter your key. )

    What is the resolution to this? It isn't obvious from this what I should do to solve.

  3. cm_sugar member avatar

    CM & Sugar Provider Affiliate

    2 years ago

    First error is about missing file permissions. Check, if your web user meets the right access rights to all files and directories among your CRM. The user needs to own everything.

    Second error is cut. Can you check the whole log at mysql.log? I don't find any syntax error. Worked for other clients as well. Maybe a version issue, which could be fixed.

    Third error points out missing license, but should be resolved after everything went well

  4. ross1 member avatar

    ross1

    2 years ago

    I have reset permissions now.

    Fully error message is:

    Thu Jun 10 10:52:24 2021 [2621][e6831f1e-1ebe-7b07-23ee-5d971842ad4c][FATAL] Mysqli_query failed. Thu Jun 10 10:52:24 2021 [2621][e6831f1e-1ebe-7b07-23ee-5d971842ad4c][FATAL] Query Failed: /* Table : cms_workflowmanager / / MISSING TABLE: cms_workflowmanager / CREATE TABLE IF NOT EXISTS cms_workflowmanager ( id char(36) NOT NULL, name varchar(255) NULL, date_entered datetime NULL, date_modified datetime NULL, modified_user_id char(36) NULL, created_by char(36) NULL, description text NULL, deleted bool DEFAULT '0' NULL, assigned_user_id char(36) NULL, status varchar(100) DEFAULT 'Active' NULL, parent_type varchar(100) NULL, start_event varchar(100) NULL, object_event varchar(100) NULL, event_trigger varchar(100) NULL, call_limits varchar(5) DEFAULT 'inf' NULL, check_login_status bool NULL, linked varchar(10) DEFAULT 'linked' NULL, condition_result varchar(10) DEFAULT 'one' NULL, PRIMARY KEY (id) ) CHARACTER SET utf8 COLLATE utf8_general_ci; / Table : cms_workflowconditions / / MISSING TABLE: cms_workflowconditions / CREATE TABLE IF NOT EXISTS cms_workflowconditions ( id char(36) NOT NULL, name varchar(255) NULL, date_entered datetime NULL, date_modified datetime NULL, modified_user_id char(36) NULL, created_by char(36) NULL, description text NULL, deleted bool DEFAULT '0' NULL, assigned_user_id char(36) NULL, parent_type varchar(100) NULL, status varchar(100) DEFAULT 'Active' NULL, PRIMARY KEY (id) ) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = innodb; / Table : cms_workflowactions / / MISSING TABLE: cms_workflowactions / CREATE TABLE IF NOT EXISTS cms_workflowactions ( id char(36) NOT NULL, name varchar(255) NULL, date_entered datetime NULL, date_modified datetime NULL, modified_user_id char(36) NULL, created_by char(36) NULL, description text NULL, deleted bool DEFAULT '0' NULL, assigned_user_id char(36) NULL, status varchar(100) DEFAULT 'Active' NULL, parent_type varchar(100) NULL, scope varchar(50) DEFAULT 'create_relate' NULL, bean_setup text NULL, priority int(3) NULL, notification_owner bool NULL, queue_mails bool NULL, email_template_id char(36) NULL, PRIMARY KEY (id) ) CHARACTER SET utf8 COLLATE utf8_general_ci; / Table : cms_workflowconditionlines / / MISSING TABLE: cms_workflowconditionlines / CREATE TABLE IF NOT EXISTS cms_workflowconditionlines ( id char(36) NOT NULL, name varchar(255) NULL, line_number int(3) DEFAULT '1' NULL, date_entered datetime NULL, date_modified datetime NULL, created_by char(36) NULL, modified_user_id char(36) NULL, deleted bool NULL, workflowcondition_id char(36) NOT NULL, condition_operator varchar(20) NULL, condition_compare_to varchar(20) NULL, value_operator varchar(20) NULL, value1 varchar(255) NULL, fix_relative_value1 varchar(20) NULL, value2 varchar(255) NULL, fix_relative_value2 varchar(20) NULL, type varchar(10) NULL, field varchar(255) NULL, parent_type varchar(100) NULL, path text NULL, PRIMARY KEY (id), KEY workflowcondition_id_alt (workflowcondition_id, deleted) ) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = innodb; / Table : cms_workflowactionqueues / / MISSING TABLE: cms_workflowactionqueues / CREATE TABLE IF NOT EXISTS cms_workflowactionqueues ( id char(36) NOT NULL, date_modified datetime NULL, created_by char(36) NULL, deleted bool NULL, status varchar(25) NULL, workflowaction_id char(36) NOT NULL, email_id char(36) NOT NULL, bean_id char(36) NOT NULL, parent_type varchar(100) NULL, PRIMARY KEY (id), KEY queue_alt (workflowaction_id, bean_id, deleted) ) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = innodb; / Table : cms_workflowmanagerrecords / / MISSING TABLE: cms_workflowmanagerrecords / CREATE TABLE IF NOT EXISTS cms_workflowmanagerrecords ( id char(36) NOT NULL, date_entered datetime NULL, created_by char(36) NULL, deleted bool NULL, workflowmanager_id char(36) NOT NULL, parent_id char(36) NOT NULL, parent_type varchar(100) NULL, PRIMARY KEY (id), KEY idx1 (workflowmanager_id, parent_id, parent_type), KEY idx2 (created_by), KEY idx3 (workflowmanager_id), KEY idx4 (parent_id) ) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = innodb; / Table : cms_workflowmanager_cms_workflowactions / / MISSING TABLE: cms_workflowmanager_cms_workflowactions / CREATE TABLE IF NOT EXISTS cms_workflowmanager_cms_workflowactions ( id varchar(36) NOT NULL, date_modified datetime NULL, deleted bool DEFAULT '0' NULL, cms_workflowmanager_id varchar(36) NULL, cms_workflowaction_id varchar(36) NULL, PRIMARY KEY (id), KEY cms_workflowmanager_cms_workflowactions_alt (cms_workflowmanager_id, cms_workflowaction_id, deleted) ) CHARACTER SET utf8 COLLATE utf8_general_ci; / Table : cms_workflowmanager_cms_workflowconditions / / MISSING TABLE: cms_workflowmanager_cms_workflowconditions */ CREATE TABLE IF NOT EXISTS cms_workflowmanager_cms_workflowconditions ( id varchar(36) NOT NULL, date_modified datetime NULL, deleted bool DEFAULT '0' NULL, cms_workflowmanager_id varchar(36) NULL, cms_workflowcondition_id varchar(36) NULL, PRIMARY KEY (id), KEY cms_workflowmanager_cms_workflowconditions_alt (cms_workflowmanager_id, cms_workflowcondition_id, deleted) ) CHARACTER SET utf8 COLLATE utf8_general_ci;: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS cms_workflowconditions ( ' at line 28

  5. ross1 member avatar

    ross1

    2 years ago

    I've ran the SQL manually and it has created the tables now. I also uninstalled and re-installed the module and now can see the admin menu.

    However I now have a further issue where the 'Loading Data Model' dialog constantly spins up to 100% then resets in a loop.

    Screenshot 2021-06-10 at 23.35.20.png

    • cm_sugar member avatar

      CM & Sugar Provider Affiliate

      2 years ago

      please open your browser console and have a look at "console" and "network". reload your page and paste me all errors and red networks calls. I assume module loading has an anwanted side effect at your CRM

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...