• Resolved darkallman

    (@darkallman)


    @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

    (@niklasinpsyde)

    Hi @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

    (@darkallman)

    @niklasinpsyde My scheduled tasks are full of Mollie tasks:
    mollie_woocommerce_cancel_unpaid_orders
    Will downgrading remove them as well?

    Thread Starter darkallman

    (@darkallman)

    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.
    Plugin Support Syde Niklas

    (@niklasinpsyde)

    Hi @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
    Before running any SQL queries, a DB backup should be created though.

    Kind regards,
    Niklas

    Thread Starter darkallman

    (@darkallman)

    Thank you

    This solved my issue as well. I got a notification at checkout that fields were missing (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.