Can’t open WP Dashboard after update to WC 5.7.1

So I should be happy, that I “only” can’t install this version of woocommerce from WordPress dashboard and need to install version 5.6.0 manually. Fantastic :/

Hi @japenz,

As a first step, kindly provide us the following:

• System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
• Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

@uszakow If you need assistance it may be best to start your own thread. We want to make sure that every user’s issue receives its own thread with proper attention.

Thanks.

I have exactly the same problem.

The Woocommerce update seemed to be OK after application (both 5.7 and then 5.7.1) and was applied to Prod server. As a security update, we updated a little quicker than normal.

Yesterday, somewhere between 9am and 11am NZ time, PHP CPU usage suddenly spikes according to my monitoring (NGINX Amplify). About that time, I had to log in again, and the wp-admin page would never complete logon, just process forever. However, if I went to the main site URL, the logon had worked, and I was able to get in to the site. Things kept getting sluggish as I was working, and I noticed several FPM-PHP processes using all the CPU.

Like the other person, I tried rolling back Woocommerce to 5.6.1 but that did not seem to help.

I enabled slow queries log in PHP FPM and I can see that the slow query is entirely made of calls to dashboard statistics:

`script_filename = /srv/websites/kidsinthekitchen.nz/wp-admin/index.php
[0x00007f99156168a0] __construct() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php:321
[0x00007f9915616510] next_day_start() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php:337
[0x00007f99156162e0] next_week_start() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php:478
[0x00007f9915616260] call_user_func() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php:478
[0x00007f9915616190] iterate() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/DataStore.php:635
[0x00007f9915616030] update_interval_boundary_dates() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/Orders/Stats/DataStore.php:409
[0x00007f9915615e40] get_data() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/includes/class-wc-data-store.php:207
[0x00007f9915615d90] __call() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/Revenue/Query.php:64
[0x00007f9915615c90] get_data() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/Revenue/Stats/Controller.php:73
[0x00007f99156157b0] get_items() /srv/websites/kidsinthekitchen.nz/wp-includes/rest-api/class-wp-rest-server.php:1140
[0x00007f99156156d0] respond_to_request() /srv/websites/kidsinthekitchen.nz/wp-includes/rest-api/class-wp-rest-server.php:987
[0x00007f99156155e0] dispatch() /srv/websites/kidsinthekitchen.nz/wp-includes/rest-api.php:495
[0x00007f9915615570] rest_do_request() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/PerformanceIndicators/Controller.php:383
[0x00007f99156153b0] get_stats_data() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/PerformanceIndicators/Controller.php:420`

If I disable the Woocommerce plugin, the dashboard and logon work perfectly, but then obviously my webstore is very lacking in product.

### WordPress Environment ###

WordPress address (URL): https://kidsinthekitchen.nz
Site address (URL): https://kidsinthekitchen.nz
WC Version: 5.7.1
REST API Version: ? 5.7.1
WC Blocks Version: ? 5.9.1
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.6.5
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: ?
WP Cron: ?
Language: en_NZ
External object cache: ?

### Server Environment ###

