Title: ACL database errors
Last modified: February 27, 2020

---

# ACL database errors

 *  [gingerbooch](https://wordpress.org/support/users/gingerbooch/)
 * (@gingerbooch)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/acl-database-errors/)
 * Hi [@gioni](https://wordpress.org/support/users/gioni/),
 * I come back to the ACL problem I detailled in this topic :
    [Old discussion](https://wordpress.org/support/topic/access-list-does-not-recognize-some-ips/)
   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](https://imgur.com/XIaT45M)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Facl-database-errors%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [gioni](https://wordpress.org/support/users/gioni/)
 * (@gioni)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/acl-database-errors/#post-12490313)
 * Hi! You don’t need to do anything because once you’ve clicked ” Repair Cerber’s
   Tables,” your ACL issues have been fixed. Regarding those minor DB errors: ignore
   them, they’re a normal part of how forceful repairing works.
 *  Thread Starter [gingerbooch](https://wordpress.org/support/users/gingerbooch/)
 * (@gingerbooch)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/acl-database-errors/#post-12507893)
 * Hi [@gioni](https://wordpress.org/support/users/gioni/),
 * Thank you for your answer.
    I took the ACL screenshot after the repairing action.
   As you can see, the ACL issues have not been fixed. I did it twice to be sure,
   then I wrote the message above.
 * Thank you,
 * GB
 *  Plugin Author [gioni](https://wordpress.org/support/users/gioni/)
 * (@gioni)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/acl-database-errors/#post-12531924)
 * Check the error log of your database server (MySQL) error log for related errors.
   It’s the only place to get a clue.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘ACL database errors’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-cerber_77a9bf.svg)
 * [WP Cerber Security, Anti-spam & Malware Scan](https://wordpress.org/plugins/wp-cerber/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-cerber/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-cerber/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-cerber/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-cerber/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-cerber/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [gioni](https://wordpress.org/support/users/gioni/)
 * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/acl-database-errors/#post-12531924)
 * Status: not resolved