We run a small business and recently received these, but we do not know what they are or how they got here. They say "pending payment" but have no customer information.
We have PayPal, Afterpay, and direct bank transfer, but none of them work and they all result in an error. it was working for years before this. error is: "There was an error processing your order. Please check for any charges in your payment method and review your order history before placing the order again." at top of cart when people pay.
You can use this one - [https://wordpress.org/plugins/pymntpl-paypal-woocommerce/](https://wordpress.org/plugins/pymntpl-paypal-woocommerce/)
It has no issues.
I have this in my debug log:
\[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query SELECT option\_value FROM wpaw\_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\_option, QM\_DB->query
\[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query SELECT option\_value FROM wpaw\_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\_option, QM\_DB->query
\[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query SELECT option\_value FROM wpaw\_options WHERE option\_name = 'action\_scheduler\_lock\_async-request-runner' made by shutdown\_action\_hook, do\_action('shutdown'), WP\_Hook->do\_action, WP\_Hook->apply\_filters, ActionScheduler\_QueueRunner->maybe\_dispatch\_async\_request, ActionScheduler\_Lock->is\_locked, ActionScheduler\_OptionLock->get\_expiration, ActionScheduler\_OptionLock->get\_existing\_lock, QM\_DB->query
\[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query SELECT option\_value FROM wpaw\_options WHERE option\_name = 'action\_scheduler\_lock\_async-request-runner' made by shutdown\_action\_hook, do\_action('shutdown'), WP\_Hook->do\_action, WP\_Hook->apply\_filters, ActionScheduler\_QueueRunner->maybe\_dispatch\_async\_request, ActionScheduler\_OptionLock->set, ActionScheduler\_OptionLock->get\_existing\_lock, QM\_DB->query
\[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO \`wpaw\_options\` (\`option\_name\`, \`option\_value\`, \`autoload\`) VALUES ('action\_scheduler\_lock\_async-request-runner', '667a4b70156050.07271713|1719290796', 'no') made by shutdown\_action\_hook, do\_action('shutdown'), WP\_Hook->do\_action, WP\_Hook->apply\_filters, ActionScheduler\_QueueRunner->maybe\_dispatch\_async\_request, ActionScheduler\_OptionLock->set, QM\_DB->query
\[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query UPDATE \`wpaw\_options\` SET \`option\_value\` = '1721882736' WHERE \`option\_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, update\_option, QM\_DB->query
The error message you're encountering, "Commands out of sync; you can't run this command now," indicates an issue with how MySQL queries are being handled in your WordPress site. This typically occurs when there is an attempt to run a new query while the previous query is still being processed or there was an error in handling the previous query.
1. Your database connection might be getting reset or interrupted, leading to incomplete query executions.
2. Plugins, particularly those interacting with the database frequently, might be causing conflicts. In your case, the error logs mention WooCommerce and its components (like `Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup` and `ActionScheduler`).
3. Corrupted database tables can cause synchronization issues with queries.
4. If your server is running out of memory or processing power, it can lead to incomplete query executions.
5. You can use a plugin like WP-DBManager or run the following queries in phpMyAdmin to check and repair your database tables:
CHECK TABLE wpaw\_options;
REPAIR TABLE wpaw\_options;
6. Increase the memory limit in your `wp-config.php` file:
define('WP\_MEMORY\_LIMIT', '256M');
define('WP\_MAX\_MEMORY\_LIMIT', '512M');
(you can do it from Cpanel as well)
7. Before making any changes, ensure you have a complete backup of your database.
Ensure that WordPress, WooCommerce, and all other plugins are updated to their latest versions.
There is nothing noted in the order notes. When customers try to pay at the end of checkout, they see this error message at the top. "There was an error processing your order. Please check for any charges in your payment method and review your order history before placing the order again."
Looks like the webhook back from paypal to woocommerce isn’t configured properly, so when the payment completes on PayPal it isn’t pinging back to your store to update it
We had this on PayPal payments but the PayPal dashboard was showing the payment being received and the order still marked as pending on Woocommerce. We have an ongoing issue with PHP versions at the moment. These can’t be resolved for another three weeks.
In the end I noticed that Woocommerc had updated itself to the very latest version that our version of PHP allows. I rolled back to a very old versions (mid 2022) of Woocommerce. At the moment, all working fine.
We’re moving to a new server with latest versions of PHP. Once we’re there, we’ll be updating everything including the PayPal plugin and looking at Stripe as well.
We run a small business and recently received these, but we do not know what they are or how they got here. They say "pending payment" but have no customer information.
Did you integrate any payment processor? Maybe it is showing from test mode.
We have PayPal, Afterpay, and direct bank transfer, but none of them work and they all result in an error. it was working for years before this. error is: "There was an error processing your order. Please check for any charges in your payment method and review your order history before placing the order again." at top of cart when people pay.
Which paypal plugin are you using? Paypal by Woocommerce?
Yes, "WooCommerce PayPal Payments" by "Version 2.8.0 | By WooCommerce"
Deactivate this plugin and install other paypal plugin and test the plugin on sandbox.
What paypal plugin do you recommend?
You can use this one - [https://wordpress.org/plugins/pymntpl-paypal-woocommerce/](https://wordpress.org/plugins/pymntpl-paypal-woocommerce/) It has no issues.
I'm not sure to be honest, we have a different website with same payment system and it works fine, just our site. so I'm not sure its PayPal.
I have this in my debug log: \[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query SELECT option\_value FROM wpaw\_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\_option, QM\_DB->query \[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query SELECT option\_value FROM wpaw\_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\_option, QM\_DB->query \[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query SELECT option\_value FROM wpaw\_options WHERE option\_name = 'action\_scheduler\_lock\_async-request-runner' made by shutdown\_action\_hook, do\_action('shutdown'), WP\_Hook->do\_action, WP\_Hook->apply\_filters, ActionScheduler\_QueueRunner->maybe\_dispatch\_async\_request, ActionScheduler\_Lock->is\_locked, ActionScheduler\_OptionLock->get\_expiration, ActionScheduler\_OptionLock->get\_existing\_lock, QM\_DB->query \[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query SELECT option\_value FROM wpaw\_options WHERE option\_name = 'action\_scheduler\_lock\_async-request-runner' made by shutdown\_action\_hook, do\_action('shutdown'), WP\_Hook->do\_action, WP\_Hook->apply\_filters, ActionScheduler\_QueueRunner->maybe\_dispatch\_async\_request, ActionScheduler\_OptionLock->set, ActionScheduler\_OptionLock->get\_existing\_lock, QM\_DB->query \[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO \`wpaw\_options\` (\`option\_name\`, \`option\_value\`, \`autoload\`) VALUES ('action\_scheduler\_lock\_async-request-runner', '667a4b70156050.07271713|1719290796', 'no') made by shutdown\_action\_hook, do\_action('shutdown'), WP\_Hook->do\_action, WP\_Hook->apply\_filters, ActionScheduler\_QueueRunner->maybe\_dispatch\_async\_request, ActionScheduler\_OptionLock->set, QM\_DB->query \[25-Jun-2024 04:45:36 UTC\] WordPress database error Commands out of sync; you can't run this command now for query UPDATE \`wpaw\_options\` SET \`option\_value\` = '1721882736' WHERE \`option\_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, update\_option, QM\_DB->query
The error message you're encountering, "Commands out of sync; you can't run this command now," indicates an issue with how MySQL queries are being handled in your WordPress site. This typically occurs when there is an attempt to run a new query while the previous query is still being processed or there was an error in handling the previous query. 1. Your database connection might be getting reset or interrupted, leading to incomplete query executions. 2. Plugins, particularly those interacting with the database frequently, might be causing conflicts. In your case, the error logs mention WooCommerce and its components (like `Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup` and `ActionScheduler`). 3. Corrupted database tables can cause synchronization issues with queries. 4. If your server is running out of memory or processing power, it can lead to incomplete query executions. 5. You can use a plugin like WP-DBManager or run the following queries in phpMyAdmin to check and repair your database tables: CHECK TABLE wpaw\_options; REPAIR TABLE wpaw\_options; 6. Increase the memory limit in your `wp-config.php` file: define('WP\_MEMORY\_LIMIT', '256M'); define('WP\_MAX\_MEMORY\_LIMIT', '512M'); (you can do it from Cpanel as well) 7. Before making any changes, ensure you have a complete backup of your database. Ensure that WordPress, WooCommerce, and all other plugins are updated to their latest versions.
What does it say in the Order Notes? It's cut off in the screenshot. Also check your WC logs? Woocommerce > Status > Logs
There is nothing noted in the order notes. When customers try to pay at the end of checkout, they see this error message at the top. "There was an error processing your order. Please check for any charges in your payment method and review your order history before placing the order again."
Then that points to an issue with your payment gateway configuration. Check the logs.
The problem is with the plugin itself. Tis is the worst paypal plugin on wordpress. he need to use a different paypal plugin.
I do not think its the plugin, i have the same one on other site and works fine.
Looks like the webhook back from paypal to woocommerce isn’t configured properly, so when the payment completes on PayPal it isn’t pinging back to your store to update it
I just did a test Webhook simulation and came back "✔️ The webhook was received successfully." so not to sure
We had this on PayPal payments but the PayPal dashboard was showing the payment being received and the order still marked as pending on Woocommerce. We have an ongoing issue with PHP versions at the moment. These can’t be resolved for another three weeks. In the end I noticed that Woocommerc had updated itself to the very latest version that our version of PHP allows. I rolled back to a very old versions (mid 2022) of Woocommerce. At the moment, all working fine. We’re moving to a new server with latest versions of PHP. Once we’re there, we’ll be updating everything including the PayPal plugin and looking at Stripe as well.