DB error in logs

Same here. I repair the tables with the Tools panel but the error comes back.

Repairing tables won’t help, the table isn’t corrupt, it simply doesn’t exist in the DB ??
Probably it was supposed to be created during the plugin update, but this didn’t happen for whatever reason.

Hi guys!

Here are two steps you need to do. Tell me what you get.

1. Repair tables as described here: https://wpcerber.com/repair-database-tables/
2. Immediately after that inspect error.log for error messages that relevant to cerber_lab_net table.

Hiya, Gioni.

Just did that, got the following afterwards:

Some minor DB errors were detected

Array
(
    [0] => Array
        (
            [0] => Duplicate column name 'ip_long'
            [1] => ALTER TABLE cerber_log ADD ip_long BIGINT UNSIGNED NOT NULL DEFAULT "0" COMMENT "IPv4 long" AFTER ip, ADD INDEX (ip_long)
        )

    [1] => Array
        (
            [0] => Duplicate column name 'ip_long_begin'
            [1] => ALTER TABLE cerber_acl ADD ip_long_begin BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'IPv4 range begin' AFTER ip, ADD ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'IPv4 range end' AFTER ip_long_begin
        )

    [2] => Array
        (
            [0] => Duplicate key name 'ip_begin_end'
            [1] => ALTER TABLE cerber_acl ADD UNIQUE ip_begin_end (ip, ip_long_begin, ip_long_end)
        )

    [3] => Array
        (
            [0] => Can't DROP 'ip'; check that column/key exists
            [1] => ALTER TABLE cerber_acl DROP INDEX ip
        )

    [4] => Array
        (
            [0] => Can't DROP 'begin_end'; check that column/key exists
            [1] => ALTER TABLE cerber_acl DROP INDEX begin_end
        )

    [5] => Array
        (
            [0] => Duplicate key name 'begin_end_tag'
            [1] => ALTER TABLE cerber_acl ADD INDEX begin_end_tag (ip_long_begin, ip_long_end, tag)
        )

    [6] => Array
        (
            [0] => Duplicate column name 'session_id'
            [1] => ALTER TABLE cerber_log 
        ADD session_id CHAR(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT "",
        ADD country CHAR(3) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT "" COMMENT "Country code",
        ADD details VARCHAR(250) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT "" COMMENT "Details about HTTP request";
      
        )

)

But the table cerber_lab_net got created ?? So I think the issue should be gone now. I’ll keep an eye on it.

Thanks!

Hello, Gioni.

Two days so far, no more DB errors. Thanks!