• Resolved Erupt Media

    (@eruptmedia)


    Since updating the WooCommerce Plugin on 6th April, this notice has been active:

    Action Scheduler: 84 past-due actions found; something may be wrong. 

    The woocommerce database update has also been active since and has not yet been completed. And I have not been able to view any analytics for my orders etc.

    Here is a system report:

    WordPress Environment<br><br>WordPress address (URL): https://handyhousewifett.com<br>Site address (URL): https://handyhousewifett.com<br>WC Version: 9.8.1<br>Legacy REST API Package Version: ✔ 1.0.5<br>Action Scheduler Version: ✔ 3.9.2<br>Log Directory Writable: ✔<br>WP Version: 6.7.2<br>WP Multisite: –<br>WP Memory Limit: 768 MB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: en_US<br>External object cache: ✔ Server Environment<br><br>Server Info: Apache<br>PHP Version: 8.2.28<br>PHP Post Max Size: 256 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 3000<br>cURL Version: 8.9.1<br>OpenSSL/3.2.4<br><br>SUHOSIN Installed: –<br>MySQL Version: 8.0.39-30<br>Max Upload Size: 256 MB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔ Database<br><br>WC Database Version: 9.7.1<br>WC Database Prefix: blp_<br>Total Database Size: 1817.69MB<br>Database Data Size: 1492.44MB<br>Database Index Size: 325.25MB<br>blp_woocommerce_sessions: Data: 247.84MB + Index: 9.50MB + Engine InnoDB<br>blp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>blp_woocommerce_order_items: Data: 2.52MB + Index: 1.52MB + Engine InnoDB<br>blp_woocommerce_order_itemmeta: Data: 13.52MB + Index: 17.03MB + Engine InnoDB<br>blp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>blp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>blp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_actionscheduler_actions: Data: 2.03MB + Index: 0.94MB + Engine InnoDB<br>blp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_actionscheduler_logs: Data: 1.03MB + Index: 1.27MB + Engine InnoDB<br>blp_atum_order_itemmeta: Data: 1.52MB + Index: 1.89MB + Engine InnoDB<br>blp_atum_order_items: Data: 0.16MB + Index: 0.06MB + Engine InnoDB<br>blp_atum_product_data: Data: 0.28MB + Index: 0.22MB + Engine InnoDB<br>blp_awb_critical_css: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_barcode_scanner_cart: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_scanner_cart_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_scanner_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_scanner_interface: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_scanner_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_scanner_locations_tree: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_scanner_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_barcode_scanner_posts: Data: 2.52MB + Index: 0.31MB + Engine InnoDB<br>blp_barcode_scanner_posts_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_scanner_posts_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_scanner_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_v3_templates: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>blp_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_commentmeta: Data: 1.52MB + Index: 0.30MB + Engine InnoDB<br>blp_comments: Data: 9.52MB + Index: 10.09MB + Engine InnoDB<br>blp_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_fbv_attachment_folder: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>blp_frmt_form_entry: Data: 0.09MB + Index: 0.19MB + Engine InnoDB<br>blp_frmt_form_entry_meta: Data: 1.52MB + Index: 1.14MB + Engine InnoDB<br>blp_frmt_form_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_frmt_form_views: Data: 0.11MB + Index: 0.23MB + Engine InnoDB<br>blp_fusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_fusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_fusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_fusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB<br>blp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>blp_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>blp_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>blp_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_mailpoet_log: Data: 1.02MB + Index: 0.00MB + Engine InnoDB<br>blp_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>blp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>blp_mailpoet_newsletters: Data: 0.08MB + Index: 0.05MB + Engine InnoDB<br>blp_mailpoet_scheduled_task_subscribers: Data: 30.56MB + Index: 17.55MB + Engine InnoDB<br>blp_mailpoet_scheduled_tasks: Data: 1.52MB + Index: 0.70MB + Engine InnoDB<br>blp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_mailpoet_settings: Data: 0.03MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>blp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>blp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>blp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>blp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_subscriber_segment: Data: 0.23MB + Index: 0.25MB + Engine InnoDB<br>blp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_mailpoet_subscribers: Data: 0.45MB + Index: 1.30MB + Engine InnoDB<br>blp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_mclean_refs: Data: 7.52MB + Index: 0.00MB + Engine InnoDB<br>blp_mclean_scan: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>blp_nmgr_wishlist_items: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>blp_options: Data: 39.56MB + Index: 41.16MB + Engine InnoDB<br>blp_phone_orders_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_postmeta: Data: 61.59MB + Index: 41.14MB + Engine InnoDB<br>blp_posts: Data: 21.52MB + Index: 3.77MB + Engine InnoDB<br>blp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB<br>blp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_revslider_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_sgs_log_events: Data: 200.70MB + Index: 117.98MB + Engine InnoDB<br>blp_sgs_log_visitors: Data: 2.52MB + Index: 3.03MB + Engine InnoDB<br>blp_stock_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_term_relationships: Data: 0.44MB + Index: 0.42MB + Engine InnoDB<br>blp_term_taxonomy: Data: 0.09MB + Index: 0.11MB + Engine InnoDB<br>blp_termmeta: Data: 0.41MB + Index: 0.58MB + Engine InnoDB<br>blp_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>blp_uean_generator_codes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_uean_generator_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_usermeta: Data: 6.52MB + Index: 8.03MB + Engine InnoDB<br>blp_users: Data: 0.33MB + Index: 0.27MB + Engine InnoDB<br>blp_vi_wbe_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>blp_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>blp_wc_cancel_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wc_customer_lookup: Data: 0.38MB + Index: 0.28MB + Engine InnoDB<br>blp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_wc_inventory_history: Data: 1.52MB + Index: 2.38MB + Engine InnoDB<br>blp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>blp_wc_order_coupon_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>blp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_wc_order_product_lookup: Data: 2.52MB + Index: 2.83MB + Engine InnoDB<br>blp_wc_order_stats: Data: 1.52MB + Index: 0.55MB + Engine InnoDB<br>blp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>blp_wc_orders_meta: Data: 0.27MB + Index: 0.48MB + Engine InnoDB<br>blp_wc_pos_grid_tiles: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_wc_product_attributes_lookup: Data: 0.09MB + Index: 0.08MB + Engine InnoDB<br>blp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_wc_product_meta_lookup: Data: 0.28MB + Index: 0.69MB + Engine InnoDB<br>blp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>blp_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>blp_wdp_persistent_rules_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_wepos_cashier_outlet: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wepos_counters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wepos_login: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wepos_outlets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wepos_payment_reports: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>blp_wfpklist_template_data: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>blp_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_wpml_mails: Data: 793.52MB + Index: 0.00MB + Engine InnoDB<br>blp_wsal_metadata: Data: 14.52MB + Index: 29.16MB + Engine InnoDB<br>blp_wsal_occurrences: Data: 10.52MB + Index: 4.03MB + Engine InnoDB<br>blp_wsal_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_wt_guest_wishlists: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>blp_wt_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>blp_yoast_indexable: Data: 1.52MB + Index: 0.56MB + Engine InnoDB<br>blp_yoast_indexable_hierarchy: Data: 0.09MB + Index: 0.17MB + Engine InnoDB<br>blp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>blp_yoast_primary_term: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>blp_yoast_seo_links: Data: 0.20MB + Index: 0.20MB + Engine InnoDB<br>blp_ywcars_messagemeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>blp_ywcars_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts<br><br>advanced_fee: 8<br>attachment: 3942<br>atum_inventory_log: 19<br>atum_purchase_order: 434<br>atum_supplier: 17<br>awb_off_canvas: 5<br>customize_changeset: 7<br>efw_fees: 1<br>forminator_forms: 2<br>fusion_element: 1<br>fusion_form: 1<br>fusion_icons: 1<br>fusion_tb_layout: 2<br>fusion_tb_section: 5<br>fusion_template: 2<br>giftcard: 4<br>mailpoet_page: 2<br>nav_menu_item: 68<br>nm_gift_registry: 30<br>order_status: 13<br>page: 26<br>pos_outlet: 1<br>pos_receipt: 1<br>pos_register: 1<br>pos_session: 1<br>post: 10<br>product: 1180<br>product_variation: 963<br>revision: 668<br>shop_coupon: 75<br>shop_order: 6258<br>shop_order_refund: 13<br>slide: 4<br>status_emails: 13<br>wcp_ruleset: 7<br>wcpf_item: 9<br>wcpf_project: 2<br>wcs_ruleset: 7<br>wfwp_wc_order_status: 1<br>wpcode: 3<br>yith_refund_request: 1 Security<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (54)<br><br>Custom Order Number: by Addify – 1.3.0<br>Custom Order Status: by Addify – 1.1.1<br>Additional Order Filters for WooCommerce: by Anton Bond – 1.22<br>Admin Menu Editor: by Janis Elsts – 1.12.4<br>ATUM Inventory Management for WooCommerce: by Stock Management Labs™ – 1.9.46<br>Change Admin Email Setting Without Outbound Email: by John Dee – 4.1<br>Conditional Payments for WooCommerce: by Lauri Karisola / WP Trio – 3.3.1<br>Cost of Goods for WooCommerce Pro: by WPFactory – 3.3.7<br>CSF TT Shipping for WooCommerce: by C7 Caribbean – 0.9.10<br>Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5<br>Export Plugin Details: by Boopathi Rajan – 1.1.7<br>FileBird Pro: by Ninja Team – 6.4.6<br>Forminator: by WPMU DEV – 1.42.0<br>Avada Builder: by ThemeFusion – 3.11.15<br>Avada Core: by ThemeFusion – 5.11.15<br>Avada Custom Branding: by ThemeFusion – 1.2<br>Inventory History: by Yashar Hosseinpour – 0.1.2<br>Jetpack: by Automattic – 14.5<br>Media Cleaner (Pro): by Jordy Meow – 6.8.2<br>NM Gift Registry and Wishlist Lite: by Nmeri Media – 5.9.2<br>Optimize Images Resizing: by OriginalEXE – 1.4.1<br>Phone Orders for WooCommerce: by AlgolPlus – 3.9.6<br>WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 4.7.5<br>Barcode Label Printing for WooCommerce and others plugins - (basic): by UkrSolution – 3.4.10<br>Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6<br>Speed Optimizer: by SiteGround – 7.7.2<br>Security Optimizer: by SiteGround – 1.5.7<br>States, Cities, and Places for WooCommerce: by Kingsley Ochu – 1.3.2<br>Stock History & Reports Manager for WooCommerce: by WPFactory – 2.1.1<br>Temporary Login Without Password: by StoreApps – 1.9.0<br>Trinidad and Tobago States, Cities, and Places for WooCommerce: by C7 Caribbean – 1.0<br>UPC/EAN codes importer/generator - (basic): by UkrSolution – 2.0.2<br>User Role Editor: by Vladimir Garagulya – 4.64.4<br>Invoice Payment Gateway for WooCommerce: by Stuart Duff – 2.0.2<br>wePOS - Pro: by weDevs – 1.2.2<br>wePOS - Point Of Sale (POS) for WooCommerce: by weDevs – 1.3.0<br>Auto Coupons for WooCommerce: by RLDD – 3.0.30<br>Checkout Field Editor for WooCommerce: by ThemeHigh – 2.1.3<br>WooCommerce Conditional Shipping Pro: by Lauri Karisola / WP Trio – 3.4.1<br>Ultimate Gift Cards For WooCommerce: by WP Swings – 3.1.3<br>Advanced Order Export For WooCommerce: by AlgolPlus – 4.0.2<br>Preview E-mails for WooCommerce: by Digamber Pradhan – 2.2.13<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>Advanced Fees for WooCommerce: by Jeroen Sormani – 1.5.0<br>WooCommerce Legacy REST API: by WooCommerce – 1.0.5<br>Product Filters for WooCommerce: by WooCommerce – 1.4.38<br>WooCommerce: by Automattic – 9.8.1<br>Credit/Debit Card (via WiPay): by WiPay Development Team – 2.1.0<br>Yoast SEO: by Team Yoast – 24.8.1<br>WP Crontrol: by John Blackbourn – 1.18.0<br>WP Frontend Delete Account: by Mini Plugins – 2.4.2<br>WP Mail Logging: by WP Mail Logging Team – 1.14.0<br>WooCommerce Shipping Labels, Dispatch Labels and Delivery Notes (Pro): by WebToffee – 1.6.5<br>Wishlist for WooCommerce: by WebToffee – 2.1.4 Inactive Plugins (7)<br><br>Add a 1% surcharge to your cart / checkout: by C7 Caribbean – 0.1<br>Barcode Label Printing for WooCommerce and others plugins - (demo): by UkrSolution – 3.4.11<br>Barcode Scanner with Inventory & Order Manager - (business): by UkrSolution – 1.8.0<br>Bulky - Bulk Edit Products for WooCommerce: by VillaTheme – 1.2.11<br>Free Assets Library: by Surror – 2.2.1<br>MailPoet: by MailPoet – 5.10.0<br>Show Single Variations Shop & Category for WooCommerce: by Gravity Master – 2.0 Dropin Plugins ()<br><br>object-cache.php: Memcached Settings<br><br>Legacy API Enabled: ✔<br>Force SSL: ✔<br>Currency: TTD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br>wgm_gift_card (wgm_gift_card)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: ✔<br>Enforce Approved Product Download Directories: ✔<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 4 MB WC Pages<br><br>Shop base: #16557 - /shop/<br>Cart: #16564 - /cart/ - Contains the woocommerce_cart shortcode<br>Checkout: #16586 - /checkout/ - Contains the woocommerce_checkout shortcode<br>My account: #16576 - /my-account/ - Contains the [woocommerce_my_account] shortcode<br>Terms and conditions: #21864 - /terms-of-use/ Theme<br><br>Name: Avada<br>Version: 7.11.15<br>Author URL: https://themeforest.net/user/ThemeFusion<br>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<br>Theme type: Classic theme<br>WooCommerce Support: ✔ Templates<br><br>Overrides: Avada/woocommerce/cart/cart.php<br>Avada/woocommerce/checkout/form-pay.php<br>Avada/woocommerce/checkout/review-order.php<br>Avada/woocommerce/single-product/short-description.php<br>Avada/woocommerce/single-product/tabs/additional-information.php<br>Avada/woocommerce/single-product/tabs/description.php Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br>add-to-cart-with-options-stepper-layout<br><br>Disabled Features: product-data-views<br>experimental-blocks<br>coming-soon-newsletter-template<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>use-wp-horizon<br>blockified-add-to-cart<br><br>Daily Cron: ✔ Next scheduled: 2023-11-09 11:02:15 -04:00<br>Options: ✔<br>Notes: 134<br>Onboarding: completed Action Scheduler<br><br>Complete: 3,147<br>Oldest: 2025-03-11 04:37:53 +0000<br>Newest: 2025-04-11 01:45:25 +0000<br><br>Pending: 668<br>Oldest: 2025-04-11 04:24:48 +0000<br>Newest: 2025-04-15 11:44:19 +0000<br><br>Failed: 24<br>Oldest: 2022-12-29 16:46:40 +0000<br>Newest: 2024-10-28 01:37:16 +0000<br><br>Canceled: 1<br>Oldest: -0001-11-30 00:00:00 +0000<br>Newest: -0001-11-30 00:00:00 +0000 Status report information<br><br>Generated at: 2025-04-15 07:52:27 -04:00<br>

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Hi @eruptmedia,

    Thanks for sharing your system status report. I’ve reviewed it and noticed that your site has several customizations and active plugins, which can make troubleshooting more complex. It would be much easier to investigate this on a staging environment.

    To begin, please check your logs for any fatal errors. You can find these by navigating to WooCommerce > Status > Logs, then copy the relevant log and share it using a service like Pastebin or Gist.

    Next, kindly create a staging version of your site—either on a subdomain or in a subdirectory. On this cloned site:

    • Deactivate all plugins except WooCommerce.
    • Switch your theme to the default Storefront theme.
    • Then, share the system status report from the staging site.
    • Test the analytics and re-run the database update there, and let me know if things work correctly in that environment.
    Thread Starter Erupt Media

    (@eruptmedia)

    Hello,

    I have done both suggestions and the issue still exists on the staging site.

    Here is the system log of fatal errors: https://pastebin.com/RZz3zN7a
    Here is the system status from the staging site: https://pastebin.com/Ls8y7ZLT

    It seems like I cannot get the woocommerce database to update.

    Looking forward to your reply.

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    I’m not able to access the fatal error log and system status report as they are currently set to private. Could you please change the URL access to public so that we can review the error log and system status report?

    In the meantime, I would suggest activating the WP Crontrol plugin and then manually running the past-due actions from there. This tool not only allows you to trigger the actions but also helps identify any errors that may occur while those actions are being executed. This can be helpful in diagnosing what might be causing the delay or failure

    I would also suggest manually updating the database to see if that helps resolve the issue.

    1. Go to your WP database and locate thewp_wc_admin_notes table.
    2. Look for any entries related to the database update and check if the status is set to Pending.
    3. If so, you can manually change the status to Actioned to see if this resolves the issue.

    The table structure should look something like this:

    Thread Starter Erupt Media

    (@eruptmedia)

    Hello

    I have change the pastebin access to Public.

    Please notes that there are over 4000 overdue actions to be run when viewed on WP Crontrol. I have run the database update and it was successfully updated but the issue with Analytics still exists.

    Here is a link to access the staging site as an administrator.

    https://staging2.handyhousewifett.com/wp-admin/?wtlwp_token=4bc80f438f9da60548f156873629fe708310eb0a206a597b4af87e9242e14a41985cfb1cfee02197d29e7410b124c8d2ec231243a42d4c48e9f1e4ed063244af

    Hi @eruptmedia,

    Thank you for the clarification. Let’s check a setting in your wp-config.php file.

    Please navigate to your hosting control panel, locate your site’s installation folder, and edit the wp-config.php file. Use cmd+f (Mac) or ctrl+f (Windows) to search for the following line:

    define('DISABLE_WP_CRON', true);
    

    If this line is present, change the value to false. If it’s not there, you can add it, set it to false, and then save the file. Afterward, go to your Scheduled Actions and try running the failed or pending actions again. You can also use WP Control plugin.

    Let me know what you observe after making this change.

    Plugin Support Kay U a11n

    (@kingsleyinfo)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

    If you have a few minutes, we’d love if you could leave us a review: https://wordpress.org/support/plugin/woocommerce/reviews/

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Woocommerce Database Update Errors since last version update’ is closed to new replies.