Title: SQL errors in log
Last modified: August 31, 2016

---

# SQL errors in log

 *  Resolved [stefhz](https://wordpress.org/support/users/stefhz/)
 * (@stefhz)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-errors-in-log-1/)
 * Hi – I lately see lots of these errors … not sure if they are caused by this 
   plugin, but since it’s referenced in the sql statement, I wanted to run it by
   you… Thx for any help
 * WordPress database error Column ‘value’ cannot be null for query REPLACE INTO`
   wp_wsal_metadata` (`id`, `occurrence_id`, `name`, `value`) VALUES (0, 34209, ‘
   ClientIP’, NULL) made by do_action_ref_array, call_user_func_array, WpSecurityAuditLog-
   >CleanUp, call_user_func, WSAL_Loggers_Database->CleanUp, do_action(‘wsal_prune’),
   call_user_func_array, WSAL_Sensors_System->EventPruneEvents, WSAL_AlertManager-
   >Trigger, WSAL_AlertManager->_CommitItem, WSAL_AlertManager->Log, WSAL_Loggers_Database-
   >Log, WSAL_Models_Occurrence->SetMeta, WSAL_Models_Occurrence->SetMetaValue, 
   WSAL_Models_Meta->SaveMeta, WSAL_Adapters_MySQL_ActiveRecord->Save
 * [https://wordpress.org/plugins/wp-security-audit-log/](https://wordpress.org/plugins/wp-security-audit-log/)

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

 *  [WPWhiteSecurity](https://wordpress.org/support/users/wpwhitesecurity/)
 * (@wpwhitesecurity)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-errors-in-log-1/#post-7035885)
 * Hello Stefhz,
 * Thank you for reporting this issue. We can confirm that we can reproduce such
   issue, hence we will be working on a fix and will release an update shortly.
 * Please follow the [plugin’s blog](http://www.wpsecurityauditlog.com/blog/) so
   you are alerted when a new update is released.
 *  [WPWhiteSecurity](https://wordpress.org/support/users/wpwhitesecurity/)
 * (@wpwhitesecurity)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-in-log-1/#post-7035967)
 * Hello stehz,
 * We had a bit of a misunderstanding and we were not able to replicate this issue.
 * The problem you are encountering is that for some reason, the plugin is trying
   to write an entry to the database and instead of reporting an IP address it is
   reporting NULL.
 * This should never be the case. Can you please give me more information about 
   your setup?
 * Do you have a WAF or smoething similar in front of your WordPress?
 * Is the plugin working correctly or you’re seeing some entries without an IP address
   in the audit log viewer?
 * Looking forward to hearing from you.

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

The topic ‘SQL errors in log’ is closed to new replies.

 * ![](https://ps.w.org/wp-security-audit-log/assets/icon-256x256.png?rev=2961534)
 * [WP Activity Log](https://wordpress.org/plugins/wp-security-audit-log/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-security-audit-log/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-security-audit-log/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-security-audit-log/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-security-audit-log/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-security-audit-log/reviews/)

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 2 replies
 * 2 participants
 * Last reply from: [WPWhiteSecurity](https://wordpress.org/support/users/wpwhitesecurity/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/sql-errors-in-log-1/#post-7035967)
 * Status: resolved