Can’t activate Cerber

Before installing WP Cerber you need to manually delete the database table cerber_lab_ip by using a DB management tool like phpMyAdmin. I think the plugin was not correctly deactivated and removed so the table was not deleted or was corrupted.

I have searched my CPanel thoroughly, phpMyAdmin, and MySQL Databases and there is no trace of Cerber anywhere. I completely removed Cerber and any related files through my ftp panel.

I still cannot activate Cerber.

Are you sure that there is no cerber_lab_ip table in the DB? Could you check the error log of your database (MySQL)? It seems the table file from the previous installation is corrupted and still is on the disk. You can try to repair the cerber_lab_ip table and then delete it. See also: https://stackoverflow.com/questions/27582616/incorrect-information-in-file-for-some-tables-in-mysql

Hi! How’s it going?

Came across this midway in to solving my own issue: My provider changed my long time fixed IP address (no notification) which I had white-listed in WPCerber and I wasn’t able to log in. I had been clever enough to use a range — they put me in a different range.
My phone app let me set the plugin to not be Active, and I could log in. Hooray!
Wanted to re-enable after login and update my whitelist — Got a similar error to that listed above.

Can’t activate WP Cerber due to a database error.
Tablespace for table ‘1cu.cerber_lab_net‘ exists. Please DISCARD the tablespace before IMPORT.

CREATE TABLE IF NOT EXISTS cerber_lab_net ( ip varchar(39) CHARACTER SET ascii NOT NULL DEFAULT “” COMMENT “IP address”, ip_long_begin BIGINT UNSIGNED NOT NULL DEFAULT “0”, ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT “0”, country CHAR(3) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT “” COMMENT “Country code”, expires INT(11) UNSIGNED NOT NULL DEFAULT “0”, PRIMARY KEY (ip), UNIQUE KEY begin_end (ip_long_begin, ip_long_end) ) DEFAULT CHARSET=utf8 COMMENT=”Cerber lab network cache”;

Question:
So before I delete the data via FTP and the table, I ask, is there an easy way to save any of my existing configuration details, or do I have to start fresh?
Thanks! Enjoying he program so far but now I am terrible paranoid about my site since I see all this previously hidden Hactivity!

(PS cleaned my caching plugin before writing you too.)

• This reply was modified 5 years, 4 months ago by megawatson.

had upgraded wordpress to latest Nov. 2019. Used latest WP cerber. No luck. Here’s my story if it helps someone else.

dropped cerber_lab_ip from main SQL list (root)
installed again and click activate :
error cerber_lab_net exists delete before import
I see cerber_lab in mysql not with the _net
under cerber_lab there’s an IP name in the table structure
Ok so then I dropped That entire table off the root.
Then cerber_lab_ip popped up again in the root! Yeah cache works? Boo not right now please!
Dropped cerber_lab_ip again

Still see cerber_acl
_blocks
_countries
_log
_qmem
_traffic

uninstalling from WP again and clearing cache to try reinstall

and while those names and a few others buried show they are not there if you click (doesn’t exist)
And I have not deleted any stuff via FTP sinc these are database errors and I imagine the
files are overwritten on reinstall if not deleted on uninstall

SADLY NOT working: Tablespace for table ‘(mywp).cerber_lab_net‘ exists. Please DISCARD the tablespace before IMPORT.

CREATE TABLE IF NOT EXISTS cerber_lab_net ( ip varchar(39) CHARACTER SET ascii NOT NULL DEFAULT “” COMMENT “IP address”, ip_long_begin BIGINT UNSIGNED NOT NULL DEFAULT “0”, ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT “0”, country CHAR(3) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT “” COMMENT “Country code”, expires INT(11) UNSIGNED NOT NULL DEFAULT “0”, PRIMARY KEY (ip), UNIQUE KEY begin_end (ip_long_begin, ip_long_end) ) DEFAULT CHARSET=utf8 COMMENT=”Cerber lab network cache”;

uninstall, deactivating W3, purge cloudflare, reinstall. Then Activate: NOT WORKING.
Tablespace for table ‘(mywp).cerber_lab_net‘ exists. Please DISCARD the tablespace before …etc

A database search for cerber_lab_net returns Nothing.
dropping the cerber_lab prefixed tables and trying to activate again: No go.

trying to check for error log on my shared host I do not see one.

I keep turning off things I think may be interfering and worrying like wp_cerber they won’t restart so about to give up. Very disappointing, appreciated the plugin features and sense of security.

found check table in myphpadmin. All tables check status OK, ran repair table command anyway.”The storage engine for the table doesn’t support r” which I imagine ends in repair, but the test indicated no errors.

But I can’t install it anymore. I’m out. Sorry. Mad. Disappointed.

Can’t activate WP Cerber due to a database error.
Tablespace for table ‘(myWP).cerber_lab_net‘ exists. Please DISCARD the tablespace before IMPORT.

CREATE TABLE IF NOT EXISTS cerber_lab_net ( ip varchar(39) CHARACTER SET ascii NOT NULL DEFAULT “” COMMENT “IP address”, ip_long_begin BIGINT UNSIGNED NOT NULL DEFAULT “0”, ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT “0”, country CHAR(3) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT “” COMMENT “Country code”, expires INT(11) UNSIGNED NOT NULL DEFAULT “0”, PRIMARY KEY (ip), UNIQUE KEY begin_end (ip_long_begin, ip_long_end) ) DEFAULT CHARSET=utf8 COMMENT=”Cerber lab network cache”;

@megawatson This is a really epic yet sad story. There is something wrong with MySQL files. If you have access, before activating the plugin try to find and delete those files (on Linux):

/var/lib/mysql/name-of-your-website-database/cerber_lab_net.frm
/var/lib/mysql/name-of-your-website-database/cerber_lab_net.ibd

OR

/usr/local/var/mysql/name-of-your-website-database/cerber_lab_net.frm
/usr/local/var/mysql/name-of-your-website-database/cerber_lab_net.ibd

Also, you can try to restart your MySQL server.