WooCommerce database update not completing

  • Resolved Henry

    (@henrybaum)


    3 years, 5 months ago

    Usually this finishes in under a minute. Pending tasks are going down to the thirties and then back up again.

    This may be related to WP Rocket – rocket_preload_job_preload_url – I have many of those pending, which is causing Woocommerce not to complete.

    Update: I ran the updates manually, and it said it’s complete, but I still have more than one of these pending, after running it:

    woocommerce_run_product_attribute_lookup_regeneration_callback

    The other ones are not non-repeating.

    • This topic was modified 3 years, 5 months ago by Henry.
    • This topic was modified 3 years, 5 months ago by Henry.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Igor H

    (@ihereira)

    3 years, 5 months ago

    Hello,

    To get a better understanding about this scenario, can you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Then you can include the report in your response. Thanks.

    Thread Starter Henry

    (@henrybaum)

    3 years, 5 months ago

    
### WordPress Environment ###

WordPress address (URL): https://www.selfpublishingreview.com
Site address (URL): https://www.selfpublishingreview.com
WC Version: 7.0.0
REST API Version: ✔ 7.0.0
WC Blocks Version: ✔ 8.5.1
Action Scheduler Version: ✔ 3.5.2
Log Directory Writable: ✔
WP Version: 6.0.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.32
PHP Post Max Size: 516 MB
PHP Time Limit: 60
PHP Max Input Vars: 1000
cURL Version: 7.85.0
OpenSSL/1.1.1q

