Woocommerce not loading data
-
After migrating my website to a new hosting, I’ve been facing some data load errors in woocommerce in wordpress wp-admin.
I will be attaching images for the errors showing.Also there is this error in error-log
public_html/wp-content/plugins/woocommerce/src/Admin/API/Reports/PerformanceIndicators/Controller.php on line 552Thank You
The page I need help with: [log in to see the link]
-
Hi @yamenaz ,
I understand that you are facing data loading issues after migration.
In order to get a better understanding of your site setup, could you please share a copy of your site’s System Status report which you can find via WooCommerce → Status. Select
Get system report→Copy for support.Once you have this, kindly share it in your response here.
Thanks!
### WordPress Environment ### WordPress address (URL): https://asalli.com Site address (URL): https://asalli.com WC Version: 6.7.0 REST API Version: ✔ 6.7.0 WC Blocks Version: ✔ 7.8.3 Action Scheduler Version: ✔ 3.4.0 Log Directory Writable: ✔ WP Version: 6.0.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 8.1.6 PHP Post Max Size: 512 MB PHP Time Limit: 0 PHP Max Input Vars: 10000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 10.5.15-MariaDB-cll-lve Max Upload Size: 512 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 6.7.0 WC Database Prefix: _14Z_ Total Database Size: 28.10MB Database Data Size: 25.81MB Database Index Size: 2.29MB _14Z_woocommerce_sessions: Data: 0.05MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM _14Z_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.04MB + Engine MyISAM _14Z_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_actionscheduler_actions: Data: 0.21MB + Index: 0.09MB + Engine MyISAM _14Z_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _14Z_actionscheduler_logs: Data: 0.14MB + Index: 0.11MB + Engine MyISAM _14Z_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_comments: Data: 0.04MB + Index: 0.03MB + Engine MyISAM _14Z_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _14Z_e_submissions: Data: 0.22MB + Index: 0.38MB + Engine InnoDB _14Z_e_submissions_actions_log: Data: 0.08MB + Index: 0.11MB + Engine InnoDB _14Z_e_submissions_values: Data: 0.34MB + Index: 0.14MB + Engine InnoDB _14Z_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_options: Data: 6.06MB + Index: 0.18MB + Engine MyISAM _14Z_postmeta: Data: 2.85MB + Index: 0.23MB + Engine MyISAM _14Z_posts: Data: 0.50MB + Index: 0.05MB + Engine MyISAM _14Z_sg_action: Data: 0.02MB + Index: 0.00MB + Engine MyISAM _14Z_sg_config: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_sg_schedule: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _14Z_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _14Z_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _14Z_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_usermeta: Data: 0.06MB + Index: 0.02MB + Engine MyISAM _14Z_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _14Z_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM _14Z_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM _14Z_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _14Z_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_wc_order_product_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM _14Z_wc_order_stats: Data: 0.01MB + Index: 0.01MB + Engine MyISAM _14Z_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _14Z_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _14Z_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _14Z_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _14Z_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM _14Z_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB _14Z_wfconfig: Data: 1.52MB + Index: 0.00MB + Engine InnoDB _14Z_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wffilemods: Data: 6.52MB + Index: 0.00MB + Engine InnoDB _14Z_wfhits: Data: 1.47MB + Index: 0.09MB + Engine InnoDB _14Z_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _14Z_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB _14Z_wfknownfilelist: Data: 4.52MB + Index: 0.00MB + Engine InnoDB _14Z_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _14Z_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wflogins: Data: 0.11MB + Index: 0.03MB + Engine InnoDB _14Z_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _14Z_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB _14Z_wfpklist_template_data: Data: 0.01MB + Index: 0.00MB + Engine MyISAM _14Z_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB _14Z_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB _14Z_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wpmailsmtp_debug_events: Data: 0.14MB + Index: 0.00MB + Engine InnoDB _14Z_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB _14Z_wusers_inputs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_wzen_time_table: Data: 0.00MB + Index: 0.00MB + Engine MyISAM _14Z_yoast_indexable: Data: 0.19MB + Index: 0.09MB + Engine InnoDB _14Z_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB _14Z_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB _14Z_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB _14Z_yoast_seo_links: Data: 0.02MB + Index: 0.01MB + Engine MyISAM _14Z_yoast_seo_meta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM ### Post Type Counts ### attachment: 193 bc_x1379_op_type: 1 custom_css: 1 elementor_font: 3 elementor_library: 11 nav_menu_item: 16 oembed_cache: 8 page: 15 phoe_badge: 1 post: 13 product: 11 product-feed: 1 revision: 51 shop_coupon: 1 shop_order: 73 wobd-badge-designer: 1 wp_global_styles: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (20) ### Async JavaScript: by Frank Goossens (futtta) – 2.21.08.31 Autoptimize: by Frank Goossens (futtta) – 3.1.0 Backup: by BackupGuard – 1.6.8.7 Blackhole for Bad Bots: by Jeff Starr – 3.3.3 Cloudflare: by Cloudflare Inc. – 4.10.1 Elementor Pro: by Elementor.com – 3.4.1 Elementor: by Elementor.com – 3.6.7 Jetpack: by Automattic – 11.1.2 WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 3.0.2 Really Simple SSL: by Really Simple Plugins – 5.3.2 Lazy Load - Optimize Images: by WP Rocket – 2.3.6 Self-Hosted Google Fonts: by asadkn – 1.0.1 Side Cart WooCommerce: by XootiX – 2.1 Woo Align Buttons: by 320up – 3.6.7 Checkout Field Editor for WooCommerce: by ThemeHigh – 1.6.1 WooCommerce: by Automattic – 6.7.0 Yoast SEO: by Team Yoast – 19.3 WP Fastest Cache: by Emre Vona – 1.0.3 WP Mail SMTP: by WPForms – 3.5.1 WP-Optimize - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.2.6 ### Inactive Plugins (4) ### Facebook for WooCommerce: by Facebook – 2.6.12 Net Shipping: by The Net Group – 1.0.0 Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.32 Wordfence Security: by Wordfence – 7.5.11 ### Must Use Plugins (3) ### Endurance Browser Cache: by Mike Hansen – 0.4 Endurance Page Cache: by Mike Hansen – 2.2 SSO: by Garth Mortensen Mike Hansen – 0.4 ### Settings ### API Enabled: – Force SSL: – Currency: LBP (L.L) Currency Position: right_space Thousand Separator: , Decimal Separator: . Number of Decimals: 0 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: ✔ Enforce Approved Product Download Directories: – ### WC Pages ### Shop base: #30 - /shop/ Cart: #204 - /cart/ Checkout: #205 - /checkout/ My account: #206 - /my-account/ Terms and conditions: #602 - /terms-and-conditions/ ### Theme ### Name: Hello Elementor Child Version: 1.0.1 Author URL: https://elementor.com/ Child Theme: ✔ Parent Theme Name: Hello Elementor Parent Theme Version: 2.5.0 – 2.6.1 is available Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash WooCommerce Support: ✔ ### Templates ### Overrides: – ### 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 homescreen 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 wc-pay-promotion wc-pay-welcome-page wc-pay-subscriptions-page Disabled Features: minified-js settings Daily Cron: ✔ Next scheduled: 2022-07-21 14:29:38 +03:00 Options: ✔ Notes: 77 Onboarding: completed ### Action Scheduler ### Complete: 823 Oldest: 2022-06-19 22:00:09 +0000 Newest: 2022-07-20 21:42:41 +0000 Failed: 1 Oldest: – Newest: – Pending: 2 Oldest: 2022-07-21 16:00:05 +0000 Newest: 2022-07-21 16:00:05 +0000 ### Status report information ### Generated at: 2022-07-21 00:42:55 +03:00The conclusion i came into lately is that the issue i am facing is related to cloudflare, because at the checkout page for woocommerce, when placing an order, its throwing an 524 error in the inspect elements. (Failed to load resource: the server responded with a status of 524 (Origin Time-out).)
Hi @yamenaz
From your system status report, I see that you are using the plugin below:
Cloudflare: by Cloudflare Inc. – 4.10.1
To clarify, do your admin pages load fine if the Cloudflare plugin is deactivated? If yes, I’d suggest reaching out to the plugin support and report the issue. Here is a link to their support forum page: https://ww.wp.xz.cn/support/plugin/cloudflare/
Hi @maykato
Even after deactivating cloudflare, woocommerce page doesn’t load fine.
I was checking woocommerce logs here what its showing.
2022-07-21T08:29:47+00:00 CRITICAL Uncaught TypeError: array_search(): Argument #2 ($haystack) must be of type array, null given in /home/public_html/wp-content/plugins/woocommerce/src/Admin/API/Reports/PerformanceIndicators/Controller.php:552 Stack trace: #0 /home/public_html/wp-content/plugins/woocommerce/src/Admin/API/Reports/PerformanceIndicators/Controller.php(552): array_search() #1 /home/public_html/wp-includes/class-wp-hook.php(307): Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->format_data_value() #2 /home/public_html/wp-includes/plugin.php(191): WP_Hook->apply_filters() #3 /home/public_html/wp-content/plugins/woocommerce/src/Admin/API/Reports/PerformanceIndicators/Controller.php(449): apply_filters() #4 /home/public_html/wp-includes/rest-api/class-wp-rest-server.php(1143): Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items() #5 /home/public_html/wp-includes/rest-api/class-wp-rest-server.php(990): WP_REST_Server->respond_to_request() #6 /home/public_html/wp-includes/rest-api/class-wp-rest-server.php(414): WP_REST_Server->dispatch() #7 /home/public_html/wp-includes/rest-api.php(394): WP_REST_Server->serve_request() #8 /home/public_html/wp-includes/class-wp-hook.php(307): rest_api_loaded() #9 /home/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #10 /home/public_html/wp-includes/plugin.php(524): WP_Hook->do_action() #11 /home/public_html/wp-includes/class-wp.php(398): do_action_ref_array() #12 /home/public_html/wp-includes/class-wp.php(770): WP->parse_request() #13 /home/public_html/wp-includes/functions.php(1330): WP->main() #14 /home/public_html/wp-blog-header.php(16): wp() #15 /home/public_html/index.php(17): require('/home/...') #16 {main} thrown in /home/public_html/wp-content/plugins/woocommerce/src/Admin/API/Reports/PerformanceIndicators/Controller.php on line 552Hi @yamenaz ,
Thanks for providing an update.
This could be the cause of a caching plugin and you could disable these and check to see if you are still encountering this issue.
If the issue is still present, I would suggest performing a full conflict test, to rule out any theme/plugins that may be causing this issue.
The best way to determine this is to:
– Clear site and browser cache
– Temporarily switch your theme to Storefront
– Disable all plugins except for WooCommerce
– Check to see if the issue is still presentIf you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each until you find the one causing conflict.
Please see the below documentation for a more detailed explanation of how to do a conflict test here:
https://docs.woocommerce.com/document/how-to-test-for-conflicts
If you prefer not to make any changes to your live site, you have the option of installing the free WP Staging plugin which will clone your site and allow for changes to be made without affecting your live site in any way.
Please let me know how this goes!
Thank you a lot for your reply, i went through all the plugins, wp-mail-smtp was causing the 524 error, problem is now solved.
Best Regards
Hi @yamenaz ,
You are most welcome, happy to hear that you have found the culprit 🙂
Please feel free to create a new thread should you need any further help.
Thanks!
Hi @yamenaz
Good to know you caught the culprit and the problem is resolved! 🙂
If you have a few minutes, we’d love if you could leave us a review:
https://ww.wp.xz.cn/support/plugin/woocommerce/reviews/Thanks
The topic ‘Woocommerce not loading data’ is closed to new replies.