Server Info: nginx/1.18.0
PHP Version: 7.4.3
PHP Post Max Size: 32 MB
PHP Time Limit: 0
PHP Max Input Vars: 2000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.31-MariaDB-0ubuntu0.20.04.1
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.7.1
WC Database Prefix: wp_
Total Database Size: 356.31MB
Database Data Size: 176.68MB
Database Index Size: 179.63MB
wp_woocommerce_sessions: Data: 2.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 13.52MB + Index: 14.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 1.02MB + Index: 0.83MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 1.02MB + Index: 0.42MB + Engine InnoDB
wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 4.52MB + Index: 3.28MB + Engine InnoDB
wp_csp3_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 5.39MB + Index: 1.11MB + Engine InnoDB
wp_postmeta: Data: 42.56MB + Index: 29.00MB + Engine InnoDB
wp_posts: Data: 14.50MB + Index: 4.50MB + Engine InnoDB
wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 2.50MB + Index: 3.02MB + Engine InnoDB
wp_users: Data: 0.11MB + Index: 0.08MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.27MB + Index: 0.20MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.89MB + Engine InnoDB
wp_wc_order_stats: Data: 0.30MB + Index: 0.30MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 1.39MB + Index: 0.75MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wps_hit: Data: 1.52MB + Index: 2.19MB + Engine InnoDB
wp_wps_index: Data: 70.61MB + Index: 107.89MB + Engine InnoDB
wp_wps_key: Data: 0.45MB + Index: 0.36MB + Engine InnoDB
wp_wps_object_term: Data: 2.22MB + Index: 3.92MB + Engine InnoDB
wp_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_wps_query: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_wps_uri: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
wp_wps_user_agent: Data: 0.16MB + Index: 0.06MB + Engine InnoDB
wp_yoast_indexable: Data: 5.47MB + Index: 4.28MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 1.33MB + Index: 0.59MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amn_wpforms-lite: 1
attachment: 4938
blocks: 3
br_labels: 5
br_popups: 1
custom_css: 4
customize_changeset: 4
hrf_faq: 75
jetpack_migration: 2
jp_img_sitemap: 6
jp_img_sitemap_index: 2
jp_sitemap: 2
jp_sitemap_master: 2
laybuy_quote: 64
ml-slide: 5
ml-slider: 1
nav_menu_item: 42
oembed_cache: 4
page: 17
pf_contact: 38
post: 15
product: 105
product_variation: 1990
revision: 352
ris_gallery: 1
seedprod: 3
shop_coupon: 19
shop_order: 4061
shop_order_refund: 12
ufaq: 1
wapl: 4
wcps: 1
woo_faq: 2
wpforms: 1

### Security ###

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

### Active Plugins (33) ###

Query Monitor: by John Blackbourn – 3.7.1
Addy's NZ Address Autocomplete for WooCommerce: by Addy Limited – 2.1.7
Afterpay Gateway for WooCommerce: by Afterpay – 3.2.2
BackUpWordPress: by XIBO Ltd – 3.11
Facebook for WooCommerce: by Facebook – 2.6.5
Flexible Shipping: by WP Desk – 4.8.3
Gmail SMTP: by naa986 – 1.2.2
Google Authenticator: by Ivan Kruchkoff – 0.53
HTML5 Responsive FAQ: by Ankit Agarwal
Priyanshu Mittal – 2.8.5

Hummingbird: by WPMU DEV – 3.1.0
Jetpack: by Automattic – 10.1
Laybuy Gateway for WooCommerce: by Laybuy – 5.3.4
Markup by Attribute for WooCommerce: by MarkTomlinson – 3.9.6
MetaSlider: by MetaSlider – 3.23.0
Product Input Fields for WooCommerce: by Tyche Softwares – 1.3.1
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.6.0
Woo Discount Rules: by Flycart – 2.3.8
WooCommerce Blocks: by Automattic – 5.9.1
WPC Product Bundles for WooCommerce (Premium): by WPClever – 5.9.2
Additional Variation Images Gallery for WooCommerce - Pro: by Emran Ahmed – 1.2.7
Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.2.7
Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 1.1.18
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.19
WooCommerce Stripe Gateway: by WooCommerce – 5.5.0
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.3
WooCommerce POS: by kilbot – 0.4.26
WooCommerce Product Search: by itthinx – 4.0.1
WooCommerce Shipping & Tax: by WooCommerce – 1.25.18
WooCommerce: by Automattic – 5.7.1
Yoast SEO: by Team Yoast – 17.2
WP Rollback: by impress.org – 1.7.1
WPForms Lite: by WPForms – 1.6.9

### Inactive Plugins (1) ###

WooCommerce Advanced Product Labels: by BeRocket – 3.2.4.4

