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

  • Resolved JohnS0N

    (@johns0n)


    3 years, 3 months ago

    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;

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author gioni

    (@gioni)

    Hi! I’m sorry, your host should know what “Got error 168 from storage engine”. I believe they have changed something on the database server, and now that changes cause the issue.

    Thread Starter JohnS0N

    (@johns0n)

    It is not a hosting issue. I don’t know why there is so much transfer of accountability here. The plugin is attempting to create tables that presumably already exist. Even if I delete these tables.

    Thread Starter JohnS0N

    (@johns0n)

    Here is a response from my host:

    This is simply resolved by restarting the MySQL system. However, this is not the issue with the actual server or MySQL system. Both function exactly as they should. The issue is that the plugin only creates .ibd table space files, instead of creating the actual MySQL database tables and rows.

    Plugin Author gioni

    (@gioni)

    I’m sorry, but your host has no idea what they are talking about. I would fire them.

    The issue is that the plugin only creates .ibd table space files, instead of creating the actual MySQL database tables and rows.

    It is impossible to create “.ibd table space files” directly by running a CREATE TABLE statement. WP Cerber doesn’t create .ibd files. It runs a CREATE TABLE IF NOT EXISTS query. The DB engine itself creates all necessary files. If it’s configured properly.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Can’t activate WP Cerber due to a database error.’ is closed to new replies.