Can’t activate WP Cerber due to a database error.

Already contacted host prior to writing this, they tried to help, but eventually said I need to contact the plugin developers to resolve this matter. I used your plugin for many months without issue, then suddenly once I could not enable it anymore. Here is the error:

————————–

Can’t activate WP Cerber due to a database error.

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_log ( ip varchar(39) CHARACTER SET ascii NOT NULL, user_login varchar(60) NOT NULL, user_id bigint(20) unsigned NOT NULL DEFAULT ‘0’, stamp bigint(20) unsigned NOT NULL, activity int(10) unsigned NOT NULL DEFAULT ‘0’, KEY ip (ip) ) DEFAULT CHARSET=utf8;

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_acl ( ip varchar(39) CHARACTER SET ascii NOT NULL, tag char(1) NOT NULL, comments varchar(250) NOT NULL ) DEFAULT CHARSET=utf8;

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_blocks ( ip varchar(39) CHARACTER SET ascii NOT NULL, block_until bigint(20) unsigned NOT NULL, reason varchar(250) NOT NULL, reason_id int(11) unsigned NOT NULL DEFAULT ‘0’, UNIQUE KEY ip (ip) ) DEFAULT CHARSET=utf8;

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_lab ( ip varchar(39) CHARACTER SET ascii NOT NULL, reason_id int(11) unsigned NOT NULL DEFAULT ‘0’, stamp bigint(20) unsigned NOT NULL, details text NOT NULL ) DEFAULT CHARSET=utf8;

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_lab_ip ( ip varchar(39) CHARACTER SET ascii NOT NULL, reputation INT(11) UNSIGNED NOT NULL, expires INT(11) UNSIGNED NOT NULL, PRIMARY KEY (ip) ) DEFAULT CHARSET=utf8;

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_lab_net ( ip varchar(39) CHARACTER SET ascii NOT NULL DEFAULT ”, ip_long_begin BIGINT UNSIGNED NOT NULL DEFAULT ‘0’, ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT ‘0’, country CHAR(3) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT ”, expires INT(11) UNSIGNED NOT NULL DEFAULT ‘0’, PRIMARY KEY (ip), UNIQUE KEY begin_end (ip_long_begin, ip_long_end) ) DEFAULT CHARSET=utf8;

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_countries ( country CHAR(3) NOT NULL DEFAULT ” COMMENT ‘Country code’, locale CHAR(10) NOT NULL DEFAULT ” COMMENT ‘Locale i18n’, country_name VARCHAR(250) NOT NULL DEFAULT ”, PRIMARY KEY (country, locale) ) DEFAULT CHARSET=utf8;

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_traffic ( ip varchar(39) CHARACTER SET ascii NOT NULL, ip_long BIGINT UNSIGNED NOT NULL DEFAULT ‘0’, hostname varchar(250) NOT NULL DEFAULT ”, uri text NOT NULL, request_fields MEDIUMTEXT NOT NULL, request_details MEDIUMTEXT NOT NULL, session_id char(32) CHARACTER SET ascii NOT NULL, user_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, stamp decimal(14,4) NOT NULL, processing int(10) NOT NULL DEFAULT 0, country char(3) CHARACTER SET ascii NOT NULL DEFAULT ”, request_method char(8) CHARACTER SET ascii NOT NULL, http_code int(10) UNSIGNED NOT NULL, wp_id bigint(20) UNSIGNED NOT NULL DEFAULT 0, wp_type int(10) UNSIGNED NOT NULL DEFAULT 0, is_bot int(10) UNSIGNED NOT NULL DEFAULT 0, blog_id int(10) UNSIGNED NOT NULL DEFAULT 0, KEY stamp (stamp) ) DEFAULT CHARSET=utf8;

Got error 168 from storage engine

CREATE TABLE IF NOT EXISTS cerber_qmem ( ip varchar(39) CHARACTER SET ascii NOT NULL, http_code int(10) UNSIGNED NOT NULL, stamp int(10) UNSIGNED NOT NULL, KEY ip_stamp (ip, stamp) ) DEFAULT CHARSET=utf8;