SUHOSIN Installed: –
MySQL Version: 5.7.23-23
Max Upload Size: 512 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 7.0.0
WC Database Prefix: wp_
Total Database Size: 319.23MB
Database Data Size: 228.91MB
Database Index Size: 90.32MB
wp_woocommerce_sessions: Data: 0.51MB + Index: 0.02MB + 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.41MB + Index: 0.23MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 5.39MB + Index: 2.88MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + 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_abandoned_cart_aelia_currency: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 17.21MB + Index: 8.58MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 3.98MB + Index: 3.48MB + Engine MyISAM
wp_ac_abandoned_cart_history: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ac_atc_rules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ac_connector_sync: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ac_guest_abandoned_cart_history: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ac_link_clicked_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ac_notification_templates: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_ac_opened_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ac_sent_history: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ac_statistics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ac_tiny_urls: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aelia_exchange_rates_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_affiliates_banners_tbl: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_affiliates_clickthroughs_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_affiliates_leads_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_affiliates_payouts_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_affiliates_relations_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_affiliates_sales_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_affiliates_tbl: Data: 0.28MB + Index: 0.05MB + Engine MyISAM
wp_affiliates_user_link_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aff_affiliates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aff_affiliates_attributes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aff_affiliates_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aff_hits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aff_paypal_txn: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aff_referrals: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aff_robots: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aioseo_cache: Data: 0.47MB + Index: 0.03MB + Engine InnoDB
wp_aioseo_notifications: Data: 0.07MB + Index: 0.01MB + Engine MyISAM
wp_aioseo_posts: Data: 5.99MB + Index: 0.41MB + Engine MyISAM
wp_AnythingPopup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_AvailabilityBooking_Bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_AvailabilityBooking_Prices: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bb_forums: Data: 0.17MB + Index: 0.01MB + Engine MyISAM
wp_bb_meta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_bb_posts: Data: 0.15MB + Index: 0.13MB + Engine MyISAM
wp_bb_terms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bb_term_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bb_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bb_topics: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_blc_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_blc_instances: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_blc_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_blc_synch: Data: 0.15MB + Index: 0.10MB + Engine MyISAM
wp_bp_activity_user_activity_cached: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_bp_album: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_bp_friends: Data: 0.03MB + Index: 0.05MB + Engine MyISAM
wp_bp_groups: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_bp_groups_groupmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_bp_groups_members: Data: 0.01MB + Index: 0.04MB + Engine MyISAM
wp_bp_groups_wire: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_bp_links: Data: 0.55MB + Index: 0.07MB + Engine MyISAM
wp_bp_links_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bp_links_linkmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_bp_links_share_grlink: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bp_links_share_prlink: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bp_links_votes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_bp_links_wire: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bp_mod_contents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bp_mod_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bp_user_blogs: Data: 0.05MB + Index: 0.09MB + Engine MyISAM
wp_bp_user_blogs_blogmeta: Data: 0.11MB + Index: 0.07MB + Engine MyISAM
wp_bp_user_blogs_comments: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
wp_bp_user_blogs_posts: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
wp_bp_xprofile_wire: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wp_commentmeta: Data: 0.34MB + Index: 0.27MB + Engine MyISAM
wp_comments: Data: 8.76MB + Index: 2.12MB + Engine MyISAM
wp_comment_rating: Data: 1.58MB + Index: 0.75MB + Engine MyISAM
wp_cp_calculated_fields_form_discount_codes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cp_calculated_fields_form_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cp_calculated_fields_form_revision: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cp_calculated_fields_form_settings: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_edd_customermeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_edd_customers: Data: 0.06MB + Index: 0.05MB + Engine MyISAM
wp_eum_logs: Data: 0.80MB + Index: 0.01MB + Engine MyISAM
wp_ewwwio_images: Data: 17.90MB + Index: 6.26MB + Engine MyISAM
wp_ewwwio_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_freebie_subscriber: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fusion_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fusion_form_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fusion_form_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_fusion_form_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_layerslider: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
wp_layerslider_revisions: Data: 0.06MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_newsletter: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_newsletter_emails: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp_newsletter_sent: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_newsletter_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_newsletter_user_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 8.74MB + Index: 0.69MB + Engine MyISAM
wp_podpress_statcounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_podpress_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_postmeta: Data: 64.49MB + Index: 19.26MB + Engine MyISAM
wp_posts: Data: 62.91MB + Index: 36.39MB + Engine MyISAM
wp_signups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_snippets: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_strong_views: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_termmeta: Data: 0.13MB + Index: 0.10MB + Engine MyISAM
wp_terms: Data: 0.06MB + Index: 0.09MB + Engine MyISAM
wp_term_relationships: Data: 0.52MB + Index: 0.92MB + Engine MyISAM
wp_term_taxonomy: Data: 0.06MB + Index: 0.05MB + Engine MyISAM
wp_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Catalogues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Catalogue_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Custom_Fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Fields_Meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Item_Images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_SubCategories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Tagged_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_UPCP_Tags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usermeta: Data: 3.06MB + Index: 1.86MB + Engine MyISAM
wp_users: Data: 0.38MB + Index: 0.30MB + Engine MyISAM
wp_ust: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wangguardoptions: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.35MB + Index: 0.30MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.40MB + Index: 0.32MB + Engine MyISAM
wp_wc_order_stats: Data: 0.26MB + Index: 0.19MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.15MB + Index: 0.16MB + Engine MyISAM
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfBlockedIPLog: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wp_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfConfig: Data: 2.70MB + Index: 0.02MB + Engine MyISAM
wp_wfCrawlers: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfFileMods: Data: 8.70MB + Index: 0.92MB + Engine MyISAM
wp_wfHits: Data: 1.29MB + Index: 0.15MB + Engine MyISAM
wp_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfIssues: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
wp_wfKnownFileList: Data: 6.60MB + Index: 0.28MB + Engine MyISAM
wp_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfLocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wfLogins: Data: 0.32MB + Index: 0.07MB + 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.03MB + 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.31MB + Index: 0.12MB + Engine MyISAM
wp_wfTrafficRates: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_termmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpr_rocket_cache: Data: 1.52MB + Index: 1.89MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_cat_prod_rel_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_cat_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_coupon_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_customer_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_download_links_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_meta_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_pending_payment_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_products_meta_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_sales_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_save_cart_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wp_eStore_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_WP_SEO_404_links: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_WP_SEO_Redirection: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_WP_SEO_Redirection_LOG: Data: 0.01MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

