Connection refused

I also get a large number of such errors in error_log

FROM wp_wfblocks7 WHERE type IN (3) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by require(‘wp-blog-header.php’), 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, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfBlock::countryBlocks, wfBlock::allBlocks
[10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wfblocks7’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wfblocks7 made by require(‘wp-blog-header.php’), 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, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfBlock::findIPBlock
[10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wfblocks7’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wfblocks7 made by require(‘wp-blog-header.php’), 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, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfBlock::findIPBlock
[10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wflivetraffichuman’ doesn’t exist for query SHOW FULLCOLUMNS FROM wp_wflivetraffichuman made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wfLog->actionSetRequestJSEnabled, wfLog::isHumanRequest
[10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wflivetraffichuman’ doesn’t exist for query SHOW FULLCOLUMNS FROM wp_wflivetraffichuman made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wfLog->actionSetRequestJSEnabled, wfLog::isHumanRequest
[10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wflivetraffichuman’ doesn’t exist for query SHOW FULLCOLUMNS FROM wp_wflivetraffichuman made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::templateRedir, wordfence::doEarlyAccessLogging, wfLog->logLeechAndBlock, wfRateLimit::mightRateLimit, wfRateLimit::visitorType, wfCrawl::isCrawler, wfLog::isHumanRequest
[10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wflivetraffichuman’ doesn’t exist for query SHOW FULLCOLUMNS FROM wp_wflivetraffichuman made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::templateRedir, wordfence::doEarlyAccessLogging, wfLog->logLeechAndBlock, wfRateLimit::mightRateLimit, wfRateLimit::visitorType, wfCrawl::isCrawler, wfLog::isHumanRequest

I have emailed the diagnostics to [email protected]

Hey @saowp,

I believe this is something your host is going to need to look into. Can you please share the full error for their thoughts? The cURL request could be blocked by a proxy, firewall, or security protocol

wp_remote_post() test to noc1.wordfence.com failed! Response was: cURL error 7: Failed to connect to noc1.wordfence.com port 80: Connection refused

Thanks,

Gerroald

Thank you for your quick response. I opened a ticket at my host, referencing this thread.

In your opinion, are the two observations (cURL error and error_log entries) related to each other?

The host fixed the cURL error, however the error_log is still being populated by WordFence. I have resent the diagnostics email

Hey @saowp,

Thanks for the update, and happy to hear it.

I spoke with some colleagues and they confirmed that this is two separate issues. It seems you have quite a few crashed tables, and also some older versions of our tables. Can you please try deactivating and reactivating Wordfence to regenerate the tables?

If you’d like to save your settings you can export them, be sure to save your token. It’s found in Wordfence > Tools > Import/Export Options.

Also, be sure to check the Delete Wordfence tables and data on deactivation feature. It’s found in Wordfence > All Options > General Wordfence Options.

Please let me know how it goes.

Thanks,

Gerroald

• This reply was modified 5 years, 6 months ago by WFGerroald.

Thanks for the suggestion, @wfgerald I followed your instructions, and not just deactivated but deleted the WordFence plugin and its data. After that, I deleted error_log. After a clean install of WordFence, I notice the error_log entries again. I have again emailed the diagnostics result, please take a look.

Hey @saowp,

I’m not able to find the Diagnostic report. Can you please resend it to [email protected]? Please include your www.ads-software.com username and update this thread after you’ve sent it.

Thanks,

Gerroald

Just did

Hey @saowp,

Thanks for the Diagnostics report.

It seems Wordfence is still missing some of its tables. And the old tables are still present.

Tables missing (prefix wp_, lowercase): wfBlocks7, wfCrawlers, wfTrafficRates, wfLocs, wfReverseCache, wfFileMods, wfBlockedIPLog, wfLiveTrafficHuman

Can you try resetting Wordfence once more using the Wordfrence Assistant, then check to make sure all Wordfence tables are removed? If it doesn’t remove them can you manually delete all Wordfence tables before reinstalling?

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

Please let me know how it goes.

Thanks,

Gerroald

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

Hi @wfgerald , I did as you suggested – deleted the Wordfence plugin followed by deleting all the related tables from the database manually using WP_Optimize. Then I reinstalled Wordfence. However I still get the below error in Table Check

Tables missing (prefix wp_, lowercase): wfBlocks7, wfCrawlers, wfTrafficRates, wfLocs, wfReverseCache, wfFileMods, wfBlockedIPLog, wfLiveTrafficHuman

I have emailed the report yet again.

Hey @saowp,

My apologies for missing this. I’ve been spending today looking through older cases.

Are you still experiencing this? Do you have any site/server/database caching? If so, can you please clear it? You might need to reset Wordfence once more after doing so.

Thanks,

Gerroald

Thanks @wfgerald for following up. After seeing your message, I checked and the tables were still missing. After that I did the following actions:

1. Deactivated the WordFence plugin
2. Deactivated the Autoptimize plugin
3. Migrated the site to a different host
4. Reactivated WordFence and Autoptimize

I now get the message “All Tables Exist” in Diagnostics. I am unsure which of the above steps did the trick, but I am updating this thread status to “Resolved”. Thank you again for your support!