WooCommerce database update in progress

Resolved mosarafbd
(@mosarafbd)

1 year, 4 months ago

WooCommerce database update in progress

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

You can manually run queued updates here.

` WordPress Environment WordPress address (URL): https://umartbd.com Site address (URL): https://umartbd.com WC Version: 9.6.1 Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site. Action Scheduler Version: ✔ 3.9.1 Log Directory Writable: ✔ WP Version: 6.7.1 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: – Language: en_US External object cache: – Server Environment Server Info: LiteSpeed PHP Version: 8.1.31 PHP Post Max Size: 2 GB PHP Time Limit: 3600 PHP Max Input Vars: 10000 cURL Version: 8.11.0 OpenSSL/1.1.1w SUHOSIN Installed: – MySQL Version: 10.6.20-MariaDB-cll-lve Max Upload Size: 2 GB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ Database WC Database Version: 9.6.0 WC Database Prefix: umb_ Total Database Size: 59.22MB Database Data Size: 53.49MB Database Index Size: 5.73MB umb_woocommerce_sessions: Data: 2.02MB + Index: 0.05MB + Engine InnoDB umb_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB umb_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB umb_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_actionscheduler_actions: Data: 1.52MB + Index: 0.69MB + Engine InnoDB umb_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_actionscheduler_logs: Data: 1.52MB + Index: 0.36MB + Engine InnoDB umb_cartflows_ca_cart_abandonment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_cartflows_visits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_cartflows_visits_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_chaty_contact_form_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB umb_dokan_order_stats: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB umb_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB umb_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_gla_budget_recommendations: Data: 0.19MB + Index: 0.11MB + Engine InnoDB umb_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_litespeed_crawler: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_litespeed_crawler_blacklist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB umb_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB umb_options: Data: 6.03MB + Index: 0.20MB + Engine InnoDB umb_postmeta: Data: 6.50MB + Index: 0.61MB + Engine InnoDB umb_posts: Data: 4.31MB + Index: 0.09MB + Engine InnoDB umb_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_rank_math_analytics_ga: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB umb_rank_math_analytics_inspections: Data: 0.02MB + Index: 0.09MB + Engine InnoDB umb_rank_math_analytics_keyword_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_rank_math_analytics_objects: Data: 0.05MB + Index: 0.02MB + Engine InnoDB umb_rank_math_internal_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB umb_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB umb_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_revslider_sliders7: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_revslider_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_revslider_slides7: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_termmeta: Data: 1.13MB + Index: 0.33MB + Engine InnoDB umb_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB umb_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB umb_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB umb_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB umb_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB umb_visitor_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wcpdf_invoice_number_2024: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB umb_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB umb_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB umb_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB umb_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB umb_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB umb_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wc_product_meta_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB umb_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wfauditevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB umb_wfconfig: Data: 2.44MB + Index: 0.00MB + Engine InnoDB umb_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wffilemods: Data: 16.55MB + Index: 0.00MB + Engine InnoDB umb_wfhits: Data: 0.39MB + Index: 0.05MB + Engine InnoDB umb_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB umb_wfknownfilelist: Data: 7.52MB + Index: 0.00MB + Engine InnoDB umb_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB umb_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY umb_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB umb_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB umb_wfstatus: Data: 0.42MB + Index: 0.22MB + Engine InnoDB umb_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB umb_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_wpmailsmtp_emails_log: Data: 0.30MB + Index: 0.03MB + Engine InnoDB umb_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB umb_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB umb_yourlivechat_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wmb_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts attachment: 192 cartflows_flow: 2 cartflows_step: 5 cms_block: 11 custom_css: 1 elementor_library: 7 mailpoet_page: 1 mc4wp-form: 1 nav_menu_item: 20 oembed_cache: 1 page: 20 post: 3 product: 28 product_variation: 43 rank_math_schema: 1 revision: 21 rm_content_editor: 1 shop_order_placehold: 1 viwec_template: 14 woodmart_size_guide: 1 woodmart_slide: 5 wp_font_family: 11 wp_navigation: 1 wpcf7_contact_form: 1 Security Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ Active Plugins (30) Advanced Database Cleaner: by Younes JFR. – 3.1.5 All-in-One WP Migration: by ServMask – 7.89 Bangladeshi Payment Gateways – Make Payment Using QR Code: by ultraDevs – 3.0.3 Chatway Live Chat: by Chatway Live Chat – 1.3 Chaty: by Premio – 3.3.4 Classic Widgets: by WordPress Contributors – 0.3 Contact Form 7: by Takayuki Miyoshi – 6.0.3 Disable payment method / COD fees for Order for WooCommerce: by PI Websolution – 1.1.9 GTM4WP – A Google Tag Manager (GTM) plugin for WordPress: by Thomas Geiger – 1.20.3 Elementor Pro: by Elementor.com – 3.21.2 Elementor: by Elementor.com – 3.27.3 Email Template Customizer for WooCommerce: by VillaTheme – 1.2.12 Facebook for WooCommerce: by Facebook – 3.3.2 Google for WooCommerce: by WooCommerce – 2.9.8 Site Kit by Google: by Google – 1.145.0 Headers Security Advanced & HSTS WP: by 🐙 Andrea Ferro – 5.0.41 WP Ghost Lite: by WP Ghost – 5.4.01 LiteSpeed Cache: by LiteSpeed Technologies – 6.5.4 MC4WP: Mailchimp for WordPress: by ibericode – 4.10.0 Safe SVG: by 10up – 2.3.1 Rank Math SEO PRO: by Rank Math SEO – 3.0.75 Rank Math SEO: by Rank Math SEO – 1.0.237 SteadFast API: by SteadFast Courier LTD – 1.0.1 WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.3.1 Checkout Field Editor for WooCommerce: by ThemeHigh – 2.1.2 PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.9.6 WooCommerce: by Automattic – 9.6.1 Woodmart Core: by – 1.1.0 Wordfence Security: by Wordfence – 8.0.3 WP Mail SMTP Pro: by WPForms – 2.5.3 Inactive Plugins (0) Dropin Plugins () object-cache.php: LiteSpeed Cache – Object Cache (Drop-in) Settings Legacy API Enabled: – Force SSL: – Currency: BDT (৳ ) 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: – Enforce Approved Product Download Directories: ✔ HPOS feature enabled: ✔ Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore HPOS data sync enabled: – Logging Enabled: ✔ Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 1 day Level threshold: – Log directory size: 2 MB WC Pages Shop base: #13 – /shop/ Cart: #14 – /cart/ – Contains the [woocommerce_cart] shortcode Checkout: #15 – /checkout/ – Contains the [woocommerce_checkout] shortcode My account: #16 – /my-account/ Terms and conditions: #1010 – /terms-conditions/ Theme Name: Woodmart Child Version: 1.0.0 Author URL: http://xtemos.com Child Theme: ✔ Parent Theme Name: Woodmart Parent Theme Version: 8.0.6 Parent Theme Author URL: http://themeforest.net/user/xtemos Theme type: Classic theme WooCommerce Support: ✔ Templates Overrides: woodmart/woocommerce/archive-product.php woodmart/woocommerce/cart/cart-item-data.php woodmart/woocommerce/cart/cart.php woodmart/woocommerce/cart/cross-sells.php version 4.4.0 is out of date. The core version is 9.6.0 woodmart/woocommerce/cart/mini-cart.php woodmart/woocommerce/checkout/form-checkout.php woodmart/woocommerce/checkout/thankyou.php woodmart/woocommerce/content-product-cat.php woodmart/woocommerce/content-product.php woodmart/woocommerce/content-single-product.php woodmart/woocommerce/content-widget-product.php woodmart/woocommerce/global/breadcrumb.php woodmart/woocommerce/global/form-login.php woodmart/woocommerce/global/quantity-input.php woodmart/woocommerce/loop/add-to-cart.php woodmart/woocommerce/loop/loop-end.php woodmart/woocommerce/loop/loop-start.php woodmart/woocommerce/loop/no-products-found.php woodmart/woocommerce/loop/orderby.php woodmart/woocommerce/loop/pagination.php woodmart/woocommerce/loop/sale-flash.php woodmart/woocommerce/myaccount/form-login.php woodmart/woocommerce/product-searchform.php woodmart/woocommerce/single-product/add-to-cart/grouped.php woodmart/woocommerce/single-product/add-to-cart/variable.php version 9.5.0 is out of date. The core version is 9.6.0 woodmart/woocommerce/single-product/meta.php woodmart/woocommerce/single-product/product-attributes.php woodmart/woocommerce/single-product/product-image.php woodmart/woocommerce/single-product/product-thumbnails.php woodmart/woocommerce/single-product/rating.php woodmart/woocommerce/single-product/related.php version 3.9.0 is out of date. The core version is 9.6.0 woodmart/woocommerce/single-product/sale-flash.php woodmart/woocommerce/single-product/tabs/description.php woodmart/woocommerce/single-product/tabs/tabs.php version 3.8.0 is out of date. The core version is 9.6.0 woodmart/woocommerce/single-product/title.php woodmart/woocommerce/single-product/up-sells.php version 3.0.0 is out of date. The core version is 9.6.0 woodmart/woocommerce/single-product-reviews.php version 4.3.0 is out of date. The core version is 9.6.0 woodmart/woocommerce/single-product.php Outdated Templates: ❌ <pre class=”wp-block-code”><code> Learn how to update | Clear system status theme info cache</code></pre> Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customize-store customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner onboarding onboarding-tasks pattern-toolkit-full-composability product-custom-fields remote-inbox-notifications remote-free-extensions payment-gateway-suggestions printful shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page launch-your-store Disabled Features: product-data-views experimental-blocks coming-soon-newsletter-template minified-js product-pre-publish-modal settings async-product-editor-category-field product-editor-template-system blueprint reactify-classic-payments-settings use-wp-horizon add-to-cart-with-options-stepper-layout blockified-add-to-cart Daily Cron: ✔ Next scheduled: 2025-01-26 15:25:28 +06:00 Options: ✔ Notes: 64 Onboarding: completed Action Scheduler Complete: 2,451 Oldest: 2025-01-05 23:24:22 +0000 Newest: 2025-02-05 08:52:19 +0000 Pending: 41 Oldest: 2025-01-22 03:00:00 +0000 Newest: 2025-12-31 18:00:01 +0000 In-progress: 1 Oldest: – Newest: – Status report information Generated at: 2025-02-05 14:52:42 +06:00 `

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

Moses M. (woo-hc)
(@mosesmedh)

1 year, 4 months ago

Hi @mosarafbd,

I’m not sure I fully understand the issue you’re facing. Just to clarify, WooCommerce occasionally updates your database in the background, and this doesn’t require any action on your part. Are you encountering any specific problems? It would be helpful if you could provide more details.

Plugin Support Feten L. a11n
(@fetenlakhal)

1 year, 2 months ago

Hi there, since we haven’t received a reply, I’ll mark this as resolved. We’re available whenever you’d like to pick it up again.

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

The topic ‘WooCommerce database update in progress’ is closed to new replies.