Action Scheduler Fatal Error
-
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.
-
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!
### 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
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!
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.
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/5OeBL9Hello @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!
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…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!
- The topic ‘Action Scheduler Fatal Error’ is closed to new replies.