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.
Plugin Author
gioni
(@gioni)
Hi guys!
Here are two steps you need to do. Tell me what you get.
1. Repair tables as described here: http://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!
