codings
Forum Replies Created
-
I now have a site that has been down for days. There are others who have posted about similar issues in this forum. After updating, the following errors are causing a resource spikes:
WordPress database error Commands out of sync; you can't run this command now for query UPDATEwp_12345_optionsSEToption_value= '1720413355' WHEREoption_name= '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, update_optionWordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_12345_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->is_enqueued, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_optionWordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_12345_options WHERE option_name = 'woocommerce_hpos_legacy_data_cleanup_in_progress' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->is_flag_set, get_optionHPOS was activated because I was trying everything. There are 0 new orders pending and the site has been down for days, so thanks to the latest WP/WC update, there have been 0 orders for these days. But with HPOS active it caused a sync pending orders queue. When it ran the sync, all the Completed orders went to “Pending Payment” and it sent hundreds of new order emails to the admin email address.
Before it could do further damage and overload email or something else, I told you a restored a previous database and file set, so there is no sync process to finish.
Please help me figure this out. Thank you.
Server error log:
WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_12345_options WHERE option_name = 'wc_pending_batch_processes' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->is_enqueued, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_optionWordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_12345_options WHERE option_name = 'woocommerce_hpos_legacy_data_cleanup_in_progress' LIMIT 1 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->is_flag_set, get_optionWC Status Logs:
Uncaught RuntimeException: Unable to claim actions. Database error. in /12345/site.com/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php:696
Server stats:
58 % CPU usage / 170 MB RAM usage / lsphp:site.com/public_html/index.php
Installed the official Action Scheduler plugin. It does nothing so far. Site health: Good. No critical warnings.
Constant 503 errors and overloaded server since updating to WP 6.5.4 / WC 8.9.2. Traffic down, orders stopped, Google sent a notice that they can’t access the site, so it will affect SEO as well.
I reverted to a previous fileset and database from before updating. Still getting intermitent 503 errors. Here is what the Features looks like at the moment. WooCommerce Legacy REST API plugin is active.
I have removed the incompatible plugin (Easy Pixels) and turned on compatibility mode. I also switched to High-performance order storage (recommended).
Maybe I don’t need the WooCommerce Legacy REST API plugin that WC installed and activated?
Hi, thank you for your help. With the server’s constant 503 errors it is not easy to get the information you requested. I will keep trying.
The only changes made to the site were to update the core and plugins, including WooCommerce.
Forum: Plugins
In reply to: [Easy Table of Contents] PHP MBString Extension is not enabled… but it isSorry for wasting your time with this one… the warning message is gone. Now I’m thinking it was a hosting issue (edit: also, I updated to PHP 8.1 from 8.0, so maybe that fixed it, or the overall reset from switching PHP versions fixed it, either way it seems fixed). If it comes back I will let you know, but for now it’s ok. Thank you again for this excellent plugin and the work you do to maintain it.
- This reply was modified 2 years, 2 months ago by codings.
Forum: Plugins
In reply to: [All-In-One Security (AIOS) – Security and Firewall] iframe being blockedThank you.
Forum: Plugins
In reply to: [All-In-One Security (AIOS) – Security and Firewall] iframe being blockedThank you but I’d call that more of a workaround than solved. What happens if you want “Deny bad query strings” active but are also using a plugin such as PDFjs Viewer – Embed PDFs that uses iframes to display content on the site? I’m not even sure what that has to do with bad query strings… it does use query strings, but not bad ones 😛
Here is the query string:
URL/wp-content/plugins/pdfjs-viewer-shortcode/pdfjs/web/viewer.php?file=https://site.com/wp-content/uploads/2024/03/FILE.pdf&attachment_id=1546745&dButton=false&pButton=true&oButton=false&sButton=true#zoom=auto&pagemode=none&_wpnonce=a45645Yes, thank you again 🙂
- This reply was modified 2 years, 4 months ago by codings.
Amazing! Worked flawlessly. Excellent support.
I will find a way to spend money with your company (buying pro, etc). Thanks again!
Hi, in the plugin WP Crontrol, fs_data_sync_magic-post-thumbnail is listed in the events, but for Action it says: None. Is this normal?
Cron is not fetching the images.
I set up the cron as you recommended. Will report back. Thank you.
Ok. Strange that not all posts are fetched. If you manually do a generation for posts without images, will images be generated?
Yes, manual fetching works flawlessly. So what I need to do several times per day is go to the admin posts list, check the box of the ones that do not have a featured image (added a function to show featured images in a column, but FIFU plugin also has this ability), then go to the drop down and select Generate Featured Images and apply. It then goes to the MPT Bulk Generation screen and fetches the thumbs from Google.
It’s strange that this file is still there after your update, but if the security check offers you to delete the file, you can do that, it’s not used by the plugin anymore.
Server security auto deleted the file. Figured it was something else you were using but not your code. Also, everything still ran fine without it. Maybe it’s still there because of running the premium version? Or are the file sets exactly the same?