• Resolved pseudovin

    (@pseudovin)


    Hi, I have a problem when creating an automation.

    It shows NaN and I can’t create any Step (because it always returns “Step not updated” whenever I save the Step).

    https://prnt.sc/T53z9FnDaEIJ

Viewing 1 replies (of 1 total)
  • Thread Starter pseudovin

    (@pseudovin)

    Solved by creating these tables:

    CREATE TABLE wp_bwfan_automation_complete_contact (
    ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    cid bigint(20) unsigned NOT NULL,
    aid bigint(10) unsigned NOT NULL,
    event varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
    s_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Start Date',
    c_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Completion Date',
    data longtext COLLATE utf8mb4_unicode_520_ci,
    trail varchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Trail ID',
    PRIMARY KEY (ID),
    KEY ID (ID),
    KEY cid (cid),
    KEY aid (aid),
    KEY c_date (c_date)
    );

    CREATE TABLE wp_bwfan_automation_contact (
    ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    cid bigint(20) unsigned NOT NULL,
    aid bigint(10) unsigned NOT NULL,
    event varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,
    c_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Start Date',
    e_time bigint(12) unsigned NOT NULL,
    status tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1 - Active | 2 - Failed | 3 - Paused | 4 - Waiting | 5 - Terminate | 6 - Retry',
    last bigint(10) unsigned NOT NULL DEFAULT '0',
    last_time bigint(12) unsigned NOT NULL,
    data longtext COLLATE utf8mb4_unicode_520_ci,
    claim_id bigint(20) unsigned NOT NULL DEFAULT '0',
    attempts tinyint(1) unsigned NOT NULL DEFAULT '0',
    trail varchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Trail ID',
    PRIMARY KEY (ID),
    KEY ID (ID),
    KEY cid (cid),
    KEY aid (aid),
    KEY e_time (e_time),
    KEY status (status),
    KEY claim_id (claim_id)
    );

    CREATE TABLE wp_bwfan_automation_contact_claim (
    ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (ID)
    );

    CREATE TABLE wp_bwfan_automation_contact_trail (
    ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    tid varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Trail ID',
    cid bigint(12) unsigned NOT NULL COMMENT 'Contact ID',
    aid bigint(10) unsigned NOT NULL COMMENT 'Automation ID',
    sid bigint(10) unsigned NOT NULL COMMENT 'Step ID',
    c_time bigint(12) unsigned NOT NULL,
    status tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1 - Success | 2 - Wait | 3 - Failed | 4 - Skipped',
    data varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
    PRIMARY KEY (ID),
    KEY ID (ID),
    KEY tid (tid),
    KEY cid (cid),
    KEY sid (sid),
    KEY status (status)
    );

    CREATE TABLE wp_bwfan_automation_step (
    ID bigint(10) unsigned NOT NULL AUTO_INCREMENT,
    aid bigint(10) unsigned NOT NULL,
    type tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1 - Wait | 2 - Action | 3 - Goal | 4 - Conditional | 5 - Exit',
    action varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
    status tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 - Active | 2 - Draft | 3 - Deleted',
    data longtext COLLATE utf8mb4_unicode_520_ci,
    created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    updated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (ID),
    KEY aid (aid),
    KEY type (type)
    );

    (change “wp_” to your WordPress table prefix)

Viewing 1 replies (of 1 total)
  • The topic ‘Step Not Updated’ is closed to new replies.