Database wp_capabilities error being logged

  • Resolved barnez

    (@pidengmor)


    4 years, 5 months ago

    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 4 years, 5 months 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.

    Thread Starter barnez

    (@pidengmor)

    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.

    Thread Starter barnez

    (@pidengmor)

    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)
  • The topic ‘Database wp_capabilities error being logged’ is closed to new replies.