Table "Doesn't Exist" error on WordFence tables

  • I am conducting maintenance on my websites tonight (Friday) and have experienced issues with my backups failing due to tables missing. All of the missing tables are WordFence tables (wfNet404s, wfBadLeechers, wfVulnScanners). The table shows as present in some tools and not others, and I don’t know why. Disabling WordFence with the “Delete Wordfence tables and data on deactivation?” option on seems to resolve the issue, but almost all of my 20+ websites appear to be impacted. Running 4.0.3 of WordFence.

    Regards,

    Art Smith

    https://www.ads-software.com/plugins/wordfence/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Art Smith

    (@ambrosiawt)

    Update: the solution that I mentioned does not really solve the problem. After doing this on a site, the problem went away and then returned.

    I’m wondering if this has anything to do with your maintenance tonight Mark.

    For the moment, I am proceeding with my own maintenance and will get backups one way or another, but if I find that this problem is still occurring in the morning, I will have to shut off WordFence until this is resolved.

    Thanks!

    Art

    Thread Starter Art Smith

    (@ambrosiawt)

    It appears the problem is no longer occurring this morning. I would still be interested in an assessment of the cause.

    Thanks!

    Art

    I had the same issue,
    I don’t know what went wrong – simplest option, run the following SQL code:
    DROP TABLE IF EXISTSwp_wfNet404s`;

    CREATE TABLE wp_wfNet404s (
    sig binary(16) NOT NULL,
    ctime int(10) unsigned NOT NULL,
    URI varchar(1000) NOT NULL,
    PRIMARY KEY (sig),
    KEY k1 (ctime)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;`

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Table "Doesn't Exist" error on WordFence tables’ is closed to new replies.