### Dropin Plugins (3) ###

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class
object-cache.php: Hummingbird Redis Object Cache

### Settings ###

API Enabled: ?
Force SSL: –
Currency: NZD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)
woosb (woosb)

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: ?

### WC Pages ###

Shop base: #8 - /
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My account: #11 - /my-account/
Terms and conditions: #608 - /terms-and-conditions/

### Theme ###

Name: Flatsome
Version: 3.14.3
Author URL: https://www.uxthemes.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: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
/srv/websites/kidsinthekitchen.nz/wp-content/plugins/woo-variation-gallery/templates/product-images.php
/srv/websites/kidsinthekitchen.nz/wp-content/plugins/woo-variation-gallery/templates/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php

### Action Scheduler ###

Cancelled: 2
Oldest: 2021-09-25 14:03:23 +1200
Newest: 2021-09-25 15:40:40 +1200

Complete: 2,283
Oldest: 2021-08-26 19:19:44 +1200
Newest: 2021-09-26 10:43:58 +1300

Failed: 1
Oldest: 2021-05-04 22:51:27 +1200
Newest: 2021-05-04 22:51:27 +1200

Pending: 9
Oldest: 2021-09-26 13:00:00 +1300
Newest: 2021-10-03 03:41:02 +1300

### Status report information ###

Generated at: 2021-09-26 10:50:54 +13:00

Hi @rainfallnixfig
Thank you for getting back to me ??

Please find the requested details below:

System Status:

### WordPress Environment ###

