Title: WordPress database error Unknown column unix_timestamp
Last modified: August 21, 2016

---

# WordPress database error Unknown column unix_timestamp

 *  Resolved [chuckingit](https://wordpress.org/support/users/chuckingit/)
 * (@chuckingit)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-unix_timestamp/)
 * 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/](http://wordpress.org/plugins/wordfence/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Mark Maunder](https://wordpress.org/support/users/mmaunder/)
 * (@mmaunder)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-unix_timestamp/#post-4555999)
 * 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](https://wordpress.org/support/users/chuckingit/)
 * (@chuckingit)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-unix_timestamp/#post-4556005)
 * [@mark](https://wordpress.org/support/users/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](https://wordpress.org/support/users/lochand/)
 * (@lochand)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-unix_timestamp/#post-4556152)
 * 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 [Mark Maunder](https://wordpress.org/support/users/mmaunder/)
 * (@mmaunder)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-unix_timestamp/#post-4556157)
 * 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.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [Mark Maunder](https://wordpress.org/support/users/mmaunder/)
 * Last activity: [12 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-unix_timestamp/#post-4556157)
 * Status: resolved