• Resolved cassieleung

    (@cassieleung)


    Hi,

    I’ve been getting the following error messages (which I think began after updating to the latest version of the plugin) and it’s causing an internal 500 server error because it’s overwhelming my error log.

    [Dec 15 21:55:02:1481867702.863474:2:error] Error writing value for vulnerabilities_theme (MySQLi error: [1054] Unknown column ‘autoload’ in ‘field list’)
    [Dec 15 21:55:02:1481867702.754382:2:error] Error writing value for vulnerabilities_plugin (MySQLi error: [1054] Unknown column ‘autoload’ in ‘field list’)

    Is this related to the theme vulnerability checking and if so, is there a way to fix this?

    Thanks,
    Cassie

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter cassieleung

    (@cassieleung)

    Also, this is the error message that shows up in my error log over and over:

    [16-Dec-2016 00:14:19 UTC] WordPress database error Unknown column ‘autoload’ in ‘field list’ for query SELECT name, val, autoload FROM wp_wfConfig WHERE name = ‘isPaid’ 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’), call_user_func_array, wordfence::veryFirstAction, wfConfig::get
    [16-Dec-2016 00:14:19 UTC] WordPress database error Unknown column ‘autoload’ in ‘field list’ for query SELECT name, val, autoload FROM wp_wfConfig WHERE name = ‘isPaid’ 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’), call_user_func_array, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfConfig::get
    [16-Dec-2016 00:14:20 UTC] WordPress database error Unknown column ‘statusCode’ in ‘field list’ for query INSERT INTO wp_wfHits (ctime, statusCode, isGoogle, IP, userID, newVisit, URL, referer, UA, jsRun) VALUES (‘1481847259.513579’, ‘404’, ‘0’, ‘\0\0\0\0\0\0\0\0\0\0▒▒K▒ʩ’, ‘0’, ‘0’, ‘http://illknowitwheniseeit.com/apple-touch-icon.png’, ”, ‘MobileSafari/602.1 CFNetwork/808.1.4 Darwin/16.1.0’, ‘0’) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/x/404.php’), x_get_view, get_template_part, locate_template, load_template, require(‘/themes/x/framework/views/icon/wp-404.php’), get_header, locate_template, load_template, require_once(‘/themes/x/header.php’), x_get_view, get_template_part, locate_template, load_template, require(‘/themes/x/framework/views/icon/wp-header.php’), x_get_view, get_template_part, locate_template, load_template, require(‘/themes/x/framework/views/global/_header.php’), wp_head, do_action(‘wp_head’), call_user_func_array, wordfence::wfLogHumanHeader, wfLog->logHit, wfModel->save, wfModel->insert
    [16-Dec-2016 00:14:20 UTC] WordPress database error Unknown column ‘statusCode’ in ‘field list’ for query INSERT INTO wp_wfHits (ctime, statusCode, isGoogle, IP, userID, newVisit, URL, referer, UA, jsRun, id) VALUES (‘1481847259.513579’, ‘404’, ‘0’, ‘\0\0\0\0\0\0\0\0\0\0▒▒K▒ʩ’, ‘0’, ‘0’, ‘http://illknowitwheniseeit.com/apple-touch-icon.png’, ”, ‘MobileSafari/602.1 CFNetwork/808.1.4 Darwin/16.1.0’, ‘0’, ‘0’) made by wfLog->logHit, wfModel->save, wfModel->inser

    Hi Cassie,
    It seems that the plugin’s database tables are corrupted, I suggest enabling “Delete Wordfence tables and data on deactivation” under (Wordfence > Options), then deactivate the plugin and re-activate it again.

    Thanks.

    Thread Starter cassieleung

    (@cassieleung)

    Hi,

    It turns out this issue was related to database permissions, which seemed to resolve the issue. I did also remove Wordfence and reinstall. As an FYI for anyone else running into similar issues, the suggestion you made about selecting “deleting tables and data on deactivation” as a setting didn’t work. Wordfence assistant didn’t remove the data or files either. I had to manually drop them from the DB.

    Cheers!

    Most probably “deleting tables and data on deactivation” doesn’t work because your database user doesn’t have the required permissions, hopefully after you have fixed this issue, it should be working fine.

    Thanks.

    Hi,

    I’m getting the same error and the Delete on Deactivation doesn’t do the trick. How do I manually delete the db files like Cassie did? Through phpMyAdmin?

    You should first make sure that the database user has all privileges, but of course you can drop these tables manually from the database via phpMyAdmin.

    Thanks.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Error writing value for vulnerabilities_theme’ is closed to new replies.