Error log flooded by "Unknown column 'attackLogTime' in 'field list'"

  • Hello,
    I’m getting this every 10 seconds in the php error log:

    [04-May-2016 14:40:20 UTC] WordPress errore sul database Unknown column 'attackLogTime' in 'field list' per la query SELECT MAX(attackLogTime) FROM blog_wfHits fatta da 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

    What’s happening? It seems like the database is missing a column..?

    https://www.ads-software.com/plugins/wordfence/

Viewing 6 replies - 16 through 21 (of 21 total)

  • Couldn’t deactivate WF, so deleted folder
    Deleted 2 entries from options table & left other tables
    Installed WF and activated, but fields not added
    Deleted options data again and all wf tables
    Tried to activate, but said “Fatal Error”
    – wfHits table created, but has wrong fields shown below
    Deleted options data again and all wf tables
    Tried to delete the plugin from within admin, but just redirected to site 404
    Deleted plugin via shell
    Still can’t get it to activate
    Added debug line to wp-config, but nothing obvious
    Reverted back to working site

    If I get some time later I’ll dig further…

    Can you see anything in the server error logs?

    Nothing obvious in the logs, but I just set up a new VMWare instance to test this without affecting the live site.

    I’ll post if/when I find anything concrete.

    I finally have the answer – had to increase the memory for this WP install (had to bump max mem in php.ini first) in wp-config:
    define(‘WP_MEMORY_LIMIT’, ‘512M’);
    define(‘WP_MAX_MEMORY_LIMIT’, ‘512M’);

    The default WP max of 256M wasn’t even enough.

    Without setting both parameters I couldn’t deactivate or even reactivate (after physically deleting the WF folder and then unzipping it again).

    Here are the WF table record counts:
    wfFileMods 4k
    wfHits 1k
    wfLeechers 58k
    wfNet404s 16k
    wfScanners 31k
    wfStatus 40k

    So all along it was a simple memory issue and this alone prevented WF from running the install/upgrade routines fully.

    LMK if you want me to try or test anything else…

    Hello Digitsoft,
    that’s very odd I haven’t seen anyone needing 512 megs to install before! Would you consider sending me a diagnostics report on that site so I can file that with the issue in case we need to look in to it.

    Go to Wordfence “Diagnostics” page and at the bottom click the button that says “Send Report by Email”. Change the prefilled address to [email protected] and please provide your username so I know who the mail is coming from. Thanks in advance!

    Done.

    LMK if you need any further info.

Viewing 6 replies - 16 through 21 (of 21 total)
  • The topic ‘Error log flooded by "Unknown column 'attackLogTime' in 'field list'"’ is closed to new replies.