SQL errors in log

  • Resolved stefhz

    (@stefhz)


    8 years, 2 months ago

    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/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    8 years, 2 months ago

    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 so you are alerted when a new update is released.

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    8 years, 2 months ago

    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.

Tags