Step Not Updated
-
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).
Viewing 1 replies (of 1 total)
-
Solved by creating these tables:
CREATE TABLEwp_bwfan_automation_complete_contact(IDbigint(20) unsigned NOT NULL AUTO_INCREMENT,cidbigint(20) unsigned NOT NULL,aidbigint(10) unsigned NOT NULL,eventvarchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,s_datedatetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Start Date',c_datedatetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Completion Date',datalongtext COLLATE utf8mb4_unicode_520_ci,trailvarchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Trail ID',
PRIMARY KEY (ID),
KEYID(ID),
KEYcid(cid),
KEYaid(aid),
KEYc_date(c_date)
);
CREATE TABLEwp_bwfan_automation_contact(IDbigint(20) unsigned NOT NULL AUTO_INCREMENT,cidbigint(20) unsigned NOT NULL,aidbigint(10) unsigned NOT NULL,eventvarchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL,c_datedatetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Start Date',e_timebigint(12) unsigned NOT NULL,statustinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1 - Active | 2 - Failed | 3 - Paused | 4 - Waiting | 5 - Terminate | 6 - Retry',lastbigint(10) unsigned NOT NULL DEFAULT '0',last_timebigint(12) unsigned NOT NULL,datalongtext COLLATE utf8mb4_unicode_520_ci,claim_idbigint(20) unsigned NOT NULL DEFAULT '0',attemptstinyint(1) unsigned NOT NULL DEFAULT '0',trailvarchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Trail ID',
PRIMARY KEY (ID),
KEYID(ID),
KEYcid(cid),
KEYaid(aid),
KEYe_time(e_time),
KEYstatus(status),
KEYclaim_id(claim_id)
);
CREATE TABLEwp_bwfan_automation_contact_claim(IDbigint(20) unsigned NOT NULL AUTO_INCREMENT,created_atdatetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (ID)
);
CREATE TABLEwp_bwfan_automation_contact_trail(IDbigint(20) unsigned NOT NULL AUTO_INCREMENT,tidvarchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'Trail ID',cidbigint(12) unsigned NOT NULL COMMENT 'Contact ID',aidbigint(10) unsigned NOT NULL COMMENT 'Automation ID',sidbigint(10) unsigned NOT NULL COMMENT 'Step ID',c_timebigint(12) unsigned NOT NULL,statustinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1 - Success | 2 - Wait | 3 - Failed | 4 - Skipped',datavarchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (ID),
KEYID(ID),
KEYtid(tid),
KEYcid(cid),
KEYsid(sid),
KEYstatus(status)
);
CREATE TABLEwp_bwfan_automation_step(IDbigint(10) unsigned NOT NULL AUTO_INCREMENT,aidbigint(10) unsigned NOT NULL,typetinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1 - Wait | 2 - Action | 3 - Goal | 4 - Conditional | 5 - Exit',actionvarchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,statustinyint(1) NOT NULL DEFAULT '0' COMMENT '1 - Active | 2 - Draft | 3 - Deleted',datalongtext COLLATE utf8mb4_unicode_520_ci,created_atdatetime NOT NULL DEFAULT '0000-00-00 00:00:00',updated_atdatetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (ID),
KEYaid(aid),
KEYtype(type)
);(change “wp_” to your WordPress table prefix)
Viewing 1 replies (of 1 total)
The topic ‘Step Not Updated’ is closed to new replies.