Wordfence breaking site suddenly.

Hi cwolff,
any chance you can get a hold of your servers error logs? They should be able to tell us what went wrong.

Seeing a good bit of the following entries:

[06-Jul-2016 13:06:01 UTC] WordPress database error Unknown column ‘statusCode’ in ‘field list’ for query INSERT INTO pdfndr_wfHits (ctime, statusCode, isGoogle, IP, userID, newVisit, URL, referer, UA, jsRun, id) VALUES (‘1467810361.142921’, ‘200’, ‘0’, ‘\0\0\0\0\0\0\0\0\0\0???.\r3’, ‘0’, ‘0’, ‘https://publicdefender.nashville.gov/about-us/frequently-asked-questions/’, ”, ‘Mozilla/5.0 (compatible; bingbot/2.0; +https://www.bing.com/bingbot.htm)’, ‘0’, ‘0’) made by wfLog->logHit, wfModel->save, wfModel->insert
[06-Jul-2016 13:06:15 UTC] WordPress database error Unknown column ‘attackLogTime’ in ‘field list’ for query SELECT MAX(attackLogTime) FROM pdfndr_wfHits made by require(‘E:\publicdefender\public-defender-cms\wp-blog-header.php’), require_once(‘E:\publicdefender\public-defender-cms\wp-load.php’), require_once(‘E:\publicdefender\wp-config.php’), require_once(‘E:\publicdefender\public-defender-cms\wp-settings.php’), do_action(‘plugins_loaded’), wordfence::veryFirstAction

Do these log entries help?

Hi cwolff, sorry for the late reply. Looks like your database tables are corrupt. Possibly several of them. I would suggest you delete all Wordfence tables and try a fresh install of the plugin.

Here is a complete list of the tables if you want to delete them manually

wp_wfBadLeechers
wp_wfBlockedIPLog
wp_wfBlocks
wp_wfBlocksAdv
wp_wfConfig
wp_wfCrawlers
wp_wfFileMods
wp_wfHits
wp_wfHoover
wp_wfIssues
wp_wfLeechers
wp_wfLockedOut
wp_wfLocs
wp_wfLogins
wp_wfNet404s
wp_wfReverseCache
wp_wfScanners
wp_wfStatus
wp_wfThrottleLog
wp_wfVulnScanners