CRITICAL Uncaught Error: ActionScheduler_wcSystemStatus.php:79

  • Resolved Rys

    (@ryn_90)


    4 years, 3 months ago

    Hi, I’ve recently tried updating the WooCommerce plugins and ran into some issues. I presume my first issue was because my DB user was lacking create permissions, this was fixed, however, it seems that the DB Actions are still not working as intended because the DB version is still 3.8.1 while the plugin version is 4.8.0. I tried running the DB upgrade tool, and the below exception occured in the logs: 

    2020-12-21T22:30:30+00:00 CRITICAL Uncaught Error: Call to a member function format() on null in /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php:79
Stack trace:
#0 /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(52): ActionScheduler_wcSystemStatus->get_action_status_date('complete', 'oldest')
#1 /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(27): ActionScheduler_wcSystemStatus->get_oldest_and_newest(Array)
#2 /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AdminView.php(50): ActionScheduler_wcSystemStatus->render()
#3 /home/ryans137/public_html/wp-includes/class-wp-hook.php(287): ActionScheduler_AdminView->system_status_report('')
#4 /home/ryans137/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
#5 /home/ryans137/publ in /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php on line 79

2020-12-21T22:31:21+00:00 CRITICAL Uncaught Error: Call to a member function format() on null in /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php:79
Stack trace:
#0 /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(52): ActionScheduler_wcSystemStatus->get_action_status_date('complete', 'oldest')
#1 /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(27): ActionScheduler_wcSystemStatus->get_oldest_and_newest(Array)
#2 /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AdminView.php(50): ActionScheduler_wcSystemStatus->render()
#3 /home/ryans137/public_html/wp-includes/class-wp-hook.php(287): ActionScheduler_AdminView->system_status_report('')
#4 /home/ryans137/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
#5 /home/ryans137/publ in /home/ryans137/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php on line 79

    Any one has any pointers to fix this please?

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter Rys

    (@ryn_90)

    This is the System Report 

    
### WordPress Environment ###

WordPress address (URL): https://www.thepointmalta.com
Site address (URL): https://www.thepointmalta.com
WC Version: 4.8.0
REST API Version: ? 4.8.0
WC Blocks Version: ? 3.8.1
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.7.3
Log Directory Writable: ?
WP Version: 5.6
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.23
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.59.0
OpenSSL/1.0.2r

SUHOSIN Installed: –
MySQL Version: 5.6.40-84.0-log
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.8.1
WC Database Prefix: wp_
Total Database Size: 344.76MB
Database Data Size: 207.89MB
Database Index Size: 136.87MB
wp_woocommerce_sessions: Data: 0.49MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.05MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_comments: Data: 63.45MB + Index: 50.11MB + Engine MyISAM
wp_duplicator_packages: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_fb3d_pages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_layerslider: Data: 0.12MB + Index: 0.00MB + Engine MyISAM
wp_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_mapping_to_external_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_newsletter_templates: Data: 1.12MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_scheduled_tasks: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_mailpoet_scheduled_task_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_segments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscribers: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailpoet_subscriber_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 2.14MB + Index: 0.08MB + Engine MyISAM
wp_postmeta: Data: 36.02MB + Index: 7.60MB + Engine MyISAM
wp_posts: Data: 72.83MB + Index: 42.96MB + Engine MyISAM
wp_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_term_relationships: Data: 4.52MB + Index: 8.22MB + Engine MyISAM
wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_usermeta: Data: 0.06MB + Index: 0.02MB + Engine MyISAM
wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfconfig: Data: 0.37MB + Index: 0.02MB + Engine MyISAM
wp_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wffilemods: Data: 1.72MB + Index: 0.37MB + Engine MyISAM
wp_wfhits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wfknownfilelist: Data: 0.88MB + Index: 0.11MB + Engine MyISAM
wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wflogins: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfpendingissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfstatus: Data: 0.05MB + Index: 0.02MB + Engine MyISAM
wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_seo_links: Data: 0.06MB + Index: 0.02MB + Engine MyISAM
wp_yoast_seo_meta: Data: 23.72MB + Index: 27.01MB + Engine MyISAM

### Post Type Counts ###

3d-flip-book: 2
ajde_events: 4
attachment: 594
cmsmasters_cform: 29
cmsmasters_like: 9
content_template: 5
custom_css: 1
job_listing: 2
mailpoet_page: 1
mapplic_map: 1
nav_menu_item: 18
oembed_cache: 3
page: 118
post: 8
product: 1
product_variation: 3
profile: 4
revision: 652
scheduled-action: 149920
shop_coupon: 13
shop_order: 78
shop_order_refund: 4
smartlogo: 4
woovouchercodes: 16
woovouchers: 3
wpcf7_contact_form: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (23) ###

