missing tables / Uncaught RuntimeException: Unable to claim actions. DB error

  • Resolved mellowvision

    (@mellowvision)


    2 years, 3 months ago

    I received a mailbot alert that the WP Mail SMTP plugin has started malfunctioning, and it appears it is missing database tables. One of the error messages I received in the WP Mail SMTP settings was to contact the developer.

    An error of type E_ERROR was caused in line 683 of the file /wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php. Error message: Uncaught RuntimeException: Unable to claim actions. Database error. in /wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:683
Stack trace:
#0 /wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(597): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, '')
#1 /wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(221): ActionScheduler_DBStore->stake_claim(25, NULL, Array, '')
#2 /wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/ActionScheduler_QueueRunner.php(153): ActionScheduler_HybridStore->stake_claim(25)
#3 /wp-content/plugins/wp-mail-smtp/vendor/woocommerce/action-scheduler/classes/ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner->do_batch(25, 'WP Cron')
#4 /wp-includes/class-wp-hook.php(307): ActionScheduler_QueueRunner->run('WP Cron')
#5 /wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters('', Array)
#6 /wp-includes/plugin.php(524): WP_Hook->do_action(Array)
#7 /wp-cron.php(138): do_action_ref_array('action_schedule...', Array)
#8 {main}
  thrown

    this error shown on scheduled actions page

    It appears one or more database tables were missing. Attempting to re-create the missing table(s).

    this error on debug events page

    Debug Events are Not Installed Correctly
The database table was not installed correctly. Please contact plugin support to diagnose and fix the issue. Provide them the error message below:

Unknown collation: 'utf8mb4_unicode'

    This has been running for a few years without this issue. how can it be resolved?

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Darshana

    (@darshanaw)

    Hi @mellowvision,

    Thanks for reaching out! Could you please try following the steps below and see if that resolves your issue.

    1) Open your WordPress options page (example.com/wp-admin/options.php).

    2) Search the following string wp_mail_smtp_debug_events_db_version, set its value to 0 and save the changes.

    3) Check your Debug Events section (WP Mail SMTP -> Tools -> Debug Events).

    Let us know how it goes. Thanks!

    Thread Starter mellowvision

    (@mellowvision)

    Hello, thank you for the reply.

    I searched on the options page and did not find the string you specified. I am pasting below all of the options listed when i search for wp_mail

    wp_mail_smtp	
SERIALIZED DATA
wp_mail_smtp_activated	
SERIALIZED DATA
wp_mail_smtp_activated_time	
1659576369
wp_mail_smtp_debug	
SERIALIZED DATA
wp_mail_smtp_debug_events_db_error	
Unknown collation: 'utf8mb4_unicode'
wp_mail_smtp_initial_version	
1.4.1
wp_mail_smtp_lite_sent_email_counter	
3
wp_mail_smtp_lite_weekly_sent_email_counter	
SERIALIZED DATA
wp_mail_smtp_migration_version	
5
wp_mail_smtp_review_notice	
SERIALIZED DATA
wp_mail_smtp_version	
3.5.1
    Plugin Support Darshana

    (@darshanaw)

    Hi @mellowvision,

    Could you please try manually re-installing the WP Mail SMTP plugin and see if that helps?

    Once you connect to your server’s FTP account, you can delete the following folder “wp-mail-smtp” (/wp-content/plugins/wp-mail-smtp).

    Then, try installing the latest version of the WP Mail SMTP plugin.

    Let us know how it goes. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘missing tables / Uncaught RuntimeException: Unable to claim actions. DB error’ is closed to new replies.