attosoftonline

P.S. The?wp_users?table is okay.
The?wp_usermeta?table is okay.
The?wp_posts?table is okay.
The?wp_comments?table is okay.
The?wp_links?table is okay.
The?wp_options?table is okay.
The?wp_postmeta?table is okay.
The?wp_terms?table is okay.
The?wp_term_taxonomy?table is okay.
The?wp_term_relationships?table is okay.
The?wp_termmeta?table is okay.
The?wp_commentmeta?table is okay.
The?wp_woocommerce_payment_tokenmeta?table is okay.
The?wp_woocommerce_order_itemmeta?table is okay.
The?wp_wc_product_meta_lookup?table is okay.
The?wp_wc_tax_rate_classes?table is okay.
The?wp_wc_reserved_stock?table is okay.
The?wp_actionscheduler_actions?table is okay.
The?wp_actionscheduler_claims?table is okay.
The?wp_actionscheduler_groups?table is okay.
The?wp_actionscheduler_logs?table is okay.
The?wp_wc_category_lookup?table is okay.

I’ve found some kind of errors here: https://www.ads-software.com/support/topic/database-error-commands/

Sorry. The problem is not solved..

Server architecture

Linux 5.14.0-362.24.2.el9_3.x86_64 x86_64

Web server

LiteSpeed

PHP version

8.3.6 (Supports 64bit values)

PHP SAPI

litespeed

PHP max input variables

1000

PHP time limit

30

PHP memory limit

368M !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Max input time

60

Upload max filesize

4M

PHP post max size

8M

cURL version

7.76.1 OpenSSL/3.0.7

Is SUHOSIN installed?

No

Is the Imagick library available?

Yes

Are pretty permalinks supported?

Yes

.htaccess rules

Your .htaccess file contains only core WordPress features.

……………

[26-Jul-2024 03:42:27 UTC] WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wp_options SET option_value = ‘1724557347’ WHERE option_name = ‘_transient_timeout_woocommerce_blocks_asset_api_script_data’ 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, update_option
[26-Jul-2024 04:42:28 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’wc_schedule_pending_batch_processes’ AND a.status IN (‘in-progress’, ‘pending’) LIMIT 0, 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions
[26-Jul-2024 04:42:28 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_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\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
[26-Jul-2024 04:42:28 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT autoload FROM wp_options WHERE option_name = ‘_transient_timeout_woocommerce_blocks_asset_api_script_data’ LIMIT 1 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, update_option
[26-Jul-2024 04:42:28 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options 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, update_option

———————

I said to wait, to see what happens overnight, when the site was not accessed by anyone..

And it’s strange that ( as WooCommerce is note – Log files are stored in this directory:?public_html/wp-content/uploads/wc-logs/ ) , this folder are NOT contain any logs.

The log file is appeared in public_html/error_log

Thanks for advice!

Realy strange. Another error. ?! (and note that the site was not accessed by anybody during this time, to say that the errors are generated because accessing process)..

[25-Jul-2024 05:42:07 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options 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, update_option

I will try to reinstall all site for the third time, to see what’s happend..

( I use WordPress 6.6.1 and WooCommerce 9.1.2 )

Thank for your answer. My site has only Akismet Anti-spam: Spam Protection, WPBakery Page Builder, UpSolution Core ( from Impreza theme ) and… WooCommerce plugins.

It seems that the error is gone, but now I have a smaller error log file, containing:

[23-Jul-2024 15:11:31 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_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\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option

What is it?

message sent..

Sorry, but I cannot find Automatically Complete WooCommerce Orders , or is disabled by default.

https://prnt.sc/pO105fP7iHEO

Please, help..

Thank you!

Hello,

I am interested in your solution. Can you show us a printscreen of this feature?

Thank you!

Do you have any recomandations regarding this featured?

Thanks.

Thank you for answer!

another line

Warning: Undefined array key “listings” in?/public_html/wp-content/plugins/classified-listing/app/Models/Listing.php?on line?1506

your plugin support wpbakery ? ( visual composer )

thank you!

this issues was permanently, since the plugin was installed on a test site with classifieds plugin adforest – themeforest.net/item/adforest-classified-wordpress-theme/19481695

was solved on reinstall wordpress

Let’s say, 5 colums.

And another problem: in your plugin description, say “title_element (the element that wraps the name of the user/author, defaults to div, can be any element, for example h2)”.

Sometimes, between h2 and h3, the diference is too big. Can you correct me on this case?

[authors_list title_element=”18px”}

Thank you!

P.S. Do you have some premium features at this plugin?

from the first, it caught my attention. I have been dealing with marketing for more than 16 years…

good luck!

on the frontend of site!!

https://prnt.sc/1nxifV3F0D-6