LayerSlider WP: by Kreatura Media – 6.8.2
Cache-Control: by Daniel Aleksandersen – 2.2.5
CMSMasters Contact Form Builder: by cmsmasters – 1.4.3
CMSMasters Content Composer: by cmsmasters – 1.7.7
CMSMasters Importer: by cmsmasters – 1.0.5
CMSMasters Mega Menu: by cmsmasters – 1.2.7
Contact Form 7: by Takayuki Miyoshi – 5.3.2
GDPR Cookie Consent: by WebToffee – 1.9.5
Disable XML-RPC: by Philip Erb – 1.0.1
Easy SVG Support: by Benjamin Zekavica – 2.9
Envato Market: by Envato – 2.0.6
EventON: by AshanJay – 2.7.1
GA Google Analytics: by Jeff Starr – 20201120
Jetpack by WordPress.com: by Automattic – 9.2.1
Mapplic: by sekler – 6.1.1
Real 3D Flipbook: by creativeinteractivemedia – 3.10.3
SG Optimizer: by SiteGround – 5.7.12
Smart Logo Showcase Lite: by AccessPress Themes – 1.1.6
Direct Checkout for WooCommerce: by QuadLayers – 2.4.3
WooCommerce: by Automattic – 4.8.0
WordPress Importer: by wordpressdotorg – 0.7
Yoast SEO: by Team Yoast – 15.5
WP Job Manager: by Automattic – 1.34.5

### Inactive Plugins (3) ###

W3 Total Cache: by BoldGrid – 2.0.1
WooCommerce - PDF Vouchers: by WPWeb – 4.2.3
WooCommerce Admin: by WooCommerce – 1.8.1

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

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-2 (rated-2-2)
rated-3 (rated-3)
rated-3 (rated-3-2)
rated-4 (rated-4)
rated-5 (rated-5)
rated-5 (rated-5-2)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #3840 - /cart/
Cart: #3840 - /cart/
Checkout: #3837 - /checkout/
My account: ? Page not set
Terms and conditions: #9615 - /terms-and-conditions/

### Theme ###

Name: Mall Child
Version: 1.2.0
Author URL: https://cmsmasters.net/
Child Theme: ?
Parent Theme Name: Mall
Parent Theme Version: 1.2.0
Parent Theme Author URL: https://cmsmasters.net/
WooCommerce Support: ?

### Templates ###

Overrides: mall/woocommerce/archive-product.php
mall/woocommerce/content-product.php
mall/woocommerce/content-single-product.php
mall/woocommerce/content-widget-product.php
mall/woocommerce/global/sidebar.php
mall/woocommerce/global/wrapper-end.php
mall/woocommerce/global/wrapper-start.php
mall/woocommerce/loop/loop-start.php
mall/woocommerce/loop/pagination.php
mall/woocommerce/product-searchform.php
mall/woocommerce/single-product/meta.php
mall/woocommerce/single-product/product-image.php
mall/woocommerce/single-product/product-thumbnails.php
mall/woocommerce/single-product/review.php
mall/woocommerce/single-product/tabs/tabs.php
mall/woocommerce/single-product-reviews.php
mall/woocommerce/single-product.php
    Plugin Support RK a11n

    (@riaanknoetze)

    Hi there,

    Just to check – are you seeing any fatal errors being logged under **WooCommerce > System Status > Logs**? Are you seeing any scheduled actions under **WooCommerce > System Status > Scheduled Actions** that are pending/overdue and can be triggered manually?

    Thread Starter Rys

    (@ryn_90)

    At first, when I try to access the page (https://www.thepointmalta.com/wp-admin/admin.php?page=wc-status&tab=action-scheduler), it was showing the below error:

    Error 504 Ray ID: 605946baab48d61c ? 2020-12-22 10:49:27 UTC
    Gateway time-out

    Now I can open it on second load although it still does it intermittently.

    When I open the page I see a message saying:

    “Action Scheduler migration in progress. The list of scheduled actions may be incomplete.”

    Having said that, the last 20 entries seem all to have been marked as completed.

    Also, on further inspection, the database has updated to 4.5.0 since yesterday, although the plugin is 4.8.0.

    • This reply was modified 4 years, 3 months ago by Rys.
    • This reply was modified 4 years, 3 months ago by Rys.
    • This reply was modified 4 years, 3 months ago by Rys.
    Thread Starter Rys

    (@ryn_90)

    The last failed action is from yesterday:

    wc-admin_import_order, failed, 0 => 1231070, wc-admin-data, Non-repeating, 2020-12-21 13:29:00 +0000
    (21 hours 26 minutes ago)
    2020-12-21 13:28:56 +0000
    action created
    2020-12-21 13:50:13 +0000
    action started
    2020-12-21 13:55:56 +0000
    action timed out after 300 seconds
    2020-12-22 10:49:38 +0000
    Migrated action with ID 1954400 in ActionScheduler_wpPostStore to ID 4145 in ActionScheduler_DBStoreMigrator

    Thread Starter Rys

    (@ryn_90)

    @riaanknoetze after a couple of days, I’m at the same point, Plugin is version 4.8.0 and DB is 4.5.0

    Plugin Support mouli a11n

    (@mouli)

    @ryn_90
    Is this still an issue?
    If you are still seeing the error relating to
    Action Scheduler migration in progress. The list of scheduled actions may be incomplete.
    I suggest that you delete all wc-admin_import_order actions as you can manually trigger this import under Analytics ? Settings.

    I also see from your System Status Report that PHP Time Limit: 120 and the error indicates timeouts.
    I suggest that you increase this to PHP Time Limit: 600 and also PHP Max Input Vars: 3000 to PHP Max Input Vars: 10000
    You may need to contact your host to make the changes.

    I hope that helps you to figure it out.
    Feel free to get back to us if you have further questions.

    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.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘CRITICAL Uncaught Error: ActionScheduler_wcSystemStatus.php:79’ is closed to new replies.

Tags