ACL database errors

Hi @gioni,

I come back to the ACL problem I detailled in this topic :
Old discussion
As a quick reminder, I have different IPs in the ACL and like half of them have ip_long_begin + ip_long_end set to zero. For those, the ACL rule is not working at all.
Please check this extract of the ACL table :
WP Cerber ACL rules bug

I had no time to look on this anymore and I’m using htaccess to block untrusted IPS, but now I just wanted to perform something (I will open a new topic for it) and I found the ” Repair Cerber’s Tables” button.
So I pushed the button and here are the remaining errors :

Some minor DB errors were detected

AFTER ip, ADD ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT “0” AFTER ip_long_begin
[2] => Can’t DROP ‘ip’; check that column/key exists for the query: ALTER TABLE cerber_acl DROP INDEX ip
[3] => Can’t DROP ‘begin_end’; check that column/key exists for the query: ALTER TABLE cerber_acl DROP INDEX begin_end
[4] => Duplicate column name ‘session_id’ for the query: 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”;

[5] => Duplicate key name ‘session_index’ for the query: ALTER TABLE cerber_log ADD INDEX session_index (session_id)
[6] => Duplicate column name ‘file_status’ for the query: ALTER TABLE mod835_cerber_files ADD file_status INT UNSIGNED NOT NULL DEFAULT ‘0’ AFTER scan_status
[7] => Duplicate column name ‘reason_id’ for the query: ALTER TABLE cerber_blocks ADD reason_id int(11) unsigned NOT NULL DEFAULT “0”
[8] => Duplicate column name ‘php_errors’ for the query: ALTER TABLE cerber_traffic ADD php_errors TEXT NOT NULL AFTER blog_id
[9] => Duplicate column name ‘acl_slice’ for the query: ALTER TABLE cerber_acl
ADD acl_slice SMALLINT UNSIGNED NOT NULL DEFAULT 0,
ADD ver6 SMALLINT UNSIGNED NOT NULL DEFAULT 0,
ADD v6range VARCHAR(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT “”,
ADD req_uri VARCHAR(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT “”,
MODIFY ip VARCHAR(81) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL

[10] => Duplicate key name ‘main_for_selects’ for the query: ALTER TABLE cerber_acl ADD INDEX main_for_selects (acl_slice, ver6, ip_long_begin, ip_long_end, tag)
[11] => Can’t DROP ‘begin_end_tag’; check that column/key exists for the query: ALTER TABLE cerber_acl DROP INDEX begin_end_tag
[12] => Can’t DROP ‘ip_begin_end’; check that column/key exists for the query: ALTER TABLE cerber_acl DROP INDEX ip_begin_end
)

I would like to fix those errors and to fix my remaining ACL problem.
Should I export settings + acl, uninstall WP Cerber, delete any Cerber tables from de db, then install WP Cerber and import settings + acl ?

Thank you for reading.

GB

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