WordPress address (URL): https://comicbookshop.co.nz
Site address (URL): https://comicbookshop.co.nz
WC Version: 5.7.1
REST API Version: ? 5.7.1
WC Blocks Version: ? 5.7.2
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.6.5
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.41 (Ubuntu)
PHP Version: 7.4.3
PHP Post Max Size: 128 MB
PHP Time Limit: 600
PHP Max Input Vars: 1000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 8.0.23-0ubuntu0.20.04.1
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.7.1
WC Database Prefix: wp_3yy6jk71qt_
Total Database Size: 404.49MB
Database Data Size: 326.42MB
Database Index Size: 78.07MB
wp_3yy6jk71qt_woocommerce_sessions: Data: 59.30MB + Index: 2.22MB + Engine MyISAM
wp_3yy6jk71qt_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_3yy6jk71qt_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3yy6jk71qt_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_3yy6jk71qt_woocommerce_order_items: Data: 1.57MB + Index: 0.87MB + Engine MyISAM
wp_3yy6jk71qt_woocommerce_order_itemmeta: Data: 13.72MB + Index: 8.96MB + Engine MyISAM
wp_3yy6jk71qt_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_3yy6jk71qt_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_3yy6jk71qt_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_woocommerce_shipping_zone_locations: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
wp_3yy6jk71qt_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3yy6jk71qt_woocommerce_payment_tokenmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_3yy6jk71qt_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3yy6jk71qt_actionscheduler_actions: Data: 1.34MB + Index: 0.55MB + Engine MyISAM
wp_3yy6jk71qt_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_3yy6jk71qt_actionscheduler_logs: Data: 0.95MB + Index: 0.68MB + Engine MyISAM
wp_3yy6jk71qt_commentmeta: Data: 0.14MB + Index: 0.11MB + Engine MyISAM
wp_3yy6jk71qt_comments: Data: 6.51MB + Index: 2.55MB + Engine MyISAM
wp_3yy6jk71qt_ebay_accounts: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_ebay_auctions: Data: 17.90MB + Index: 0.21MB + Engine MyISAM
wp_3yy6jk71qt_ebay_categories: Data: 0.80MB + Index: 0.38MB + Engine MyISAM
wp_3yy6jk71qt_ebay_jobs: Data: 0.16MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_ebay_log: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wp_3yy6jk71qt_ebay_messages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_ebay_orders: Data: 4.90MB + Index: 0.03MB + Engine MyISAM
wp_3yy6jk71qt_ebay_payment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_ebay_profiles: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_ebay_shipping: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_ebay_sites: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_ebay_stocks_log: Data: 3.08MB + Index: 0.02MB + Engine MyISAM
wp_3yy6jk71qt_ebay_store_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_ebay_transactions: Data: 8.40MB + Index: 0.04MB + Engine MyISAM
wp_3yy6jk71qt_expm_hiiden_content: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3yy6jk71qt_expm_maker: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_expm_maker_pages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_find_and_replace: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_gs_woo_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_newsletter: Data: 0.34MB + Index: 0.16MB + Engine InnoDB
wp_3yy6jk71qt_newsletter_automated: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_newsletter_emails: Data: 2.50MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_newsletter_sent: Data: 1.50MB + Index: 0.44MB + Engine InnoDB
wp_3yy6jk71qt_newsletter_stats: Data: 0.36MB + Index: 0.28MB + Engine InnoDB
wp_3yy6jk71qt_newsletter_user_logs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_options: Data: 11.27MB + Index: 3.48MB + Engine InnoDB
wp_3yy6jk71qt_postmeta: Data: 148.64MB + Index: 33.56MB + Engine MyISAM
wp_3yy6jk71qt_posts: Data: 12.36MB + Index: 2.53MB + Engine MyISAM
wp_3yy6jk71qt_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_shipment_batch_process: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_sr_events: Data: 0.14MB + Index: 0.07MB + Engine MyISAM
wp_3yy6jk71qt_sr_media: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_sr_media_albums: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_sr_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_sr_spinners: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_sr_stat_posts: Data: 0.10MB + Index: 0.13MB + Engine MyISAM
wp_3yy6jk71qt_sr_stat_profile: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_3yy6jk71qt_sr_statistics: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_3yy6jk71qt_term_relationships: Data: 1.50MB + Index: 2.78MB + Engine MyISAM
wp_3yy6jk71qt_term_taxonomy: Data: 0.08MB + Index: 0.06MB + Engine MyISAM
wp_3yy6jk71qt_termmeta: Data: 0.30MB + Index: 0.17MB + Engine MyISAM
wp_3yy6jk71qt_terms: Data: 0.07MB + Index: 0.13MB + Engine MyISAM
wp_3yy6jk71qt_usermeta: Data: 2.07MB + Index: 1.19MB + Engine MyISAM
wp_3yy6jk71qt_users: Data: 0.10MB + Index: 0.12MB + Engine MyISAM
wp_3yy6jk71qt_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_3yy6jk71qt_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_wc_category_lookup: Data: 0.06MB + Index: 0.10MB + Engine MyISAM
wp_3yy6jk71qt_wc_customer_lookup: Data: 0.16MB + Index: 0.14MB + Engine MyISAM
wp_3yy6jk71qt_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_3yy6jk71qt_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_wc_order_product_lookup: Data: 1.59MB + Index: 1.13MB + Engine MyISAM
wp_3yy6jk71qt_wc_order_stats: Data: 0.51MB + Index: 0.29MB + Engine MyISAM
wp_3yy6jk71qt_wc_order_tax_lookup: Data: 0.27MB + Index: 0.29MB + Engine MyISAM
wp_3yy6jk71qt_wc_product_meta_lookup: Data: 0.83MB + Index: 0.69MB + Engine MyISAM
wp_3yy6jk71qt_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_3yy6jk71qt_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3yy6jk71qt_woo_shippment_provider: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_3yy6jk71qt_woocommerce_shipping_table_rates: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
wp_3yy6jk71qt_woocommerce_shipping_zone_shipping_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_3yy6jk71qt_wp_phpmyadmin_extension__errors_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3yy6jk71qt_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_3yy6jk71qt_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_3yy6jk71qt_yoast_indexable: Data: 16.55MB + Index: 9.34MB + Engine InnoDB
wp_3yy6jk71qt_yoast_indexable_hierarchy: Data: 2.52MB + Index: 3.33MB + Engine InnoDB
wp_3yy6jk71qt_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_3yy6jk71qt_yoast_primary_term: Data: 0.16MB + Index: 0.16MB + Engine InnoDB
wp_3yy6jk71qt_yoast_seo_links: Data: 0.31MB + Index: 0.27MB + Engine InnoDB
wp_3yy6jk71qt_yoast_seo_meta: Data: 2.52MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf: 2
action-box: 1
attachment: 7548
carts: 1
custom_css: 3
customize_changeset: 3
feedback: 199
gfw_event: 1
gfw_report: 6
gift_card: 31
ig_campaign: 2
ig_message: 2
is_search_form: 2
media_slider: 1
ml-slide: 10
ml-slider: 2
nav_menu_item: 112
newsletter: 44
nf_sub: 1
o-discount: 5
o-list: 6
oembed_cache: 43
page: 22
popup: 1
popup_theme: 6
post: 1
product: 3807
product_variation: 2721
productsliderwoo: 1
racemailtemplate: 1
revision: 2
rvp: 1
sa_slider: 2
secupress_log_action: 728
secupress_log_err404: 719
shop_coupon: 3
shop_order: 6482
shop_order_refund: 66
sidebar: 1
sliced_invoice: 40
slideshow: 1
soliloquy: 1
sp_wps_shortcodes: 1
vegasslider: 1
wapl: 4
wcps: 2
wcps_layout: 2
wdf_scan: 1
wdf_scan_item: 11
woo_mb_template: 10
wpforms: 1
wysijap: 1
xlwcty_thankyou: 1
yith-wcbm-badge: 2

