wp_wfls_settings table does not exist

  • Resolved jarven

    (@jarven)


    5 years, 5 months ago

    I’m getting following error.
    I understand that wp_wfls_settings table does not exist. I have reactivate plugin, completely removed it and install again without success. We are using WF on a lot of pages and now error log overflow ??
    This start to happened since “Login Security” was added.

    `WordPress database error for Table “XXXXXXXXX.wp_wfls_settings” doesn”t exist SELECT “name”, “value”, “autoload” FROM “wp_wfls_settings” WHERE “name” = “allow-xml-rpc” created by require(“wp-blog-header.php”), require_once(“wp-load.php”), require_once(“wp-config.php”), require_once(“wp-settings.php”), include_once(“/plugins/wordfence/wordfence.php”), require_once(“/plugins/wordfence/lib/wordfenceClass.php”), require(“/plugins/wordfence/modules/login-security/wordfence-login-security.php”), WordfenceLS\Controller_WordfenceLS->init, WordfenceLS\Controller_WordfenceLS->_init_actions, WordfenceLS\Controller_Settings->get_bool, WordfenceLS\Controller_Settings->get, WordfenceLS\Settings\Model_DB->get

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

  • Hey @jarven,

    I’m sorry to hear about the trouble.

    Can you please try reinstalling Wordfence and let me know if it helps?

    https://www.wordfence.com/help/advanced/remove-or-reset/

    Please note that if you use the Wordfence Assistant method the tables below will need to be manually removed. In the next Wordfence Assistant release, these tables will be added to it.

    wfls_settings (I understand this missing table is the root of the issue, I’m just making note of it for others that may see this post)

    wfls_2fa_secrets

    Also, you can export your settings if you’d like to have a backup.

    https://www.wordfence.com/help/tools/import-export/

    Please let me know how it goes.

    Thanks,

    Gerroald

    Thread Starter jarven

    (@jarven)

    Thanks for your reply. I have already tested to uninstall manually and via gui.
    When I install again WF tables will be created but never wp_wfls_settings

    Thread Starter jarven

    (@jarven)

    Only me getting this problem?

    I have over 10 sites with this problem.

    Thread Starter jarven

    (@jarven)

    Now I installed WF on a site which WF never has been installed to before and guess what?
    SAME PROBLEM…
    "XXXXXX.wp_wfls_settings" doesn't exist

    All other WF-tables are created so there could (should) not be a permission problem if there is other permissions needed.

    Thread Starter jarven

    (@jarven)

    This is pretty weird.

    Can someone send me SQL to create this missing table (wfls_settings)?

    Thread Starter jarven

    (@jarven)

    I found “Unknown storage engine ‘InnoDB'” in error log when WF try to create table.
    Removed “ENGINE=InnoDB” in the SQL-query and it was possible to create table.

    I have now created “wfls_2fa_secrets” and “wfls_settings” tables and WF works as normal.

    How did you created tables “wfls_2fa_secrets” and “wfls_settings” ?

    Hey @jarven,

    My apologies for missing this. I just noticed the last update on the thread as an email notification.

    Thanks for sharing this information, I’ll definitely make note of it.

    @dehery – Can you please start a new thread? Your issue might not be completely the same. Please share any errors or relevant information.

    Thanks,

    Gerroald

    Thread Starter jarven

    (@jarven)

    @dehery 

    
CREATE TABLE IF NOT EXISTS "wfls_2fa_secrets" (
  "id" int(11) unsigned NOT NULL AUTO_INCREMENT,
  "user_id" bigint(20) unsigned NOT NULL,
  "secret" tinyblob NOT NULL,
  "recovery" blob NOT NULL,
  "ctime" int(10) unsigned NOT NULL,
  "vtime" int(10) unsigned NOT NULL,
  "mode" enum('authenticator') NOT NULL DEFAULT 'authenticator',
  PRIMARY KEY ("id"),
  KEY "user_id" ("user_id")
) DEFAULT CHARSET=utf8; 

CREATE TABLE IF NOT EXISTS "wfls_settings" (
  "name" varchar(191) NOT NULL DEFAULT '',
  "value" longblob,
  "autoload" enum('no','yes') NOT NULL DEFAULT 'yes',
  PRIMARY KEY ("name")
) DEFAULT CHARSET=utf8;

    I have 2 sites that I just migrated from Windows on apache with mysql to Linux on Nginx with mysql. I uninstalled everything wordfence related and reinstalled it on both sites. At first, they worked fine. But, after logging out of them and trying to log in again, only one site worked, where the other site got a 502 error. I looked in the logs and had errors complaining about the missing tables above as well. I checked the databases and, sure enough, one DB had the tables, and the other one did not. Can I just copy the two tables from the working site to the non-working site and call it good?

    I have had a similar issue pop up. Due to a rogue plugin update recently, my allotted VPS HDD virtual space filled up overnight with a gigantic error log (ahem, Pretty Links). Consequently, I started receiving Backup Buddy errors on my websites, all of which I have traced to wfls_2fa_secrets and wfls_settings being labeled as “Unknown storage engine ‘InnoDB'” in the WF diagnostics page. I’m not sure what to do with this since I have WF installed on about 20 sites.

    @jarven

    the sql query not work for me, error on syntax

    Thread Starter jarven

    (@jarven)

    Maybe you have to change table prefix from wp_ to your prefix.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘wp_wfls_settings table does not exist’ is closed to new replies.