• Resolved calisun

    (@calisun)


    i see non-stop running list error messages in my server logs:

    May 6 01:08:05 x php: WordPress database error Table ‘my-db.wp_wfBlocks7’ doesn’t exist for query SHOW FULL COLUMNS FROMwp_wfBlocks7 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfBlock::findIPBlock
    May 6 01:08:05 x php: WordPress database error Table ‘my-db.wp_wfBlocks7’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wfBlocks7 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfBlock::findIPBlock
    May 6 01:08:07 x php: WordPress database error Table ‘my-db.wp_wfBlocks7’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wfBlocks7 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wordfence/wordfence.php’), wordfence::install_actions, wfBlock::lockoutForIP
    May 6 01:08:07 x php: WordPress database error Table ‘my-db.wp_wfBlocks7’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wfBlocks7 made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wordfence/wordfence.php’), wordfence::install_actions, wfBlock::lockoutForIP

    it looks like it says that table wp_wfBlocks7′ doesn’t exist, but looking at my database, that table is there

    • This topic was modified 7 years, 11 months ago by calisun.
    • This topic was modified 7 years, 11 months ago by calisun.
    • This topic was modified 7 years, 11 months ago by calisun.
Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter calisun

    (@calisun)

    I have Wordfence installed on my system for a long while now, but this is the first time I see these messages, so it must be something wrong with the latest update of Wordfence

    Thread Starter calisun

    (@calisun)

    developers, no response? My log is full of these messages that come in several per second.

    Hi @calisun,

    Are all the checks “OK” (green checkmark) in the “MySQL” section of the “Wordfence –> Tools –> Diagnostics” page?

    Also, can you confirm you see the “wp_wfBlocks7” table listed under the “Database Tables” section?

    Hi @calisun!
    The table is probably crashed. If you are familiar with phpMyAdmin or any other database tool, you can investigate to see if the table is crashed and attempt to restore it. If not, then I recommend that you use Wordfence Assistant to remove all Wordfence tables and reinstall.

    Let me know how it goes!

    Thanks,

    Thread Starter calisun

    (@calisun)

    I did take a look in phpMyAdmin and the table looks fine, no erroneous fields all data is readable. Besides seeing strange characters or data would not be readable, how else would I know if it has crashed?

    Thread Starter calisun

    (@calisun)

    To fix:
    I disabled Wordfence plugin
    Deleted plugin from plugins directory
    Deleted all database fields that started with wfxxxxxxxx

    Uploaded fresh version on Wordfence to plugins directory
    Enabled the plugin.

    Will check my log files in the morning to see if the issue is fixed.

    Thread Starter calisun

    (@calisun)

    Success, no more error messages.
    My guess as to what happened is during last plugin update, I just uloaded latest version of plugin into my server without first disabling the plugin.

    Hi @calisun,
    Thanks for getting back to us to let us know clearing the Wordfence tables solved your issue.

    Resolving this thread for now. Have a great week!

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

The topic ‘error message in server log’ is closed to new replies.