Title: Query Issue: many Errors in Log Last modified: February 10, 2022 --- # Query Issue: many Errors in Log * Resolved [darkallman](https://wordpress.org/support/users/darkallman/) * (@darkallman) * [4 years, 4 months ago](https://wordpress.org/support/topic/query-issue-many-errors-in-log/) * [@niklasinpsyde](https://wordpress.org/support/users/niklasinpsyde/) I have many log entries with mollie errors: * ``` PHP message: WordPress databasefout Table 'tablename.a' doesn't exist bij query SELECT a.action_id FROM a WHERE 1=1 AND a.hook='mollie_woocommerce_cancel_unpaid_orders' AND a.status IN ('in-progress') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 gemaakt door require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Mollie\\WooCommerce\\initialize, Inpsyde\\Modularity\\Package->boot, Inpsyde\\Modularity\\Package->doExecute, Mollie\\WooCommerce\\Payment\\PaymentModule->run, Mollie\\WooCommerce\\Payment\\PaymentModule->handleExpiryDateCancelation, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions PHP message: WordPress databasefout Table 'tablename.a' doesn't exist bij query SELECT a.action_id FROM a WHERE 1=1 AND a.hook='mollie_woocommerce_cancel_unpaid_orders' AND a.status IN ('pending') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1 gemaakt door require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Mollie\\WooCommerce\\initialize, Inpsyde\\Modularity\\Package->boot, Inpsyde\\Modularity\\Package->doExecute, Mollie\\WooCommerce\\Payment\\PaymentModule->run, Mollie\\WooCommerce\\Payment\\PaymentModule->handleExpiryDateCancelation, as_next_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions PHP message: WordPress databasefout Deadlock found when trying to get lock; try restarting transaction bij query ......... ``` Viewing 6 replies - 1 through 6 (of 6 total) * Plugin Support [Syde Niklas](https://wordpress.org/support/users/niklasinpsyde/) * (@niklasinpsyde) * [4 years, 4 months ago](https://wordpress.org/support/topic/query-issue-many-errors-in-log/#post-15350601) * Hi [@darkallman](https://wordpress.org/support/users/darkallman/), * Please downgrade to version 6.7.0 if you encounter any issues with the new 7.0 release. Version 7.0 contains a major code refactor and minor issues are expected to a certain degree. The one you mentioned has already been resolved for the next release version. For now, the stable tag has been reverted so when you delete and reinstall the plugin, it will automatically install version 6.7.0. * Kind regards, Niklas * Thread Starter [darkallman](https://wordpress.org/support/users/darkallman/) * (@darkallman) * [4 years, 4 months ago](https://wordpress.org/support/topic/query-issue-many-errors-in-log/#post-15350650) * [@niklasinpsyde](https://wordpress.org/support/users/niklasinpsyde/) My scheduled tasks are full of Mollie tasks: mollie_woocommerce_cancel_unpaid_orders Will downgrading remove them as well? * Thread Starter [darkallman](https://wordpress.org/support/users/darkallman/) * (@darkallman) * [4 years, 4 months ago](https://wordpress.org/support/topic/query-issue-many-errors-in-log/#post-15350719) * Or can I change them via: * ``` UPDATE prefix_actionscheduler_actions SET status = 'complete', attempts = 1, last_attempt_gmt = now(), last_attempt_local = now() WHERE scheduled_date_gmt = 'pending' ``` * Removing or downgrading did not remove the pending tasks - This reply was modified 4 years, 4 months ago by [darkallman](https://wordpress.org/support/users/darkallman/). * Plugin Support [Syde Niklas](https://wordpress.org/support/users/niklasinpsyde/) * (@niklasinpsyde) * [4 years, 4 months ago](https://wordpress.org/support/topic/query-issue-many-errors-in-log/#post-15350962) * Hi [@darkallman](https://wordpress.org/support/users/darkallman/), * Potentially excess scheduled actions like these could be removed with an SQL query similar to this (table prefix would need adjustment): [https://gist.github.com/InpsydeNiklas/3858379ee7e5ab24801c60444f946a5e](https://gist.github.com/InpsydeNiklas/3858379ee7e5ab24801c60444f946a5e) Before running any SQL queries, a DB backup should be created though. * Kind regards, Niklas * Thread Starter [darkallman](https://wordpress.org/support/users/darkallman/) * (@darkallman) * [4 years, 4 months ago](https://wordpress.org/support/topic/query-issue-many-errors-in-log/#post-15351010) * Thank you * [meestergijs](https://wordpress.org/support/users/meestergijs/) * (@meestergijs) * [4 years, 4 months ago](https://wordpress.org/support/topic/query-issue-many-errors-in-log/#post-15362225) * This solved my issue as well. I got a notification at checkout that fields were missing ([https://imgur.com/a/Fe5tOgS](https://imgur.com/a/Fe5tOgS)) when in fact nothing was changed in admin. Downgrading to 6.7.0 solved the issue. Thank you. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Query Issue: many Errors in Log’ is closed to new replies. * ![](https://ps.w.org/mollie-payments-for-woocommerce/assets/icon-256x256.png? rev=3090580) * [Mollie Payments for WooCommerce](https://wordpress.org/plugins/mollie-payments-for-woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/mollie-payments-for-woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/mollie-payments-for-woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/mollie-payments-for-woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/mollie-payments-for-woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/mollie-payments-for-woocommerce/reviews/) ## Tags * [query](https://wordpress.org/support/topic-tag/query/) * 6 replies * 3 participants * Last reply from: [meestergijs](https://wordpress.org/support/users/meestergijs/) * Last activity: [4 years, 4 months ago](https://wordpress.org/support/topic/query-issue-many-errors-in-log/#post-15362225) * Status: resolved