### Security ###

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

### Active Plugins (54) ###

Mobile Menu Premium: by Rui Guerreiro – 2.8.2.3
Advanced noCaptcha & invisible Captcha: by WP White Security – 6.1.6
Akismet Anti-Spam: by Automattic – 4.1.12
ARI Fancy Lightbox: by ARI Soft – 1.3.8
Classic Editor: by WordPress Contributors – 1.6.2
CMP - Coming Soon & Maintenance Plugin: by NiteoThemes – 4.0.16
Read More: by Edmon – 2.8.4
GazChap's WooCommerce Auto Category Product Thumbnails: by Gareth 'GazChap' Griffiths – 1.3.1
Gmail SMTP: by naa986 – 1.2.2
GS Variation Swatches for WooCommerce Lite: by GS Plugins – 1.5.0
Image Regenerate & Select Crop: by Iulia Cazan – 6.1.0
Images to WebP: by KubiQ – 1.8
Jetpack: by Automattic – 10.1
Kadence WooCommerce Email Designer: by Kadence WP – 1.4.8
Minimum Stock Shortcode: by JP Smith – 1.0
MetaSlider: by MetaSlider – 3.23.0
Newsletter - Automated Newsletters: by The Newsletter Team – 4.5.1
Newsletter - Extended Composer Blocks: by The Newsletter Team – 1.3.5
Newsletter - Reports and Retargeting: by The Newsletter Team – 4.4.3
Newsletter - WooCommerce: by The Newsletter Team – 1.7.1
Newsletter: by Stefano Lissa & The Newsletter Team – 7.2.7
WooCommerce Zip/PartPay Gateway: by BBT Digital – 1.0
reCAPTCHA Jetpack: by bozdoz – 0.2.2
reSmush.it Image Optimizer: by reSmush.it – 0.4.1
Responsive Menu Search Bar: by Ulrich Pogson – 0.1.0
Lazy Load - Optimize Images: by WP Rocket – 2.3.4
SecuPress Free — WordPress Security: by SecuPress – 2.0.3
WooCommerce Show Single Variations by Iconic: by Iconic – 1.1.22
Sliced Invoices: by Sliced Invoices – 3.8.16
SocialRabbit: by Maxim D. & Vitaly K. & Yaroslav N. & Ilya D. – 3.3.18
Two Factor: by Plugin Contributors – 0.7.1
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.16.61.25

