WooCommerce is updating the database in the background. The database update proc

  • Resolved quirkymissy

    (@quirkylissy)


    1 year, 8 months ago

    Hello,

    I am having trouble with crons and woocommerce database updating. The message below has been stuck for days now:

    WooCommerce is updating the database in the background. The database update process may take a little while, so please be patient.

    The system report:
    

WordPress Environment

WordPress address (URL): https://lismakes.com
    Site address (URL): https://lismakes.com
    WC Version: 7.5.0
    REST API Version: ? 7.5.0
    WC Blocks Version: ? 9.6.5
    Action Scheduler Version: ? 3.5.4
    Log Directory Writable: ?
    WP Version: 6.1.1
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: ?

Server Environment

Server Info: LiteSpeed
    PHP Version: 7.4.32
    PHP Post Max Size: 512 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 5000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d

SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.6.10-MariaDB-cll-lve
    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.4.1
    WC Database Prefix: wpdi_
    Total Database Size: 23.45MB
    Database Data Size: 19.06MB
    Database Index Size: 4.39MB
    wpdi_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpdi_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpdi_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_actionscheduler_actions: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
    wpdi_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_actionscheduler_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wpdi_aioseo_cache: Data: 0.20MB + Index: 0.03MB + Engine InnoDB
    wpdi_aioseo_notifications: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wpdi_aioseo_posts: Data: 0.20MB + Index: 0.02MB + Engine InnoDB
    wpdi_aiowps_debug_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_aiowps_failed_logins: Data: 1.52MB + Index: 1.02MB + Engine InnoDB
    wpdi_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_aiowps_login_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_aiowps_login_lockdown: Data: 1.52MB + Index: 0.63MB + Engine InnoDB
    wpdi_aiowps_permanent_block: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_bv_activities_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_bv_ip_store: Data: 0.27MB + Index: 0.16MB + Engine InnoDB
    wpdi_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_cartflows_ca_cart_abandonment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_commentmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpdi_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wpdi_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_litespeed_url_file: Data: 0.05MB + Index: 0.08MB + Engine InnoDB
    wpdi_options: Data: 7.50MB + Index: 0.30MB + Engine InnoDB
    wpdi_postmeta: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
    wpdi_posts: Data: 4.50MB + Index: 0.14MB + Engine InnoDB
    wpdi_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_s2w_error_product_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_social_rocket_count_data: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpdi_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpdi_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpdi_term_relationships: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    wpdi_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpdi_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpdi_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpdi_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpdi_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpdi_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpdi_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpdi_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wpdi_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpdi_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpdi_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

attachment: 266
    cookielawinfo: 6
    custom_css: 6
    e-landing-page: 1
    elementor_library: 2
    is_search_form: 4
    nav_menu_item: 25
    page: 10
    pagelayer-template: 4
    post: 14
    product: 30
    wpforms: 1

Security

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

Active Plugins (23)

Ivory Search: by Ivory Search – 5.5
    Akismet Anti-Spam: by Automattic – 5.0.2
    All in One SEO: by All in One SEO Team – 4.3.3
    All In One WP Security: by All In One WP Security & Firewall Team – 5.1.5
    Classic Editor: by WordPress Contributors – 1.6.2
    Classic Widgets: by WordPress Contributors – 0.3
    CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.8
    Elementor: by Elementor.com – 3.11.5
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.13.1
    Site Kit by Google: by Google – 1.96.0
    Jetpack: by Automattic – 11.9.1
    Kirki Customizer Framework: by David Vongries – 4.1.1
    LiteSpeed Cache: by LiteSpeed Technologies – 5.3.3
    Menu Image: by Freshlight Lab – 3.0.8
    Otter – Page Builder Blocks & Extensions for Gutenberg: by ThemeIsle – 2.2.3
    Really Simple SSL: by Really Simple Plugins – 6.2.2
    Recent Posts Widget With Thumbnails: by Kybernetik Services – 7.1.1
    Redis Object Cache: by Till Krüss – 2.2.4
    Templates Patterns Collection: by ThemeIsle – 1.1.36
    WooCommerce External Product New Tab: by Stuart Duff – 1.0.4
    WooCommerce: by Automattic – 7.5.0
    WP Crontrol: by John Blackbourn & crontributors – 1.15.2
    WPForms Lite: by WPForms – 1.8.0.2

Inactive Plugins (0)

Dropin Plugins (1)

object-cache.php: Redis Object Cache Drop-In

Must Use Plugins (1)

Endurance Page Cache: by Mike Hansen – 2.2

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: –
    Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: ? Page visibility should be public
    Cart: ? Page ID is set
    but the page does not exist

Checkout: ? Page ID is set
    but the page does not exist

My account: ? Page ID is set
    but the page does not exist

Terms and conditions: ? Page not set

Theme

Name: Neve
    Version: 3.5.5
    Author URL: https://themeisle.com
    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: neve/woocommerce/product-searchform.php

Admin

Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    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
    product-variation-management
    settings

Daily Cron: ? Not scheduled
    Options: ?
    Notes: 40
    Onboarding: completed

Action Scheduler

Complete: 118
    Oldest: 2022-12-09 02:28:10 -0500
    Newest: 2023-01-06 00:20:50 -0500

Pending: 15
    Oldest: 2023-03-14 15:21:30 -0400
    Newest: 2023-03-22 07:00:57 -0400

In-progress: 1
    Oldest: –
    Newest: –

Canceled: 106
    Oldest: -0001-11-29 19:03:58 -0456
    Newest: -0001-11-29 19:03:58 -0456

Status report information

Generated at: 2023-03-18 13:52:32 -04:00
    `
Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @quirkylissy

    Thanks for reaching out!

    I understand that the updating of the WooCommerce database on your site is not finishing as expected, correct?

    Base on the screenshots above, there are four identical tasks in Pending state. Can you please try to delete all of these tasks and run the database update manually by going to WooCommerce > Status > Tools > Update Database?

    If this did not resolve the issue, please provide the fatal error logs (if any) under WooCommerce > Status > Logs.

    Plugin Support Beauty of Code (woo-hc)

    (@beautyofcode)

    Hi @quirkylissy ,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.

    Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WooCommerce is updating the database in the background. The database update proc’ is closed to new replies.