• Resolved jaypabs

    (@jaypabs)


    Hi,

    The operation finished with an error as follows:

    WordPress database error Table 'nf_usermeta' was not locked with LOCK TABLES for query SELECT COUNT(*) FROM (SELECT user_id FROM nf_usermeta WHERE meta_key = 'nf_capabilities' LIMIT 2) AS someusers made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Jetpack::is_single_user_site, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    WordPress database error Table 'nf_options' was not locked with LOCK TABLES for query INSERT INTO <code>nf_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_timeout_jetpack_is_single_user', '1638015357', '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, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Jetpack::is_single_user_site, set_transient, wp_cache_set, W3TC\ObjectCache_WpObjectCache->set, W3TC\ObjectCache_WpObjectCache_Regular->set, W3TC\ObjectCache_WpObjectCache_Regular->_transient_fallback_set, add_option, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    WordPress database error Table 'nf_options' was not locked with LOCK TABLES for query INSERT INTO <code>nf_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_jetpack_is_single_user', '0', '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, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Jetpack::is_single_user_site, set_transient, wp_cache_set, W3TC\ObjectCache_WpObjectCache->set, W3TC\ObjectCache_WpObjectCache_Regular->set, W3TC\ObjectCache_WpObjectCache_Regular->_transient_fallback_set, add_option, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    WordPress database error Table 'nf_options' was not locked with LOCK TABLES for query SELECT option_value FROM nf_options WHERE option_name = '_site_transient_update_plugins' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, do_action('jetpack_sync_before_send_queue_sync'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Modules\Callables->maybe_sync_callables, Automattic\Jetpack\Sync\Modules\Callables->get_all_callables, array_map, Automattic\Jetpack\Sync\Modules\Callables->get_callable, call_user_func, Jetpack::get_updates, wp_get_update_data, get_site_transient, wp_cache_get, W3TC\ObjectCache_WpObjectCache->get, W3TC\ObjectCache_WpObjectCache_Regular->get, W3TC\ObjectCache_WpObjectCache_Regular->_transient_fallback_get, get_site_option, get_network_option, get_option, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    

    WordPress database error Table ‘nf_options’ was not locked with LOCK TABLES for query SELECT option_value FROM nf_options WHERE option_name = ‘jetpack_sync_full_status’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_full_sync, Automattic\Jetpack\Sync\Modules\Full_Sync_Immediately->get_status, Jetpack_Options::get_raw_option, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    WordPress database error Table ‘nf_wfBlocks7’ was not locked with LOCK TABLES for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM nf_wfBlocks7 WHERE type IN (4) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    WordPress database error Table ‘nf_wfBlocks7’ was not locked with LOCK TABLES for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM nf_wfBlocks7 WHERE type IN (3) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::countryBlocks, wfBlock::allBlocks, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    WordPress database error Table ‘nf_wfBlocks7’ was not locked with LOCK TABLES for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM nf_wfBlocks7 WHERE type IN (1, 8, 9, 2, 5, 6) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::ipBlocks, wfBlock::allBlocks, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    WordPress database error Table ‘nf_wfBlocks7’ was not locked with LOCK TABLES for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM nf_wfBlocks7 WHERE type IN (7) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::lockouts, wfBlock::allBlocks, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query`

    There are other errors but it’s similar to the errors above.

    I don’t know if the plugin finish adding keys because the button now says “Revert Keys Now”.

    Is the changing or adding of keys on the tables successfully even with the errors above?

    Thank you

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter jaypabs

    (@jaypabs)

    btw, here’s the id of metadata I uploaded:

    Metadata uploaded to id Tpr2Zesksm

    Plugin Author OllieJones

    (@olliejones)

    If the dashboard tool panel says “revert keys now” then your keys are converted.

    Those queries that failed are from Jetpack and Wordfence. I have not tested this plugin with Wordfence. I’ll take a look.

    I don’t believe these errors relate to my plugin. But I could be wrong.

    Thanks for reporting the problem.

    Thread Starter jaypabs

    (@jaypabs)

    Thanks for the reply.

    There are some other errors above that your plugin selected for indexing. Those are:

    nf_usermeta
    nf_options

    And BTW, how do I know if nf_posts has been successfully changed or added the necessary keys using phpMyAdmin?

    Plugin Author OllieJones

    (@olliejones)

    Do SHOW CREATE TABLE nf_posts and look for the post_author index. If it contains these columns it’s the new index.

    (post_author, post_type, post_status, post_date, ID)

    If it only contains (post_author) it’s the index that came with WordPress.

    More info here. https://www.plumislandmedia.net/wordpress/speeding-up-wordpress-database-operations/#data-definition-language

    • This reply was modified 2 years, 7 months ago by OllieJones.
    Thread Starter jaypabs

    (@jaypabs)

    Thank you very much. It is showing (post_author, post_type, post_status, post_date, ID).

    • This reply was modified 2 years, 7 months ago by jaypabs.
    Plugin Author OllieJones

    (@olliejones)

    There’s a new version of the plugin out there, 1.4.1, that’s tested with WP Total Cache’s database cache. Please give it a try, it should solve your problem.

    Thanks for your patience!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Table ‘nf_options’ was not locked’ is closed to new replies.