Wordfence not saving some settings to database

  • Resolved ipadmin789654

    (@ipadmin789654)


    4 years, 6 months ago

    Hello,

    I am not able to save the google reCaptcha settings. it stays blank and I get WF log errors. I only have this issue with WF.

    [09-Sep-2020 11:52:17 UTC] WordPress database error Table ‘wordpress.wp_wfls_settings’ doesn’t exist for query SELECT name, value, autoload FROM wp_wfls_settings WHERE name = ‘recaptcha-test-mode’ made by do_action(‘wordfence-0_page_WFLS’), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_menu, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/page.php’), WordfenceLS\Model_View->__toString, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/settings.php’), WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/settings/options.php’), WordfenceLS\Controller_Settings->get_bool, WordfenceLS\Controller_Settings->get, WordfenceLS\Settings\Model_DB->get
    [09-Sep-2020 11:52:17 UTC] WordPress database error Table ‘wordpress.wp_wfls_settings’ doesn’t exist for query SELECT name, value, autoload FROM wp_wfls_settings WHERE name = ‘delete-deactivation’ made by do_action(‘wordfence-0_page_WFLS’), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_menu, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/page.php’), WordfenceLS\Model_View->__toString, WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/page/settings.php’), WordfenceLS\Model_View->render, include(‘/plugins/wordfence/modules/login-security/views/settings/options.php’), WordfenceLS\Controller_Settings->get_bool, WordfenceLS\Controller_Settings->get, WordfenceLS\Settings\Model_DB->get
    [09-Sep-2020 11:52:18 UTC] WordPress database error Table ‘wordpress.wp_wfls_settings’ doesn’t exist for query SELECT name, value, autoload FROM wp_wfls_settings WHERE name = ‘allow-xml-rpc’ made 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
    [09-Sep-2020 11:52:27 UTC] WordPress database error Table ‘wordpress.wp_wfls_settings’ doesn’t exist for query SELECT name, value, autoload FROM wp_wfls_settings WHERE name = ‘allow-xml-rpc’ made 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
    [09-Sep-2020 11:53:18 UTC] WordPress database error Table ‘wordpress.wp_wfls_settings’ doesn’t exist for query SELECT name, value, autoload FROM wp_wfls_settings WHERE name = ‘allow-xml-rpc’ made by 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
    [09-Sep-2020 11:53:18 UTC] WordPress database error Table ‘wordpress.wp_wfls_settings’ doesn’t exist for query SELECT name, value, autoload FROM wp_wfls_settings WHERE name = ‘allow-xml-rpc’ made by 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
    [09-Sep-2020 11:53:19 UTC] WordPress database error Table ‘wordpress.wp_wfls_settings’ doesn’t exist for query SELECT name, value, autoload FROM wp_wfls_settings WHERE name = ‘allow-xml-rpc’ made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_admin_init, WordfenceLS\Controller_Settings->get_bool, WordfenceLS\Controller_Settings->get, WordfenceLS\Settings\Model_DB->get
    [09-Sep-2020 11:53:19 UTC] WordPress database error Table ‘wordpress.wp_wfls_settings’ doesn’t exist for query SELECT name, value, autoload FROM wp_wfls_settings WHERE name = ‘recaptcha-test-mode’ made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, WordfenceLS\Controller_WordfenceLS->_admin_init, WordfenceLS\Controller_Settings->get_bool, WordfenceLS\Controller_Settings->get, WordfenceLS\Settings\Model_DB->get

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support WFAdam

    (@wfadam)

    Hello @ipadmin789654 and thanks for reaching out to us!

    It looks like the table wordpress.wp_wfls_settings might need to be repaired.

    By default, if you disable Wordfence, the database tables will remain in place with their data. This is to ensure that if you accidentally or temporarily disable Wordfence, you won’t lose your configuration or the data you have accumulated like the live traffic data.

    If you would like to remove all Wordfence data when you deactivate the plugin, check this box and when you disable the plugin all tables, entries in the WordPress options table, scheduled jobs, and any other stored data associated with Wordfence will be removed.

    Note that this does not include Login Security settings and tables, which have a similar option at the bottom of the Login Security settings page. This allows you to leave those settings in place if you are switching to the standalone Wordfence Login Security plugin. This will be simplified in an upcoming version.

    If you then reactivate Wordfence after removing all tables and data, it will appear as if it has been activated on your website for the first time.

    I always recommend backing up your site prior to doing this, just in case. You can also export settings so you can import them after you repair the tables.
    https://www.wordfence.com/help/tools/import-export/?utm_source=plugin&utm_medium=pluginUI&utm_campaign=docsIcon

    Let me know how this goes!

    Thanks!

    Thread Starter ipadmin789654

    (@ipadmin789654)

    thank you, I checked my database user settings and it did not have create access. I updated the database user access, un-installed and deleted wordfence then re-installed and it works. thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Wordfence not saving some settings to database’ is closed to new replies.