• Resolved Rys

    (@ryn_90)


    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.