Advanced Shipment Tracking for WooCommerce: by zorem – 3.2.9
WPC Fly Cart for WooCommerce: by WPClever – 4.1.4
Thank You Page Customizer for WooCommerce: by VillaTheme – 1.0.5.10
WooCommerce Payment Gateway Based Fees: by InoPlugs – 3.2.3
WooCommerce Advanced Product Labels: by Jeroen Sormani – 1.1.7
Cart Reports for WooCommerce: by WooCommerce – 1.2.10
WooCommerce Conditional Shipping and Payments: by SomewhereWarm – 1.9.5
WooCommerce Cost of Goods: by SkyVerge – 2.11.0
WooCommerce Stripe Gateway: by WooCommerce – 5.5.0
Woocommerce Product Offset Shortcode: by JP Smith – 1.0
PickPlugins Product Slider for WooCommerce: by PickPlugins – 1.13.25
WooCommerce Table Rate Shipping: by WooCommerce – 3.0.33
WooCommerce: by Automattic – 5.7.1
Yoast SEO: by Team Yoast – 17.2
WP Font Awesome: by Zayed Baloch – 1.7.7
WP-Lister Pro for eBay: by WP Lab – 3.0.3
WP phpMyAdmin: by Puvox.software – 5.1.1.05
WP Rocket | WooCommerce Recently Viewed Products Widget Integration: by WP Rocket Support Team –
WP Rocket: by WP Media – 3.9.4
XforWooCommerce: by XforWooCommerce – 1.7.0
YITH WooCommerce Badge Management: by YITH – 1.5.0
YITH WooCommerce Gift Cards Premium: by YITH – 3.3.8

### Inactive Plugins (1) ###

MyCryptoCheckout: by edward_plainview – 2.105

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
maintenance.php: maintenance.php

### Must Use Plugins (2) ###

SecuPress COOKIEHASH: by  – 2.0
SecuPress Salt Keys: by  – 2.0

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: NZD (NZ$)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: auction (auction)
external (external)
gift-card (gift-card)
grouped (grouped)
pw gift card (pw-gift-card)
simple (simple)
subscription (subscription-2)
variable (variable)
wgm_gift_card (wgm_gift_card)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-filtered (exclude-from-filtered)
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: –

### WC Pages ###

Shop base: #26605 - /shop/
Cart: #6 - /cart/
Checkout: #45537 - /checkout/
My account: #8 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Comic Book Shop Child
Version: 1.3.88
Author URL: 
Child Theme: ?
Parent Theme Name: Responsive
Parent Theme Version: 4.6.5
Parent Theme Author URL: https://cyberchimps.com
WooCommerce Support: ?

### Templates ###

Overrides: comicbookshop-child/woocommerce/cart/cart-empty.php
comicbookshop-child/woocommerce/checkout/form-billing.php
comicbookshop-child/woocommerce/checkout/review-order.php
comicbookshop-child/woocommerce/content-widget-product.php
comicbookshop-child/woocommerce/loop/pagination.php

### Action Scheduler ###

Complete: 2,013
Oldest: 2021-09-24 20:07:45 +1200
Newest: 2021-09-26 10:53:07 +1300

Pending: 4
Oldest: 2021-09-26 11:17:06 +1300
Newest: 2021-09-29 18:23:07 +1300

### Status report information ###

Generated at: 2021-09-26 10:54:19 +13:00

Error Log:

2021-09-25T03:34:42+00:00 CRITICAL Uncaught Error: Call to a member function get_page_permastruct() on null in /app/data/public/wp-includes/link-template.php:430
Stack trace:
#0 /app/data/public/wp-includes/link-template.php(392): _get_page_link()
#1 /app/data/public/wp-includes/link-template.php(197): get_page_link()
#2 /app/data/public/wp-includes/link-template.php(4540): get_permalink()
#3 /app/data/public/wp-includes/link-template.php(4579): get_privacy_policy_url()
#4 /app/data/public/wp-includes/link-template.php(4564): get_the_privacy_policy_link()
#5 /app/data/public/wp-content/plugins/two-factor/includes/function.login-footer.php(45): the_privacy_policy_link()
#6 /app/data/public/wp-content/plugins/two-factor/class-two-factor-core.php(708): login_footer()
#7 /app/data/public/wp-content/plugins/two-factor/class-two-factor-core.php(530): Two_Factor_Core::login_html()
#8 /app/data/public/wp-content/plugins/two-factor/class-two-factor-core.php(439): Two_Factor_Core::show_two_factor_login()
#9 /app/data/public/wp-includes/class-wp-hook.php in /app/data/public/wp-includes/link-template.php on line 430

2021-09-25T06:03:36+00:00 CRITICAL Maximum execution time of 600 seconds exceeded in /app/data/public/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php on line 321

2021-09-25T06:05:11+00:00 CRITICAL Maximum execution time of 600 seconds exceeded in /app/data/public/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php on line 321

2021-09-25T06:08:41+00:00 CRITICAL Maximum execution time of 600 seconds exceeded in /app/data/public/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php on line 321

2021-09-25T06:08:45+00:00 CRITICAL Maximum execution time of 600 seconds exceeded in /app/data/public/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php on line 314

2021-09-25T06:08:53+00:00 CRITICAL Maximum execution time of 600 seconds exceeded in /app/data/public/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php on line 321

2021-09-25T06:12:17+00:00 CRITICAL Maximum execution time of 600 seconds exceeded in /app/data/public/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php on line 321

2021-09-25T14:42:20+00:00 CRITICAL Maximum execution time of 600 seconds exceeded in /app/data/public/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php on line 321

2021-09-25T22:08:51+00:00 CRITICAL Maximum execution time of 600 seconds exceeded in /app/data/public/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php on line 319

This is most recent error log, I’m assuming the ‘CRITICAL Maximum execution time of 600 seconds exceeded’ relates to the problem?
I tried deactivating the two-factor plugin as it’s mentioned in the error log, but am still seeing the same issue.

Thanks again for your help ??

Kind regards,
JP

• This reply was modified 3 years, 1 month ago by JapeNZ.

Hi @kidsinthekitchennz,

Thanks for sharing your comments on this thread.

We would like to follow your issue in a separate thread as this is the most suitable way to assist each user since not every WooCommerce user has the same software configuration and hosting.

However said that, it could be one or more plugins no longer compatible with the latest version of WooCommerce and therefore causing trouble. I’d suggest checking if WP Admin is working with a basic installation of the Storefront theme and WooCommerce core only.

More detailed instructions on conflict testing here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

Thanks.

Hello again @rainfallnixfig
So I removed the MyCryptoCheckout plugin and the dashboard now loads up.
Seems deactivating the plugins wasn’t enough for some reason.

The Analytics tab is also available again, however the ‘Performance’ area isn’t displaying anything, here’s an image so you can see what I mean: https://ibb.co/ZmKyRYj

Do you think this is also likely due to a conflict?

Kind regards,
JP

This is most likely related: https://www.ads-software.com/support/topic/5-7-1-analytics-crashing/

Hey @japenz

Happy to hear that you found a solution, very odd though that you had to delete that other plugin for this to work again!

The Analytics tab is also available again, however the ‘Performance’ area isn’t displaying anything

I tried to replicate this on a few test sites I’m runnings, but everything shows as expected for me:

Overview”>
Link to image: https://d.pr/i/KUGuit

If you right click on that page, and click “Inspect” or similar, this will bring up the browser tools, please click on “Console” and see if there are red error messages that might explain why this isn’t loading.

Thanks,

Hi there,

We haven’t heard back from you in a while, so for now I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.