WooCommerce database update blocked in progress
-
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
-
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 🙂
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.
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.
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
RegardsHello,
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.
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?
ThanksHello,
i found out that it was a problem with cloudflare firewall blocking the process. Hope it may be helpful for others.
Thanks
The topic ‘WooCommerce database update blocked in progress’ is closed to new replies.