asp_faq: 2
attachment: 10049
download: 69
easy-pricing-table: 1
edd_discount: 18
edd_log: 1251
edd_payment: 1196
edd-checkout-fields: 1
fmemailverification: 1
fusion_icons: 2
go_pricing_tables: 1
mbt_book: 776
mc4wp-form: 1
member: 2
ml-slide: 5
ml-slider: 1
nav_menu_item: 132
oembed_cache: 1
page: 335
popup: 5
popup_theme: 6
post: 5097
pricing_packages: 1
product: 109
product_variation: 80
pt_view: 48
raccartlist: 3
racemailtemplate: 2
racmaillog: 3
revision: 5408
rpt_pricing_table: 1
sd_download: 1
sd_product: 1
shop_coupon: 37
shop_order: 4009
shop_order_refund: 47
si_profile: 1
slide: 5
tb_book: 1
template: 1
themefusion_elastic: 1
wp_global_styles: 1
wpcf7_contact_form: 62
wpm-testimonial: 197
wpsc_cart_orders: 222
wpt: 1

### Security ###

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

### Active Plugins (44) ###

Aelia Foundation Classes for WooCommerce: by Aelia – 2.3.2.221012
AddToAny Share Buttons: by AddToAny – 1.8.5
Adminimize: by Frank Bültge – 1.11.8
Advanced Excerpt: by WPKube – 4.3.9
Akismet Anti-Spam: by Automattic – 5.0.1
All in One SEO: by All in One SEO Team – 4.2.6.1
Amazon Link Engine: by GeoRiot Networks
Inc. – 1.4.1

Angell EYE Updater: by Angell EYE – 2.0.17
Anti-spam Reloaded: by kudlav
webvitaly – 6.5

Change Quantity on Checkout for WooCommerce: by Bhavik Kiri – 2.0
Code Snippets: by Code Snippets Pro – 3.2.1
Honeypot for Contact Form 7: by Nocean – 2.1.1
Contact Form 7: by Takayuki Miyoshi – 5.6.4
Content Views: by Content Views – 2.4.0.7
Envato Market: by Envato – 2.0.7
EWWW Image Optimizer: by Exactly WWW – 6.9.2
Avada Builder: by ThemeFusion – 3.8.2
Avada Core: by ThemeFusion – 5.8.2
HTML Widget Text: by <a href="https://jaimyn.com.au">Jaimyn Mayer</a> – 1.1
Kadence WooCommerce Email Designer: by Kadence WP – 1.5.7
Ni WooCommerce Dashboard Sales Report: by anzia – 2.2.5
Page Links To: by Mark Jaquith – 3.3.6
PayPal for WooCommerce: by Angell EYE – 3.0.39
Post Snippets: by Postsnippets – 3.1.7
Raw HTML: by Janis Elsts – 1.6.3
Real-Time Find and Replace: by Marios Alexandrou – 4.0.2
Really Simple SSL: by Really Simple Plugins – 5.3.5
WooCommerce Estimated Shipping Date Per Product: by Magerips – 4.8
Easy Updates Manager: by Easy Updates Manager Team – 9.0.14
Taqyeem Predefined Criteria: by TieLabs – 1.0.1
Taqyeem: by TieLabs – 2.6.5
Ultimate Category Excluder: by Marios Alexandrou – 1.6
Unfiltered MU: by Automattic – 1.3.1
WooCommerce Dynamic Pricing & Discounts: by RightPress – 2.4.5
Aelia Currency Switcher for WooCommerce: by Aelia – 4.14.3.220919
Checkout Field Editor for WooCommerce (Pro): by ThemeHigh – 3.4.0
WooCommerce EU VAT Assistant: by Aelia – 2.0.35.221012
WooCommerce: by Automattic – 7.0.0
Wordfence Security: by Wordfence – 7.7.1
WP Mail SMTP: by WPForms – 3.6.1
WP Menu Cart Pro: by WP Overnight – 3.8.1
WP Rocket | Custom cURL Timeout For Preload Requests: by WP Rocket Support Team –
WP Rocket: by WP Media – 3.12.2.1
WP Overnight Sidekick: by WP Overnight – 2.5.1

