• Resolved Ian

    (@ipgill)


    G’day WC support team,

    I’m getting below errors after updating WC plugin. If I deactivate the plugin, the issue goes away.

    Scheduled actions keep piling up and stay pending. It ends up in thousands of recurring pending actions and I have to clear them in phpMyAdmin.

    Could you please help?

    2021-05-30T07:14:54+00:00 CRITICAL require(): Failed opening required '/home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/Note.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /home2/nanotech/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php on line 87
    
    2021-05-30T07:14:56+00:00 CRITICAL Uncaught Error: Call to a member function get_documents() on bool in /home2/nanotech/public_html/wp-content/plugins/woocommerce-pdf-invoices-packing-slips/includes/class-wcpdf-settings-documents.php:18
    Stack trace:
    #0 /home2/nanotech/public_html/wp-includes/class-wp-hook.php(292): WPO\WC\PDF_Invoices\Settings_Documents->init_settings('')
    #1 /home2/nanotech/public_html/wp-includes/class-wp-hook.php(316): WP_Hook->apply_filters(NULL, Array)
    #2 /home2/nanotech/public_html/wp-includes/plugin.php(484): WP_Hook->do_action(Array)
    #3 /home2/nanotech/public_html/wp-admin/admin-ajax.php(45): do_action('admin_init')
    #4 {main}
      thrown in /home2/nanotech/public_html/wp-content/plugins/woocommerce-pdf-invoices-packing-slips/includes/class-wcpdf-settings-documents.php on line 18
    
    2021-05-30T07:18:58+00:00 CRITICAL Uncaught RuntimeException: Unable to claim actions. Database error. in /home2/nanotech/public_html/wp-content/plugins/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:675
    Stack trace:
    #0 /home2/nanotech/public_html/wp-content/plugins/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(599): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, '')
    #1 /home2/nanotech/public_html/wp-content/plugins/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(221): ActionScheduler_DBStore->stake_claim(25, NULL, Array, '')
    #2 /home2/nanotech/public_html/wp-content/plugins/action-scheduler/classes/ActionScheduler_QueueRunner.php(153): ActionScheduler_HybridStore->stake_claim(25)
    #3 /home2/nanotech/public_html/wp-content/plugins/action-scheduler/classes/ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner->do_batch(25, 'Async Request')
    #4 /home2/nanotech/public_html/wp-includes/class-wp-hook.php(292): ActionScheduler_QueueRunner->run('Async Request')
    #5 /home2/ in /home2/nanotech/public_html/wp-content/plugins/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 675

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Thu P. a11n

    (@thup90)

    Hi there,

    As a first step, could you share your System Status Report, it would help us to understand your site setup a bit better. You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, paste it here in your reply.

    Thread Starter Ian

    (@ipgill)

    Thank you for your help.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://nanotechnologysolutions.com.au
    Site address (URL): https://nanotechnologysolutions.com.au
    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: 256 MB
    WP Debug Mode: –
    WP Cron: –
    Language: en_AU
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.16
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d
    
    SUHOSIN Installed: –
    MySQL Version: 10.3.28-MariaDB-cll-lve
    Max Upload Size: 8 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 5.3.0
    WC Database Prefix: wp_
    Total Database Size: 26.28MB
    Database Data Size: 19.92MB
    Database Index Size: 6.36MB
    wp_woocommerce_sessions: Data: 0.03MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 1.52MB + Index: 0.78MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
    wp_ewwwio_images: Data: 0.34MB + Index: 0.19MB + Engine InnoDB
    wp_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_litespeed_cssjs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wp_litespeed_img_optm: Data: 0.16MB + Index: 0.11MB + Engine InnoDB
    wp_litespeed_img_optming: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_litespeed_optimizer: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_field_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf_objectmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nf_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ninja_forms_fav_fields: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_ninja_forms_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 2.22MB + Index: 0.14MB + Engine InnoDB
    wp_postmeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
    wp_posts: Data: 1.44MB + Index: 0.13MB + Engine InnoDB
    wp_po_plugins: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_test: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_test2: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_usermeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    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.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfBlocks7: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
    wp_wfConfig: Data: 1.27MB + Index: 0.00MB + Engine InnoDB
    wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfFileMods: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfHits: Data: 1.02MB + Index: 0.33MB + Engine InnoDB
    wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfKnownFileList: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfLogins: Data: 1.50MB + Index: 0.22MB + Engine InnoDB
    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.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfStatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wp_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 244
    custom_css: 2
    jp_img_sitemap: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    nav_menu_item: 11
    page: 21
    post: 5
    product: 117
    product_variation: 195
    revision: 18
    shop_coupon: 3
    shop_order: 28
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (12) ###
    
    All in One SEO: by All in One SEO Team – 4.1.1.1
    Classic Editor: by WordPress Contributors – 1.6
    LiteSpeed Cache: by LiteSpeed Technologies – 3.6.4
    Ninja Forms: by Saturday Drive – 3.5.4
    Plugin Organizer: by Jeff Sterup – 10.1.5
    UpdraftPlus - Backup/Restore: by UpdraftPlus.com
    DavidAnderson – 1.16.56
    
    Virtue/Ascend/Pinnacle Toolkit: by Kadence WP – 4.9.6
    WooCommerce Stripe Gateway: by WooCommerce – 5.2.0
    WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.9.0
    WooCommerce: by Automattic – 5.3.0
    Woopra: by <a href="https://www.woopra.com">Elie Khoury</a> – 2.9.4
    Wordfence Security: by Wordfence – 7.5.3
    
    ### Inactive Plugins (3) ###
    
    Action Scheduler: by Automattic – 3.1.6
    Post Type Switcher: by Triple J Software
    Inc. – 3.2.1
    
    WooCommerce Admin: by WooCommerce – 2.3.1
    
    ### Dropin Plugins (2) ###
    
    advanced-cache.php: advanced-cache.php
    maintenance.php: maintenance.php
    
    ### Must Use Plugins (2) ###
    
    installatron_hide_status_test.php: by  –
    Plugin Organizer MU: by Jeff Sterup – 10.1.5
    
    ### Settings ###
    
    API Enabled: ?
    Force SSL: ?
    Currency: AUD (A$)
    Currency Position: left_space
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 0
    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-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: –
    
    ### WC Pages ###
    
    Shop base: #860 - /estore/
    Cart: #861 - /estore-cart/
    Checkout: #862 - /estore-checkout/
    My account: #863 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Virtue Child
    Version: 3.3.1
    Author URL: https://nanotechnologysolutions.com.au/
    Child Theme: ?
    Parent Theme Name: Virtue
    Parent Theme Version: 3.4.5
    Parent Theme Author URL: https://kadencewp.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: virtue/woocommerce/archive-product.php
    virtue/woocommerce/content-product.php
    virtue/woocommerce/content-single-product.php
    virtue-child/woocommerce/emails/admin-cancelled-order.php
    virtue-child/woocommerce/emails/admin-failed-order.php
    virtue-child/woocommerce/emails/admin-new-order.php
    virtue/woocommerce/loop/loop-end.php
    virtue/woocommerce/loop/loop-start.php
    virtue/woocommerce/loop/price.php
    virtue/woocommerce/loop/rating.php
    virtue/woocommerce/loop/sale-flash.php
    virtue/woocommerce/single-product/add-to-cart/external.php
    virtue/woocommerce/single-product/add-to-cart/grouped.php
    virtue/woocommerce/single-product/add-to-cart/simple.php
    virtue/woocommerce/single-product/add-to-cart/variable.php
    virtue/woocommerce/single-product/price.php
    virtue/woocommerce/single-product/product-image.php
    virtue/woocommerce/single-product/product-thumbnails.php
    virtue/woocommerce/single-product/sale-flash.php
    virtue/woocommerce/single-product.php
    virtue/woocommerce/content-product_cat.php
    virtue/woocommerce/taxonomy-product_cat.php
    virtue/woocommerce/taxonomy-product_tag.php
    
    
    Thread Starter Ian

    (@ipgill)

    Here is further information received via email:

    WordPress version 5.7.2
    Current theme: Virtue Child (version 3.3.1)
    Current plugin: WooCommerce (version 5.3.0)
    PHP version 7.4.16
    
    Error Details
    =============
    An error of type E_ERROR was caused in line 79 of the file /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php. Error message: Uncaught Error: Call to a member function format() on null in /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php:79
    Stack trace:
    #0 /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(52): ActionScheduler_wcSystemStatus->get_action_status_date('pending', 'oldest')
    #1 /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(27): ActionScheduler_wcSystemStatus->get_oldest_and_newest(Array)
    #2 /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AdminView.php(50): ActionScheduler_wcSystemStatus->render()
    #3 /home2/nanotech/public_html/wp-includes/class-wp-hook.php(292): ActionScheduler_AdminView->system_status_report('')
    #4 /home2/nanotech/public_html/wp-includes/class-wp-hook.php(316): WP_Hook->apply_filters('', Array)
    #5 /home2/nanotec
    Mirko P.

    (@rainfallnixfig)

    Hi @ipgill,

    Thanks for sending over the System Status.

    I’d be curious to see if the same happens when you only have the default theme and WooCommerce active. The best way to determine this is to:

    – Temporarily switch your theme to Storefront.
    – Disable all plugins except for WooCommerce.

    If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here (https://docs.woocommerce.com/document/how-to-test-for-conflicts/).

    Thanks.

    Mirko P.

    (@rainfallnixfig)

    It’s been a while since we last heard back from you, I’m going to mark this thread as resolved.

    Hopefully, the above information helped you out! If you have further questions, please feel free to open a new topic.

    Cheers.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Scheduled actions issue after updating WC’ is closed to new replies.