Access list does not recognize some IPs

Thanks you for this great plugin!

One rather painful issue though, I don’t know if someone can help us? Since we installed WP cerber a few months ago, about 1/3 of the IP addresses added to the blacklist are not blocked.

– When clicking “add IP to blacklist”, we can see the confirmation notice “added to blacklist” but no black square is added to corresponding logs in activity and traffic inspector tabs

– When corresponding IP owner comes back to our site, they are not blocked, and therefore able to submit spam or fraudulent forms

– It seems that all those troublesome IPs share only one common behavior: associated IP-range logs in traffic inspector and activity tabs are always empty. Logs are filled correctly for individual IPs

– We unsuccessfully tried to delete and re-add IPs, use IP ranges, CIDR, subnets, repair tables, delete all cerber_acl rows and re-enter IPs manually.

– We only have a few IPs in our white access list, but at least one of them is showing similar symptoms

Info:
PHP version: 7.2.5
[SERVER_SOFTWARE] => Apache

Repair tables:
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”;

)

[7] => Array
(
[0] => Duplicate key name ‘session_index’
[1] => ALTER TABLE cerber_log ADD INDEX session_index (session_id)
)

)

The page I need help with: [log in to see the link]