Database error with version 2.5.5: “Column ‘occurrence_id’ cannot be null”

  • Resolved Jos Klever

    (@josklever)


    9 years, 8 months ago

    [Wed Sep 28 09:13:13.916417 2016] [proxy_fcgi:error] [pid 13280:tid 140407595706112] [client 84.241.192.214:59764] AH01071: Got error 'PHP message: WordPress databasefout Column 'occurrence_id' cannot be null bij query REPLACE INTOwp_wsal_metadata(id,occurrence_id,name,value) VALUES (NULL, NULL, NULL, 'http://xxxxxxxxxxx/wp-content/uploads/wp-security-audit-log/404s/20160928_84.241.192.214.log') gemaakt door require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WSAL_Sensors_System->Event404, WSAL_Models_Occurrence->UpdateMetaValue, WSAL_Models_Meta->UpdateByNameAndOccurenceId, WSAL_Models_Meta->SaveMeta, WSAL_Adapters_MySQL_ActiveRecord->Save\n'

    This is happening on multiple sites I manage.

Viewing 6 replies - 1 through 6 (of 6 total)
  • WPWhiteSecurity

    (@wpwhitesecurity)

    9 years, 8 months ago

    Hello Jos,

    Sorry to hear you are encountering such a problem. Just to confirm; you’re seeing this in upgrades and not in new installs, correct?

    Also, is it happening on all the sites or just a few? If it is happening on just a few, do these websites have something in common?

    Looking forward to hearing from you.

    WPWhiteSecurity

    (@wpwhitesecurity)

    9 years, 8 months ago

    Hello Jos,

    I can confirm that we identified the issue and are working on a fix. The fix will be online in less than an hour. Sorry if this has caused any inconvenience.

    Thread Starter Jos Klever

    (@josklever)

    9 years, 8 months ago

    Great that you’ve found it. 🙂 I’ll wait for the fix and let you know the result.

    WPWhiteSecurity

    (@wpwhitesecurity)

    9 years, 8 months ago

    Hello Jos,

    We just released version 2.5.6 which is basically a hotfix for the reported issue. Thank you very much for reporting this and sorry if it created any inconvenience. Please do not hesitate to get in touch in case of any further queries.

    Have a good day.

    Thread Starter Jos Klever

    (@josklever)

    9 years, 8 months ago

    No more errors yet, so it looks like this is solved. Thanks!

    WPWhiteSecurity

    (@wpwhitesecurity)

    9 years, 8 months ago

    Glad it is solved!

    It seems you use our plugin on multiple websites. Would appreciate if you can rate the plugin and give us some feedback. Thank you very much in advance for your time and have a good day.

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

The topic ‘Database error with version 2.5.5: “Column ‘occurrence_id’ cannot be null”’ is closed to new replies.