Support » Plugin: NinjaFirewall (WP Edition) - Advanced Security » Database wp_capabilities error being logged

  • Resolved barnez

    (@pidengmor)


    Hi,

    I’m seeing this error being logged in the databases of my sites that run NinjaFirewall:

    
        ( wp_usermeta.meta_key = 'wp_capabilities' AND wp_usermeta.meta_value LIKE '%\"administrator\"%' )
      )
    ) ORDER BY user_login ASC  made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, nf_get_dbdata, get_users, WP_User_Query->__construct, WP_User_Query->query
    [26-May-2020 01:24:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_timeout_nfw_db_check', '1590456348', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, set_transient, add_option
    [26-May-2020 01:24:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_nfw_db_check', '1', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>) made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, nf_check_dbdata, set_transient, add_option
    

    The troubleshooting script is showing an issue with the user capabilities:
    Error: missing manage_options capability - Error: missing unfiltered_html capability

    Should I try a database repair?

    Thanks.

    *UPDATE*
    If I deactivate any single plugin (NF or other) then the error is removed from the wp-check.php output. Then, if I activate that plugin again, the error does not return.

    • This topic was modified 2 months, 1 week ago by barnez. Reason: Result of deactivating and reactivating plugin
Viewing 4 replies - 16 through 19 (of 19 total)
  • Plugin Author nintechnet

    (@nintechnet)

    Is the “enfold” theme installed on all the sites that have this issue?
    Most queries I saw was related to it.

    That’s correct, yes. The Enfold theme is installed on all sites.

    Plugin Author nintechnet

    (@nintechnet)

    There could be a SQL query that takes a bit too long to execute.
    Not a huge issue here, as long as it happens seldom there’s no need to worry about it, NF sends that SQL query every minute or so.

    Great. I really appreciate you looking into this. Indeed, the site front-ends are unaffected, so I will ignore those very occasional logged errors. It was interesting to view the SQL queries. I can see that NinjaFirewall is very active in the background.

    I’ll mark this as resolved. Thanks!

Viewing 4 replies - 16 through 19 (of 19 total)
  • You must be logged in to reply to this topic.