### Inactive Plugins (3) ###

Abandoned Cart Pro for WooCommerce: by Tyche Softwares – 8.20.1
Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.3
Easy Digital Downloads: by Easy Digital Downloads – 3.1.0.2

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (3) ###

Endurance Browser Cache: by Mike Hansen – 0.4
Endurance Page Cache: by Mike Hansen – 2.2
SSO: by Garth Mortensen
Mike Hansen – 0.4

### 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)
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: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #69634 - /get-reviewed/
Cart: #69623 - /cart/
Checkout: #69624 - /checkout/
My account: #69625 - /my-account/
Terms and conditions: ❌ Page not set

### Theme ###

Name: Avada
Version: 7.8.2
Author URL: https://themeforest.net/user/ThemeFusion
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: Avada/woocommerce/cart/cart.php
Avada/woocommerce/checkout/form-pay.php
Avada/woocommerce/checkout/review-order.php
Avada/woocommerce/checkout/thankyou.php
Avada/woocommerce/loop/loop-start.php
Avada/woocommerce/single-product/add-to-cart/variable.php
Avada/woocommerce/single-product/short-description.php
Avada/woocommerce/single-product/tabs/additional-information.php
Avada/woocommerce/single-product/tabs/description.php

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
settings

Daily Cron: ✔ Next scheduled: 2022-11-02 16:33:18 +02:00
Options: ✔
Notes: 26
Onboarding: completed

### Action Scheduler ###

Complete: 810
Oldest: 2022-11-01 18:39:33 +0000
Newest: 2022-11-01 15:31:50 +0000

Failed: 99
Oldest: 2022-11-01 15:32:14 +0000
Newest: 2022-11-01 19:04:18 +0000

In-progress: 1
Oldest: –
Newest: –

Pending: 30
Oldest: -0001-11-30 00:00:00 +0000
Newest: 2022-11-07 10:33:30 +0000

### Status report information ###

Generated at: 2022-11-01 21:16:10 +02:00
    Thread Starter Henry

    (@henrybaum)

    3 years, 5 months ago

    New issue noticed: woocommerce_ac_send_email_action keeps failing – “action failed via WP Cron: Scheduled action for woocommerce_ac_send_email_action will not be executed as no callbacks are registered.”

    xue28 (woo-hc)

    (@xue28)

    3 years, 5 months ago

    Hi @henrybaum

    Thanks for sending the System Status Report.

    Pending: 30

    I can see that there are lots of pending actions on your site.

    Can you please refer to this support documentation to troubleshoot the problems you’re facing with the Action Scheduler?

    Furthermore, please provide the fatal error logs (if any) under WooCommerce > Status > Logs as well.

    Thread Starter Henry

    (@henrybaum)

    3 years, 5 months ago

    I don’t have any error logs from November, but I do have this from October:

    CRITICAL Uncaught Error: Call to a member function get_tax_class() on null in …/woocommerce/includes/class-wc-cart-totals.php

    which has something to do with Stack Trace of plugins/change-quantity-on-checkout-for-woocommerce/change-quantity-on-checkout-woocommerce.php(138): WC_Cart->calculate_tot in …/woocommerce/includes/class-wc-cart-totals.php

    Saif

    (@babylon1999)

    3 years, 4 months ago

    Hello @henrybaum,

    Thank you for sharing the error logs, but I don’t believe they’re relevant to this problem.

    From the sound of it, something is wrong with the WP-cron. Also, your PHP time limit is very low.

    Please ask your host to increase it to something like 1200 as well as testing the server’s corn functionality.

    Let us know how it goes!

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

The topic ‘WooCommerce database update not completing’ is closed to new replies.