WordPress database error Unknown column unix_timestamp

  • Resolved chuckingit

    (@chuckingit)


    10 years, 2 months ago

    Hi – each day i get an error message like the recent one below … i’ve deactivated and re-activated plugin but still no … this ip seems to be from google thus i suspect it is a bot that is behind this but ..??.. any thoughts that can be shared are appreciated … cordially, chuck scott

    recent error in php error_log

    [29-Jan-2014 02:11:45 UTC] WordPress database error Unknown column 'unix_timestamp' in 'field list' for query insert IGNORE into wp01_wfVulnScanners (IP, ctime, hits) values (INET_ATON('66.249.66.183'), unix_timestamp(), 1) ON DUPLICATE KEY UPDATE ctime = unix_timestamp, hits = hits + 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, wordfence::templateRedir, wfLog->logLeechAndBlock, wfDB->queryWrite

    http://wordpress.org/plugins/wordfence/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Wordfence Security

    (@mmaunder)

    10 years, 2 months ago

    Hi,

    This is a bug in the current version and it will be fixed in the next release out in the next few days.

    Regards,

    Mark.

    Thread Starter chuckingit

    (@chuckingit)

    10 years, 2 months ago

    @mark – wow – way cool on several fronts -> e.g.,

    a) super fast response / info – thanks …
    b) Wordfence team is on top of error – bravo …
    c) glad to know errors were not me-centric :>0
    d) loving Wordfence so thanks for update and ongoing improvements …
    e) i appreciate these WordPress.org forums / codex where we can learn from each other …

    accordingly, kudos on all fronts and thanks again for info … cordially, chuck scott

    lochand

    (@lochand)

    10 years, 2 months ago

    I’m afraid I don’t know that much about the database. Just happy it’s there. Will the fix remove the error logs. How is this affecting my site, if at all. Will I need to repair anything after the upgrade?

    Plugin Author Wordfence Security

    (@mmaunder)

    10 years, 2 months ago

    This fix was released in 4.0.2. Thanks for the nice reply Chuck, just spotted it now.

    Regards,

    Mark.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error Unknown column unix_timestamp’ is closed to new replies.