• Resolved hetaweb

    (@hetaweb)


    Hello,
    the update of database is blocked since some days. The website runs smooth but there is the alert box shown on top of dashboard with the following message: “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.”

    Apparently there are 1392 pending processes. What should i do?
    Thanks a lot

Viewing 10 replies - 1 through 10 (of 10 total)
  • We are having the same problem on one of our sites since the 7.0 upgrade. There are hundreds of pending actions in queue which are not being completed.

    Hello @hetaweb,

    I understand the database update process is stuck. Sorry to hear that.

    May I ask can you please temporarily disable all plugins except WooCommerce and then try again?

    You can use the plugin Meks Quick Plugin Disabler it might help you to remember what plugins you currently have active, so switching them back will be easier.

    Let us know how it goes.

    Hi @davor87
    In this forum, we handle issues separately (for better assistance). Please create your own thread for your issue – https://ww.wp.xz.cn/support/plugin/woocommerce/#new-topic-0. I understand the issue could be similar, but please note, each site configuration could be different.

    Thank you 🙂

    Thread Starter hetaweb

    (@hetaweb)

    Hello, i tried to make all updates and now i also see that: https://snipboard.io/DpSQi5.jpg
    Any ideas?
    Thanks a lot!

    Hello,

    For better assistance, please share a copy of your site’s System Status, It is located under WooCommerce > Status. Select “Get system report” and then “Copy for support”. 

    Additionally, share a copy of any fatal error log found under WooCommerce > System Status > Logs (if any).

    Thanks.

    Thread Starter hetaweb

    (@hetaweb)

    Hello,
    below you can find your requests. (i replaced here the website link with a tinyurl)
    Thanks a lot!

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://tinyurl.com/bdh6pp47
    Site address (URL): https://tinyurl.com/bdh6pp47
    WC Version: 7.0.1
    REST API Version: ✔ 7.0.1
    WC Blocks Version: ✔ 8.5.2
    Action Scheduler Version: ✔ 3.5.2
    Log Directory Writable: ✔
    WP Version: 6.1
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: it_IT
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 8.0.25
    PHP Post Max Size: 256 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 9000
    cURL Version: 7.66.0
    OpenSSL/1.1.1q-fips
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.39-42-log
    Max Upload Size: 256 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.8.2
    WC Database Prefix: pzf_
    Total Database Size: 175.33MB
    Database Data Size: 159.54MB
    Database Index Size: 15.79MB
    pzf_woocommerce_sessions: Data: 6.02MB + Index: 0.08MB + Engine InnoDB
    pzf_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    pzf_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_woocommerce_order_itemmeta: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
    pzf_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    pzf_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_actionscheduler_actions: Data: 2.02MB + Index: 1.59MB + Engine InnoDB
    pzf_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_actionscheduler_logs: Data: 1.52MB + Index: 0.77MB + Engine InnoDB
    pzf_aws_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_aws_index: Data: 1.52MB + Index: 0.88MB + Engine InnoDB
    pzf_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_comments: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
    pzf_layerslider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_layerslider_drafts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_mailchimp_carts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    pzf_mailchimp_jobs: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
    pzf_options: Data: 90.23MB + Index: 1.36MB + Engine InnoDB
    pzf_postmeta: Data: 29.14MB + Index: 5.92MB + Engine InnoDB
    pzf_posts: Data: 4.52MB + Index: 0.75MB + Engine InnoDB
    pzf_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
    pzf_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_revslider_slides: Data: 0.03MB + Index: 0.02MB + Engine InnoDB
    pzf_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_sgs_log_events: Data: 16.02MB + Index: 0.00MB + Engine InnoDB
    pzf_sgs_log_visitors: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    pzf_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_term_relationships: Data: 0.30MB + Index: 0.28MB + Engine InnoDB
    pzf_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_usermeta: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
    pzf_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    pzf_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    pzf_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    pzf_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    pzf_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wc_product_meta_lookup: Data: 0.17MB + Index: 0.31MB + Engine InnoDB
    pzf_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    pzf_wfconfig: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    pzf_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    pzf_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    pzf_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    pzf_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    pzf_wpr_rucss_used_css: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    pzf_yith_wapo_addons: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    pzf_yith_wapo_blocks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_yith_wcan_filter_sessions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    pzf_yith_wccl_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_yith_ywrac_email_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    pzf_yoast_indexable: Data: 3.52MB + Index: 1.39MB + Engine InnoDB
    pzf_yoast_indexable_hierarchy: Data: 0.30MB + Index: 0.38MB + Engine InnoDB
    pzf_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    pzf_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    pzf_yoast_seo_links: Data: 0.17MB + Index: 0.13MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    af_product_videos: 1
    attachment: 4125
    custom_css: 1
    customize_changeset: 22
    flamingo_contact: 801
    flamingo_inbound: 1163
    mc4wp-form: 1
    nav_menu_item: 42
    page: 18
    popup: 1
    popup_theme: 9
    post: 6
    product: 1209
    revision: 320
    shop_coupon: 69
    shop_order: 254
    shop_order_refund: 5
    size-chart: 11
    sp_wp_carousel: 1
    sp_wps_shortcodes: 2
    template: 6
    tmm: 2
    wp_global_styles: 1
    wpcf7_contact_form: 3
    wpcf7r_action: 1
    yith_wcan_preset: 1
    yith_wcps_type: 2
    yith-wcpsc-wc-chart: 1
    ywrac_cart: 59
    ywrac_email: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (38) ###
    
    Advanced Woo Search: by ILLID – 2.66
    Classic Editor: by WordPress Contributors – 1.6.2
    Classic Widgets: by WordPress Contributors – 0.3
    Click to Chat: by HoliThemes – 3.15
    Contact Form 7 - Dynamic Text Extension: by Chris Mavricos
    SevenSpark – 2.0.3
    
    Contact Form 7 Extension For Mailchimp: by Renzo Johnson – 0.5.62
    Contact Form 7: by Takayuki Miyoshi – 5.6.4
    Duplicate Page: by mndpsingh287 – 4.4.9
    Facebook for WooCommerce: by Facebook – 2.6.28
    Flamingo: by Takayuki Miyoshi – 2.3
    Font Awesome: by Font Awesome – 4.3.1
    Site Kit by Google: by Google – 1.86.0
    Klarna On-Site Messaging for WooCommerce: by krokedil
    klarna – 1.9.0
    
    Klarna Order Management for WooCommerce: by klarna
    krokedil – 1.7.0
    
    Klarna Payments for WooCommerce: by krokedil
    klarna
    automattic – 2.12.1
    
    Mailchimp for WooCommerce: by Mailchimp – 2.7.6
    MC4WP: Mailchimp for WordPress: by ibericode – 4.8.11
    PixelYourSite: by PixelYourSite – 9.2.1
    Popup Maker: by Popup Maker – 1.16.12
    SiteGround Optimizer: by SiteGround – 7.2.5
    Team Members: by WP Darko – 5.1.1
    Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.6.0
    Trustpilot-reviews: by Trustpilot – 2.5.914
    WooCommerce Smart COD: by woosmartcod.com – 1.6.1
    Checkout Field Editor for WooCommerce: by ThemeHigh – 1.8.0
    WooCommerce PayPal Payments: by WooCommerce – 1.9.5
    WooCommerce: by Automattic – 7.0.1
    Yoast SEO: by Team Yoast – 19.9
    WP Mail SMTP: by WPForms – 3.6.1
    WP Rocket: by WP Media – 3.11.4.2
    Redirection for Contact Form 7: by Qube One – 2.7.0
    YITH Product Size Charts for WooCommerce Premium: by YITH – 1.15.0
    YITH WooCommerce Added to Cart Popup Premium: by YITH – 2.1.0
    YITH WooCommerce Product Add-ons & Extra Options Premium: by YITH – 3.7.0
    YITH WooCommerce Ajax Product Filter Premium: by YITH – 4.15.0
    YITH WooCommerce Featured Audio and Video Content Premium: by YITH – 1.18.0
    YITH WooCommerce Product Slider Carousel Premium: by YITH – 1.15.0
    YITH WooCommerce Recover Abandoned Cart Premium: by YITH – 2.16.0
    
    ### Inactive Plugins (8) ###
    
    Feed Them Social - for Twitter feed, Youtube, and more: by SlickRemix – 3.0.1
    Loco Translate: by Tim Whitlock – 2.6.3
    SiteGround Security: by SiteGround – 1.3.5
    Slider Revolution: by ThemePunch – 6.5.19
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.16
    Wordfence Security: by Wordfence – 7.7.1
    YITH WooCommerce Bulk Product Editing Premium: by YITH – 1.9.0
    YITH WooCommerce Featured Video: by YITH – 1.18.0
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left_space
    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: #5 - /shop/
    Cart: #6 - /cart/
    Checkout: #7 - /checkout/
    My account: #8 - /my-account/
    Terms and conditions: #703 - /termini-e-condizioni/
    
    ### Theme ###
    
    Name: Betheme
    Version: 26.2.1
    Author URL: https://muffingroup.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 ###
    
    Archive Template: Your theme has a woocommerce.php file
    you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
    
    Overrides: betheme/woocommerce/archive-product.php
    betheme/woocommerce/cart/cart-totals.php
    betheme/woocommerce/cart/cart.php version 4.4.0 is out of date. The core version is 7.0.1
    betheme/woocommerce/cart/cross-sells.php
    betheme/woocommerce/cart/mini-cart.php
    betheme/woocommerce/checkout/form-checkout.php
    betheme/woocommerce/content-product.php
    betheme/woocommerce/content-single-product.php
    betheme/woocommerce/loop/loop-end.php
    betheme/woocommerce/loop/loop-start.php
    betheme/woocommerce/loop/no-products-found.php
    betheme/woocommerce/loop/pagination.php
    betheme/woocommerce/myaccount/downloads.php
    betheme/woocommerce/notices/error.php
    betheme/woocommerce/notices/success.php
    betheme/woocommerce/single-product/add-to-cart/external.php version 3.4.0 is out of date. The core version is 7.0.1
    betheme/woocommerce/single-product/meta.php
    betheme/woocommerce/single-product/product-image.php
    betheme/woocommerce/single-product/product-thumbnails.php
    betheme/woocommerce/single-product/related.php
    betheme/woocommerce/single-product/sale-flash.php
    betheme/woocommerce/single-product/tabs/description.php
    betheme/woocommerce/single-product/tabs/tabs.php
    betheme/woocommerce/single-product/title.php
    betheme/woocommerce/single-product/up-sells.php
    betheme/woocommerce/single-product-reviews.php
    
    Outdated Templates: ❌
    					
    					
    						Learn how to update
    
    ### Klarna Payments Request Log ###
    
    2022-10-22 07:08:49: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:27: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:27: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:23: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:23: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:10: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:10: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:10: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:09: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:09: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:05: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:05: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:04: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:04: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    2022-10-22 07:06:04: KP Create Session
    Response code: 401
    Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}
    Correlation ID:
    
    ### Klarna Countries ###
    
    Production Countries: IT
    Test Countries: No countries selected
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ✔
    Shop country code: IT
    WooCommerce currency supported: ✔
    Advanced Card Processing available in country: ✔
    Pay Later messaging available in country: ✔
    Webhook status: –
    Vault enabled: ✔
    Logging enabled: –
    Reference Transactions: –
    Used PayPal Checkout plugin: –
    Tracking enabled: –
    
    ### 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-09-22 22:09:40 +00:00
    Options: ✔
    Notes: 68
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 2,946
    Oldest: 2022-08-22 17:06:25 +0000
    Newest: 2022-10-24 06:34:06 +0000
    
    Pending: 1,774
    Oldest: -0001-11-30 00:00:00 +0000
    Newest: 2022-11-04 14:47:55 +0000
    
    Canceled: 2,286
    Oldest: -0001-11-30 00:00:00 +0000
    Newest: -0001-11-30 00:00:00 +0000
    
    ### Status report information ###
    
    Generated at: 2022-11-04 14:56:27 +00:00
    
    __________________ LOG 1 ___________________
    

    2022-09-12T22:09:48+00:00 ERROR Spec is invalid because a rule is invalid in feed
    2022-09-12T22:09:48+00:00 ERROR stdClass Object
    (
    [type] => wcadmin_active_for
    [operation] => >
    [months] => 11
    )

    2022-09-12T22:09:48+00:00 ERROR stdClass Object
    (
    [slug] => googlelistings_signals2022_hasGLA
    [type] => marketing
    [status] => unactioned
    [is_snoozable] => 0
    [source] => woocommerce.com
    [locales] => Array
    (
    [0] => stdClass Object
    (
    [locale] => en_US
    [title] => Show off your products with Ads on Google
    [content] => You’re ready to grow with ads. Google optimizes for performance across your products; you only pay for results. If you’re new to Google, you can earn up to $500 in ad credits (T&Cs apply). Contact support if you need guidance with Google Listings & Ads.
    )

    )

    [actions] => Array
    (
    [0] => stdClass Object
    (
    [name] => googlelistings_signals2022_hasGLA_click
    [locales] => Array
    (
    [0] => stdClass Object
    (
    [locale] => en_US
    [label] => Connect Google Listings & Ads
    )

    )

    [url] => admin.php?page=wc-admin&path=marketing
    [url_is_admin_query] => 1
    [is_primary] => 1
    [status] => unactioned
    )

    )

    [rules] => Array
    (
    [0] => stdClass Object
    (
    [type] => publish_after_time
    [publish_after] => 2022-09-12 07:23:39
    )

    [1] => stdClass Object
    (
    [type] => publish_before_time
    [publish_before] => 2022-10-12 23:59:00
    )

    [2] => stdClass Object
    (
    [type] => plugins_activated
    [plugins] => Array
    (
    [0] => google-listings-and-ads
    )

    )

    [3] => stdClass Object
    (
    [type] => wcadmin_active_for
    [operation] => >
    [months] => 11
    )

    [4] => stdClass Object
    (
    [type] => product_count
    [operation] => >
    [value] => 76
    )

    [5] => stdClass Object
    (
    [type] => order_count
    [operation] => >
    [value] => 38
    )

    [6] => stdClass Object
    (
    [type] => total_payments_value
    [days] => last_year
    [value] => 3700
    [operation] => >
    )

    )

    )

    2022-09-12T22:09:48+00:00 ERROR Spec is invalid because a rule is invalid in feed
    2022-09-12T22:09:48+00:00 ERROR stdClass Object
    (
    [type] => wcadmin_active_for
    [operation] => >
    [months] => 11
    )

    2022-09-12T22:09:48+00:00 ERROR stdClass Object
    (
    [slug] => googlelistings_signals2022_noGLA
    [type] => marketing
    [status] => unactioned
    [is_snoozable] => 0
    [source] => woocommerce.com
    [locales] => Array
    (
    [0] => stdClass Object
    (
    [locale] => en_US
    [title] => Show off your products with Ads on Google
    [content] => You’re ready to grow with ads. Google optimizes for performance across your products; you only pay for results. If you’re new to Google, you can earn up to $500 in ad credits (T&Cs apply). Contact support if you need guidance with Google Listings & Ads.
    )

    )

    [actions] => Array
    (
    [0] => stdClass Object
    (
    [name] => googlelistings_signals2022_noGLA
    [locales] => Array
    (
    [0] => stdClass Object
    (
    [locale] => en_US
    [label] => Connect Google Listings & Ads
    )

    )

    [url] => https://woocommerce.com/products/google-listings-and-ads/?utm_medium=product&utm_source=inbox_note&utm_campaign=googlelistings_signals2022_noGLA
    [url_is_admin_query] =>
    [is_primary] => 1
    [status] => unactioned
    )

    )

    [rules] => Array
    (
    [0] => stdClass Object
    (
    [type] => publish_after_time
    [publish_after] => 2022-09-12 07:27:46
    )

    [1] => stdClass Object
    (
    [type] => publish_before_time
    [publish_before] => 2022-10-12 23:59:00
    )

    [2] => stdClass Object
    (
    [type] => not
    [operand] => Array
    (
    [0] => stdClass Object
    (
    [type] => plugins_activated
    [plugins] => Array
    (
    [0] => google-listings-and-ads
    )

    )

    )

    )

    [3] => stdClass Object
    (
    [type] => wcadmin_active_for
    [operation] => >
    [months] => 11
    )

    [4] => stdClass Object
    (
    [type] => product_count
    [operation] => >
    [value] => 76
    )

    [5] => stdClass Object
    (
    [type] => order_count
    [operation] => >
    [value] => 38
    )

    [6] => stdClass Object
    (
    [type] => total_payments_value
    [days] => last_year
    [value] => 3700
    [operation] => >
    )

    )

    )`

    
    -------------------- LOG 2 ----------------------
    

    2022-09-13T22:09:41+00:00 ERROR Spec is invalid because a rule is invalid in feed
    2022-09-13T22:09:41+00:00 ERROR stdClass Object
    (
    [type] => wcadmin_active_for
    [operation] => >
    [months] => 11
    )

    2022-09-13T22:09:41+00:00 ERROR stdClass Object
    (
    [slug] => googlelistings_signals2022_hasGLA
    [type] => marketing
    [status] => unactioned
    [is_snoozable] => 0
    [source] => woocommerce.com
    [locales] => Array
    (
    [0] => stdClass Object
    (
    [locale] => en_US
    [title] => Show off your products with Ads on Google
    [content] => You’re ready to grow with ads. Google optimizes for performance across your products; you only pay for results. If you’re new to Google, you can earn up to $500 in ad credits (T&Cs apply). <a href=”https://woocommerce.com/my-account/create-a-ticket/”>Contact support</a> if you need guidance with Google Listings & Ads.
    )

    )

    [actions] => Array
    (
    [0] => stdClass Object
    (
    [name] => googlelistings_signals2022_hasGLA_click
    [locales] => Array
    (
    [0] => stdClass Object
    (
    [locale] => en_US
    [label] => Connect Google Listings & Ads
    )

    )

    [url] => admin.php?page=wc-admin&path=marketing
    [url_is_admin_query] => 1
    [is_primary] => 1
    [status] => unactioned
    )

    )

    [rules] => Array
    (
    [0] => stdClass Object
    (
    [type] => publish_after_time
    [publish_after] => 2022-09-12 07:23:39
    )

    [1] => stdClass Object
    (
    [type] => publish_before_time
    [publish_before] => 2022-10-12 23:59:00
    )

    [2] => stdClass Object
    (
    [type] => plugins_activated
    [plugins] => Array
    (
    [0] => google-listings-and-ads
    )

    )

    [3] => stdClass Object
    (
    [type] => wcadmin_active_for
    [operation] => >
    [months] => 11
    )

    [4] => stdClass Object
    (
    [type] => product_count
    [operation] => >
    [value] => 76
    )

    [5] => stdClass Object
    (
    [type] => order_count
    [operation] => >
    [value] => 38
    )

    [6] => stdClass Object
    (
    [type] => total_payments_value
    [days] => last_year
    [value] => 3700
    [operation] => >
    )

    )

    )

    2022-09-13T22:09:41+00:00 ERROR Spec is invalid because a rule is invalid in feed
    2022-09-13T22:09:41+00:00 ERROR stdClass Object
    (
    [type] => wcadmin_active_for
    [operation] => >
    [months] => 11
    )

    2022-09-13T22:09:41+00:00 ERROR stdClass Object
    (
    [slug] => googlelistings_signals2022_noGLA
    [type] => marketing
    [status] => unactioned
    [is_snoozable] => 0
    [source] => woocommerce.com
    [locales] => Array
    (
    [0] => stdClass Object
    (
    [locale] => en_US
    [title] => Show off your products with Ads on Google
    [content] => You’re ready to grow with ads. Google optimizes for performance across your products; you only pay for results. If you’re new to Google, you can earn up to $500 in ad credits (T&Cs apply). <a href=”https://woocommerce.com/my-account/create-a-ticket/”>Contact support</a> if you need guidance with Google Listings & Ads.
    )

    )

    [actions] => Array
    (
    [0] => stdClass Object
    (
    [name] => googlelistings_signals2022_noGLA
    [locales] => Array
    (
    [0] => stdClass Object
    (
    [locale] => en_US
    [label] => Connect Google Listings & Ads
    )

    )

    [url] => https://woocommerce.com/products/google-listings-and-ads/?utm_medium=product&utm_source=inbox_note&utm_campaign=googlelistings_signals2022_noGLA
    [url_is_admin_query] =>
    [is_primary] => 1
    [status] => unactioned
    )

    )

    [rules] => Array
    (
    [0] => stdClass Object
    (
    [type] => publish_after_time
    [publish_after] => 2022-09-12 07:27:46
    )

    [1] => stdClass Object
    (
    [type] => publish_before_time
    [publish_before] => 2022-10-12 23:59:00
    )

    [2] => stdClass Object
    (
    [type] => not
    [operand] => Array
    (
    [0] => stdClass Object
    (
    [type] => plugins_activated
    [plugins] => Array
    (
    [0] => google-listings-and-ads
    )

    )

    )

    )

    [3] => stdClass Object
    (
    [type] => wcadmin_active_for
    [operation] => >
    [months] => 11
    )

    [4] => stdClass Object
    (
    [type] => product_count
    [operation] => >
    [value] => 76
    )

    [5] => stdClass Object
    (
    [type] => order_count
    [operation] => >
    [value] => 38
    )

    [6] => stdClass Object
    (
    [type] => total_payments_value
    [days] => last_year
    [value] => 3700
    [operation] => >
    )

    )

    )`

    Hello,

    Upon checking the system status report, it looks the site has pending jobs, sorry for asking again, you can disable temporarily all plugins except WooCommerce, then go to WooCommerce > status > scheduled actions > pending, and run all the pending actions (if applicable). Then you can try again to update the database.

    A plugin like WP Crontrol might help you monitor the cron jobs.

    Let me know if this worked for you.

    Thread Starter hetaweb

    (@hetaweb)

    Hello
    i am sorry to confirm that i did again what you wrote, but it didn’t work.
    Furthermore it was not possible to run all pending actions
    Waiting for your kind reply
    Thanks
    Regards

    Hello,

    Thanks for responding and sorry to hear that the issue is still present.

    Please head to WooCommerce > Status > Tools, Be sure to clear the WooCommerce Transients and Expired Transients, then try again to update the database.

    Let us know if this makes a difference.

    Thread Starter hetaweb

    (@hetaweb)

    Hello Igor,
    thanks for your effort. i tried to clear all transient but the problem is still present. Can you please have a look inside the backend?
    Thanks

    Thread Starter hetaweb

    (@hetaweb)

    Hello,
    i found out that it was a problem with cloudflare firewall blocking the process. Hope it may be helpful for others.
    Thanks

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

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