Why creating Woocommerce tables actions ????

  • Resolved Padaben

    (@padaben)


    3 years, 10 months ago

    Hi, good plugin but, since last update I guess, on my site I do not need woocommerce and the plugin has created tables related to it
    actionscheduler_actions
    actionscheduler_claims
    actionscheduler_groups
    actionscheduler_logs

    ActionScheduler_DBStore->find_action()
    wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php:149
    ActionScheduler_HybridStore->find_action()
    wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/functions.php:177
    as_next_scheduled_action()
    wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/migration/Scheduler.php:66
    Action_Scheduler\M\Scheduler->is_migration_scheduled()
    wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/migration/Controller.php:95
    Action_Scheduler\M\Controller->schedule_migration()
    wp-includes/class-wp-hook.php:287
    do_action(‘wp_loaded’)
    wp-settings.php:562

    WHY is that ?
    It should not be, If I delete them, site is down.

    please do something.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Gregor Capuder

    (@capuderg)

    3 years, 10 months ago

    Hi @padaben,

    our plugin is using the Action Scheduler library (made by the WooCommerce team). This library enables us to perform tasks in the background, tasks that are heavy on the resources, or take a long time to complete.

    These tables that you deleted are needed for this library to work and that means that our plugin can’t work without them (that’s why your site went down).

    Even if you don’t use the WooCommerce plugin, our plugin needs these tables to work.

    These tables (Action Scheduler library) can be used by other plugins as well, that’s why they don’t have wpmailsmtp_ prefix in them.

    Here is support article that should help you get your site back up. It will recreate the tables and our plugin should work OK again.

    Let me know how if you have any other questions.

    Take care!

    Thread Starter Padaben

    (@padaben)

    3 years, 10 months ago

    Hi, thank you for your quick response.

    so It means that the emails sent are scheduled if there’s too many ?
    I do have the tables
    I am happy to leave them as I understand why they are there.

    means that actions as sending emails are queued with this tables ?
    if I send 150 mails, the tables are in use to send the email without overloading the server ?

    also, when I tried to copy the tables between 2 db
    I got some trouble with this
    # 1067 – Invalid default value for ‘GMT scheduled date’
    for the actionscheduler_actions

    I had to SET sql_mode = ‘ALLOW_INVALID_DATES’;
    to be able to migrate.

    might need a fix.

    best.

    Plugin Author Gregor Capuder

    (@capuderg)

    3 years, 10 months ago

    Hi @padaben,

    no, emails are not scheduled/queued. We are currently using it for other functionality and will be using this library in future, to improve the plugin.

    About the copying issue… you can report this issue to the Action Scheduler library directly since we don’t control the code that is creating these DB tables. However, this might be just a DB specific issue that occurred for you.

    Take care!

    Thread Starter Padaben

    (@padaben)

    3 years, 10 months ago

    Thank you for your response.

    so I have that question : is it possible to queue the emails, without using a external service but within wp ?
    as the SMTP server is the “last door” to send all emails, is there a way to queue all emails from the site (we do have a lot of users) ?

    thank you

    Plugin Author Gregor Capuder

    (@capuderg)

    3 years, 10 months ago

    Hi @padaben,

    I’m sorry, but I didn’t use a plugin like that yet, so I can’t make any suggestions or recommendations.

    Take care!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Why creating Woocommerce tables actions ????’ is closed to new replies.