Support » Plugin: WooCommerce » Action Scheduler Fatal Error

  • Resolved charmedchicken

    (@charmedchicken)


    I’m running debug and cannot delete multi-sites on my wordpress multi-site installation. However, I’m getting the following error:

    Fatal error: Uncaught RuntimeException: Error saving action: Table ‘(databaseprefix)_actionscheduler_actions’ doesn’t exist in (varpath)/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:75 Stack trace: #0 (varpath)/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action)) #1 (varpath)/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #2 (varpath)/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single(‘wc-admin_delete…’, Array, 1621438569, ‘wc-admin-data’) #3 (varpath)/wp-content/plugins/woocommerce/includes/queue/class-wc-action-queue.php(44): as_schedule_singl in (varpath)l/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 75

    Thank you.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Mirko P. woo-hc

    (@rainfallnixfig)

    Hi there,

    Can you please share a copy of your System Status report as found under WooCommerce > Status > System status? Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Thanks!

    Thread Starter charmedchicken

    (@charmedchicken)

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://eponaauthorsolutions.com
    Site address (URL): https://eponaauthorsolutions.com
    WC Version: 5.3.0
    REST API Version: ✔ 5.3.0
    WC Blocks Version: ✔ 4.9.1
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 2.2.6
    Log Directory Writable: ✔
    WP Version: 5.7.2
    WP Multisite: ✔
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.16
    PHP Post Max Size: 1 GB
    PHP Time Limit: 1500
    PHP Max Input Vars: 2000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.28-MariaDB-log-cll-lve
    Max Upload Size: 146 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 5.3.0
    WC Database Prefix: wpej_
    Total Database Size: 27.48MB
    Database Data Size: 23.84MB
    Database Index Size: 3.64MB
    wpej_woocommerce_sessions: Data: 0.19MB + Index: 0.02MB + Engine MyISAM
    wpej_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpej_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_4_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_4_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_4_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_4_options: Data: 0.63MB + Index: 0.02MB + Engine MyISAM
    wpej_4_postmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_4_posts: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_4_termmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_4_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_4_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_4_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_6_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_6_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_6_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_6_options: Data: 0.53MB + Index: 0.02MB + Engine MyISAM
    wpej_6_postmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_6_posts: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_6_termmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_6_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_6_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_6_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_8_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_8_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_8_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_8_options: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
    wpej_8_postmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_8_posts: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_8_termmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_8_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_8_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_8_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_9_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_9_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_9_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_9_options: Data: 0.37MB + Index: 0.02MB + Engine MyISAM
    wpej_9_postmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_9_posts: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_9_termmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_9_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_9_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_9_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_actionscheduler_actions: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wpej_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_actionscheduler_logs: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wpej_adfoin_integration: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wpej_adfoin_log: Data: 0.76MB + Index: 0.00MB + Engine MyISAM
    wpej_b2s_posts: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_b2s_posts_drafts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_b2s_posts_favorites: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_b2s_posts_network_details: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_b2s_posts_sched_details: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_b2s_user: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_b2s_user_contact: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_b2s_user_network_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_blogmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_blogs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_cartflows_ca_cart_abandonment: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpej_cartflows_ca_email_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_cartflows_ca_email_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_cartflows_ca_email_templates_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_commentmeta: Data: 0.05MB + Index: 0.02MB + Engine MyISAM
    wpej_comments: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wpej_learnpress_order_itemmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_learnpress_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_question_answermeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_question_answers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_question_answers_bk: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_quiz_questions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_review_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_sections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_section_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_sessions: Data: 1.10MB + Index: 0.67MB + Engine MyISAM
    wpej_learnpress_upgrade_db: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_user_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_user_itemmeta_bk: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_user_items: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_learnpress_user_items_bk: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_learnpress_user_item_results: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_mailchimp_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_mlw_qm_audit_trail: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_mlw_questions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_mlw_quizzes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpej_mlw_results: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_mo_openid_linked_user: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_options: Data: 4.43MB + Index: 0.17MB + Engine MyISAM
    wpej_options_bk: Data: 3.77MB + Index: 0.09MB + Engine MyISAM
    wpej_pmpro_discount_codes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_pmpro_discount_codes_levels: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_pmpro_discount_codes_uses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_pmpro_memberships_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_pmpro_memberships_pages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_pmpro_memberships_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_pmpro_membership_levelmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_pmpro_membership_levels: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_pmpro_membership_ordermeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_pmpro_membership_orders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_postmeta: Data: 3.89MB + Index: 0.57MB + Engine MyISAM
    wpej_postmeta_bk: Data: 3.69MB + Index: 0.46MB + Engine MyISAM
    wpej_posts: Data: 2.46MB + Index: 0.20MB + Engine MyISAM
    wpej_redirection_404: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_redirection_items: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
    wpej_redirection_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_registration_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
    wpej_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_sliders: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_slides: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_signups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_site: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_sitemeta: Data: 0.80MB + Index: 0.01MB + Engine MyISAM
    wpej_sm_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpej_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpej_terms: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
    wpej_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wpej_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpej_usermeta: Data: 0.06MB + Index: 0.05MB + Engine MyISAM
    wpej_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_wcs_payment_retries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wpej_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpej_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpej_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpej_zbscrm_api_keys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_admlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_aka: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpej_zbs_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpej_zbs_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpej_zbs_customfields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpej_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpej_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpej_zbs_events: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpej_zbs_event_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_externalsources: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpej_zbs_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpej_zbs_invoices: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpej_zbs_lineitems: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpej_zbs_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpej_zbs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_object_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpej_zbs_product_index: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_quotes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpej_zbs_quotes_templates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpej_zbs_security_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpej_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_sys_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpej_zbs_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_tags_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpej_zbs_tax_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_temphash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpej_zbs_transactions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 470
    custom_css: 1
    event_auth_book: 4
    flamingo_contact: 133
    flamingo_inbound: 175
    lp_course: 7
    lp_lesson: 44
    lp_order: 24
    lp_question: 81
    lp_quiz: 32
    mc4wp-form: 2
    nav_menu_item: 27
    our_team: 10
    page: 81
    post: 32
    pricing-table-plus: 4
    product: 16
    product_variation: 13
    qmn_log: 25
    qsm_quiz: 1
    revision: 332
    shop_coupon: 6
    shop_order: 17
    shop_subscription: 2
    sliced_invoice: 1
    swp_forms: 1
    testimonials: 1
    thim-component: 3
    tp_event: 11
    wpcf7_contact_form: 22
    wpcf7r_action: 11
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (38) ###
    
    Advanced Form Integration Professional: by nasirahmed – 1.37.6
    Advanced Product Fields for WooCommerce: by StudioWombat – 1.3.8
    Akismet Anti-Spam: by Automattic – 4.1.9
    Awesome Support: Custom Status: by Awesome Support – 1.1.2
    Awesome Support: by Awesome Support Team – 6.0.3
    Blog2Social: Social Media Auto Post & Scheduler: by Blog2Social
    Adenion – 6.7.2
    
    Contact Form 7: by Takayuki Miyoshi – 5.4.1
    Duplicate Page: by mndpsingh287 – 4.4
    Flamingo: by Takayuki Miyoshi – 2.2.1
    Jetpack by WordPress.com: by Automattic – 9.7
    Jetpack CRM Extension: Invoicing Pro: by Jetpack – 2.7.3
    Jetpack CRM Extension: Woo Sync: by Jetpack – 2.12
    WPBakery Page Builder: by Michael M - WPBakery.com – 6.6.0
    LearnPress - Course Review: by ThimPress – 4.0.2
    LearnPress - Course Wishlist: by ThimPress – 4.0.1
    LearnPress: by ThimPress – 4.0.4
    Paid Memberships Pro: by Stranger Studios – 2.5.9.1
    Pricing Table Plus: by wpBriz – 1.1
    Redirection: by John Godley – 5.1.1
    Slider Revolution: by ThemePunch – 6.4.11
    Tawk.to Live Chat: by Tawkto – 0.5.4
    Thim Core: by ThimPress – 2.0.3
    Thim Our Team: by ThimPress – 1.3.1
    Thim Testimonials: by ThimPress – 1.3.1
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.16.56
    
    Checkout Field Editor for WooCommerce: by ThemeHigh – 1.4.8
    Digital Goods for WooCommerce Checkout Pro: by theDotstore – 3.5.6
    WooCommerce Stripe Gateway: by WooCommerce – 5.2.0
    WooCommerce Subscriptions: by WooCommerce – 3.1.1
    WooCommerce: by Automattic – 5.3.0
    WP Events Manager: by ThimPress – 2.1.9
    WP Encryption - One Click SSL & Force HTTPS (Premium): by Go Web Smarty – 5.4.1
    Redirection for Contact Form 7: by Query Solutions – 2.3.5
    Zapier for WordPress: by Zapier – 1.0.2
    Jetpack CRM: by Automattic – 4.0.15
    WP File Manager: by mndpsingh287 – 7.1.1
    WP Debugging: by Andy Fragen – 2.9.2
    WooCommerce: by Automattic – 5.3.0
    
    ### Inactive Plugins (28) ###
    
    bbPress: by The bbPress Contributors – 2.6.6
    Black Studio TinyMCE Widget: by Black Studio – 2.6.9
    Embed Sendy: by Ram Ratan Maurya – 1.3.3
    Facebook for WooCommerce: by Facebook – 2.4.1
    Google Ads & Marketing by Kliken: by Kliken – 1.0.7
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.17.0
    Knowledge Base for Documents and FAQs: by Echo Plugins – 7.6.0
    LearnPress - bbPress Integration: by ThimPress – 4.0.2
    LearnPress - Coming Soon Courses: by ThimPress – 4.0.0
    LearnPress - Content Drip: by ThimPress – 4.0.1
    LearnPress - Paid Membership Pro Integration: by ThimPress – 4.0.0
    LearnPress - Stripe Payment: by ThimPress – 4.0.1
    LearnPress - Students List: by ThimPress – 4.0.0
    LearnPress - WooCommerce Payment Methods Integration: by ThimPress – 4.0.0
    Mooberry Book Manager: by Mooberry Dreams – 4.7.5
    One page checkout and layouts for Woocommerce: by BluePlugins – 2.8
    Paid Memberships Pro - Email Templates Add On (.org): by Paid Memberships Pro – 0.8.1
    Paid Memberships Pro - WooCommerce Add On: by Paid Memberships Pro – 1.7.2
    PW WooCommerce Gift Cards: by Pimwick
    LLC – 1.178
    
    Quiz And Survey Master: by ExpressTech – 7.1.16
    Revive Old Posts: by revive.social – 9.0.1
    Sendy Widget Pro: by Webholics – 3.4.7
    Thim Portfolio: by ThimPress – 1.8
    WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.12
    WooCommerce Custom Thank You Pages: by Jeroen Sormani – 1.0.4
    WooCommerce Zapier: by OM4 Software – 2.1.0
    Woo Invoices: by Sliced Invoices – 1.2.1
    WP Encryption - One Click SSL & Force HTTPS: by Go Web Smarty – 5.4.2
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: –
    
    ### WC Pages ###
    
    Shop base: #1697 - /shop/
    Cart: #1698 - /cart/
    Checkout: #1699 - /checkout/
    My account: #1700 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Coaching
    Version: 3.4.3
    Author URL: https://thimpress.com
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: coaching/woocommerce/archive-product.php
    coaching/woocommerce/content-product.php
    coaching/woocommerce/content-single-product.php
    coaching/woocommerce/content-widget-product.php
    coaching/woocommerce/global/quantity-input.php
    coaching/woocommerce/loop/loop-start.php
    coaching/woocommerce/loop/orderby.php
    coaching/woocommerce/loop/pagination.php
    coaching/woocommerce/loop/rating.php
    coaching/woocommerce/loop/result-count.php
    coaching/woocommerce/loop/sale-flash.php
    coaching/woocommerce/myaccount/form-login.php
    coaching/woocommerce/myaccount/form-lost-password.php
    coaching/woocommerce/single-product/meta.php
    coaching/woocommerce/single-product/product-image.php
    coaching/woocommerce/single-product/product-thumbnails.php
    coaching/woocommerce/single-product/rating.php
    coaching/woocommerce/single-product/related.php
    coaching/woocommerce/single-product/review.php
    coaching/woocommerce/single-product/short-description.php
    coaching/woocommerce/single-product/tabs/description.php
    coaching/woocommerce/single-product/up-sells.php
    coaching/woocommerce/single-product-reviews.php
    coaching/woocommerce/single-product.php
    
    ### Subscriptions ###
    
    WCS_DEBUG: ✔ No
    Subscriptions Mode: ✔ Live
    Subscriptions Live URL: https://eponaauthorsolutions.com
    Subscription Statuses: wc-active: 2
    WooCommerce Account Connected: ❌ No
    Custom Retry Rules: ✔ No
    Custom Retry Rule Class: ✔ No
    Custom Raw Retry Rule: ✔ No
    Custom Retry Rule: ✔ No
    Retries Migration Status: ✔ Completed
    Report Cache Enabled: ✔ Yes
    Cache Update Failures: ✔ 0 failure
    
    ### Store Setup ###
    
    Country / State: United States (US) — Missouri
    
    ### Subscriptions by Payment Gateway ###
    
    Stripe: wc-active: 2
    
    ### Payment Gateway Support ###
    
    PayPal Standard: subscriptions
    gateway_scheduled_payments
    subscription_payment_method_change_customer
    subscription_cancellation
    subscription_suspension
    subscription_reactivation
    products
    refunds
    
    PayPal Reference Transactions Enabled: ❌ No
    Stripe: products
    refunds
    tokenization
    add_payment_method
    subscriptions
    subscription_cancellation
    subscription_suspension
    subscription_reactivation
    subscription_amount_changes
    subscription_date_changes
    subscription_payment_method_change
    subscription_payment_method_change_customer
    subscription_payment_method_change_admin
    multiple_subscriptions
    pre-orders
    
    ### Action Scheduler ###
    
    Complete: 65
    Oldest: 2021-04-23 19:12:06 -0500
    Newest: 2021-05-19 10:42:03 -0500
    
    Pending: 2
    Oldest: 2021-06-08 22:52:12 -0500
    Newest: 2021-06-16 10:48:52 -0500
    
    ### Status report information ###
    
    Generated at: 2021-05-19 12:05:08 -05:00
    
    Plugin Support Jess – a11n

    (@jlundie)

    Hi @charmedchicken,

    Thanks so much for sending over that site status! I think it’s possible that the MySQL DB user – or some acting user on your multisite install – is missing correct permissions for a table it’s trying to access.

    You mentioned that you’re on a multisite and cannot delete sites on your install.

    Are you getting this error when you try to delete a site? Could you give us a bit more information about the situation, what appears to be triggering this error, or what you are trying to accomplish here?

    Also, please double check to be sure that all MySQL users have correct permissions to access any of your site DB tables they may need to access.

    Thank you!

    Thread Starter charmedchicken

    (@charmedchicken)

    Hello,
    Yes, my mysql user has “all permissions”. I went ahead and saved again.

    Click path:

    1. Go to Network Admin > Sites
    2. Go to one of my subsites (doesn’t matter which one). Click DELETE
    3. Click CONFIRM
    4. Error message comes up with the white “wordpress has encountered a critical error message”
    Here’s what the debug log says:

    [19-May-2021 15:44:21 UTC] PHP Fatal error:  Uncaught RuntimeException: Error saving action: Table 'eponafirefly_wp300.wpej_6_actionscheduler_actions' doesn't exist in /home/eponafirefly/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:75
    Stack trace:
    #0 /home/eponafirefly/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action))
    #1 /home/eponafirefly/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
    #2 /home/eponafirefly/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single('wc-admin_delete...', Array, 1621439066, 'wc-admin-data')
    #3 /home/eponafirefly/public_html/wp-content/plugins/woocommerce/includes/queue/class-wc-action-queue.php(44): as_schedule_singl in /home/eponafirefly/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 75
    [19-May-2021 15:44:21 UTC] WordPress database error Table 'eponafirefly_wp300.wpej_6_actionscheduler_actions' doesn't exist for query SELECT COUNT(DISTINCT claim_id) FROM wpej_6_actionscheduler_actions WHERE claim_id != 0 AND status IN ( 'pending', 'in-progress') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_DBStore->get_claim_count
    [19-May-2021 15:44:21 UTC] WordPress database error Table 'eponafirefly_wp300.wpej_6_actionscheduler_actions' doesn't exist for query SELECT a.action_id FROM wpej_6_actionscheduler_actions a WHERE 1=1 AND a.status='pending' AND a.scheduled_date_gmt <= '2021-05-19 15:44:21' ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 5 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_DBStore->query_actions
    [19-May-2021 15:44:21 UTC] WordPress database error Table 'eponafirefly_wp300.wpej_6_wc_admin_notes' doesn't exist for query SELECT note_id FROM wpej_6_wc_admin_notes WHERE name = 'wc-update-db-reminder' ORDER BY note_id ASC made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\Jetpack\Sync\Sender->do_sync, Automattic\Jetpack\Sync\Sender->do_sync_and_set_delays, Automattic\Jetpack\Sync\Sender->do_sync_for_queue, Automattic\Jetpack\Sync\Sender->get_items_to_send, set_current_screen, WP_Screen->set_current_screen, do_action('current_screen'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Notes_Run_Db_Update::show_reminder, WC_Notes_Run_Db_Update::get_current_notice, WC_Data_Store->__call, Automattic\WooCommerce\Admin\Notes\DataStore->get_notes_with_name

    If I need to take this back down to a single site install and then try to create multi-site again, I am happy to do so. I don’t have anything on my subsites.

    Thanks.

    Plugin Support Jess – a11n

    (@jlundie)

    Thanks so much for the additional information, @charmedchicken!

    I’ve opened an issue with these details so that our Action Scheduler developers can take a look. They may have additional questions or suggestions for you.

    You can find the thread here, and can correspond with them directly on this: https://github.com/woocommerce/action-scheduler/issues/699

    To sign up for email notifications on that thread, click the Subscribe button here:


    Link to image: https://d.pr/i/5OeBL9

    Plugin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    Hello @charmedchicken

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thanks!

    Thread Starter charmedchicken

    (@charmedchicken)

    Hi,
    I didn’t hear back after the GitHub issue was opened and the issue is still happening. But I’ll probably end up going a different direction with the website. Oh well…

    Plugin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    Hello @charmedchicken,

    The issue is still open and you can check the status from here. Feel free to comment on the issue if needed.

    Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Action Scheduler Fatal Error’ is closed to new replies.