• Resolved atsiteros

    (@atsiteros)


    Hi there, I am unable to view WooCommerce Analytics Stats since last week. I get the error message. Error getting stats. Please try again later. with the huge purple warning triangles displayed.

    I have cleared the analytics cache, it does not help. This is the status report below.

    Please can you assist?

    WordPress Environment
    
    WordPress address (URL): https://coldbuster.co.za
    Site address (URL): https://coldbuster.co.za
    WC Version: 7.7.0
    REST API Version: ? 7.7.0
    WC Blocks Version: ? 10.0.4
    Action Scheduler Version: ? 3.5.4
    Log Directory Writable: ?
    WP Version: 6.2.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_ZA
    External object cache: –
    
    Server Environment
    
    Server Info: nginx/1.20.2
    PHP Version: 8.2.3
    PHP Post Max Size: 100 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 20000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f
    
    SUHOSIN Installed: –
    MySQL Version: 10.5.17-MariaDB-1:10.5.17+maria~ubu2004-log
    Max Upload Size: 100 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    Database
    
    WC Database Version: 7.7.0
    WC Database Prefix: wp_
    Total Database Size: 39.45MB
    Database Data Size: 31.13MB
    Database Index Size: 8.32MB
    wp_woocommerce_sessions: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.25MB + Index: 0.15MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 2.50MB + Index: 1.18MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_actions: Data: 0.13MB + Index: 0.07MB + Engine MyISAM
    wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_actionscheduler_logs: Data: 0.08MB + Index: 0.07MB + Engine MyISAM
    wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
    wp_comments: Data: 1.01MB + Index: 0.35MB + Engine MyISAM
    wp_cr_local_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_em_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_em_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_em_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_em_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_em_tickets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_em_tickets_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_hugeit_slider_slide: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_hugeit_slider_slider: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_litespeed_img_optm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_options: Data: 2.77MB + Index: 0.15MB + Engine MyISAM
    wp_pmxe_exports: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
    wp_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM
    wp_pmxe_posts: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_pmxe_templates: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
    wp_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_pmxi_imports: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_pmxi_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_postmeta: Data: 5.72MB + Index: 2.58MB + Engine MyISAM
    wp_posts: Data: 1.20MB + Index: 0.18MB + Engine MyISAM
    wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_terms: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_term_relationships: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_usermeta: Data: 1.86MB + Index: 1.13MB + Engine MyISAM
    wp_users: Data: 0.21MB + Index: 0.15MB + Engine MyISAM
    wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine MyISAM
    wp_wc_admin_note_actions: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_customer_lookup: Data: 0.18MB + Index: 0.13MB + Engine MyISAM
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
    wp_wc_order_product_lookup: Data: 0.16MB + Index: 0.13MB + Engine MyISAM
    wp_wc_order_stats: Data: 0.13MB + Index: 0.07MB + Engine MyISAM
    wp_wc_order_tax_lookup: Data: 0.06MB + Index: 0.07MB + Engine MyISAM
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    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_wfblockediplog: Data: 0.05MB + Index: 0.04MB + Engine MyISAM
    wp_wfblocks7: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wfconfig: Data: 3.29MB + Index: 0.01MB + Engine MyISAM
    wp_wfcrawlers: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wffilemods: Data: 5.28MB + Index: 0.63MB + Engine MyISAM
    wp_wfhits: Data: 0.51MB + Index: 0.13MB + Engine MyISAM
    wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfissues: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wp_wfknownfilelist: Data: 3.83MB + Index: 0.19MB + Engine MyISAM
    wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wflogins: Data: 0.31MB + Index: 0.07MB + Engine MyISAM
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfnotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfstatus: Data: 0.12MB + Index: 0.06MB + Engine MyISAM
    wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpgmza: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_circles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_maps: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_nominatim_geocode_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpgmza_polygon: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_polylines: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_rectangles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpmailsmtp_debug_events: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_emails_log: Data: 0.17MB + Index: 0.03MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yith_wcwl_lists: Data: 0.01MB + Index: 0.04MB + Engine MyISAM
    wp_yoast_indexable: Data: 0.05MB + Index: 0.03MB + Engine MyISAM
    wp_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_yoast_primary_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yoast_seo_links: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_yoast_seo_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    
    Post Type Counts
    
    amn_mi-lite: 1
    attachment: 129
    cookielawinfo: 6
    custom_css: 3
    customize_changeset: 5
    elementor_library: 2
    faq: 11
    flamingo_contact: 69
    flamingo_inbound: 101
    jetpack_migration: 2
    mc4wp-form: 2
    nav_menu_item: 44
    oembed_cache: 4
    optionsframework: 4
    page: 17
    portfolio: 9
    post: 7
    product: 18
    product_variation: 46
    revision: 118
    shop_coupon: 17
    shop_options: 1
    shop_order: 1411
    shop_order_refund: 16
    slider: 1
    wpcf7_contact_form: 2
    
    Security
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    Active Plugins (26)
    
    Akismet Anti-Spam Spam Protection: by Automattic - Anti Spam Team – 5.1
    Banner Management For WooCommerce: by theDotstore – 2.4.0
    Call Now Button: by NowButtons.com – 1.4.0
    Classic Editor: by WordPress Contributors – 1.6.3
    Classic Widgets: by WordPress Contributors – 0.3
    Contact Form 7: by Takayuki Miyoshi – 5.7.6
    CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.9
    Customer Reviews for WooCommerce: by CusRev – 5.27.0
    GTM4WP: by Thomas Geiger – 1.16.2
    Elementor: by Elementor.com – 3.13.3
    Essential Addons for Elementor: by WPDeveloper – 5.7.3
    Flamingo: by Takayuki Miyoshi – 2.4
    MC4WP: Mailchimp for WordPress: by ibericode – 4.9.4
    Nginx Helper: by rtCamp – 2.2.3
    Redirection: by John Godley – 5.3.10
    Simple Social Icons: by StudioPress – 3.1.1
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 2.23.4.26
    
    WooCommerce Payfast Gateway: by WooCommerce – 1.5.2 (update to version 1.5.3 is available)
    Discounts Per Payment Method on WooCommerce: by Claudio Sanches – 3.1.0
    WooCommerce Shipment Tracking: by WooCommerce – 2.3.1
    WooCommerce: by Automattic – 7.7.0 (update to version 7.7.2 is available)
    Wordfence Security: by Wordfence – 7.9.2
    Yoast SEO: by Team Yoast – 20.8
    WP Crontrol: by John Blackbourn & crontributors – 1.15.2
    WP Mail SMTP Pro: by WP Mail SMTP – 3.8.0
    WPForms Lite: by WPForms – 1.8.1.3
    
    Inactive Plugins (2)
    
    Simple Banner: by Ryan Petersen – 2.15.1
    WP Mail SMTP: by WP Mail SMTP – 3.8.0
    
    Settings
    
    API Enabled: ?
    Force SSL: –
    Currency: ZAR (R)
    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: –
    HPOS feature screen enabled: –
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: –
    
    WC Pages
    
    Shop base: #1914 - /shop/
    Basket: #1915 - /cart/
    Checkout: #1916 - /checkout/
    My account: #1917 - /my-account/
    Terms and conditions: #1983 - /terms-conditions/
    
    Theme
    
    Name: Astra
    Version: 4.1.5
    Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
    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: –
    
    Admin
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-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
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: product-block-editor
    minified-js
    new-product-management-experience
    product-variation-management
    settings
    
    Daily Cron: ? Next scheduled: 2023-06-13 06:49:18 +02:00
    Options: ?
    Notes: 158
    Onboarding: completed
    
    Action Scheduler
    
    Complete: 501
    Oldest: 2023-05-13 11:42:28 +0200
    Newest: 2023-06-13 08:10:22 +0200
    
    Failed: 2
    Oldest: 2023-04-05 07:25:41 +0200
    Newest: 2023-05-24 06:52:53 +0200
    
    Pending: 6
    Oldest: 2023-06-13 10:10:40 +0200
    Newest: 2023-06-19 20:44:42 +0200
    
    Status report information
    
    Generated at: 2023-06-13 08:15:04 +02:00
    `

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter atsiteros

    (@atsiteros)

    Hi there, just following up on my ticket. I have not received a reply yet, and still experiencing the problem. It is not a plugin problem, as I have a test site with exactly the same plugins and themes, but different hosting, and it works there? Please see attached logs sent and assist?

    Thank you

    Saif

    (@babylon1999)

    Hello @atsiteros,

    Sorry for the late reply!

    I can reproduce the problem in PHP 8.2, but only when the Query Monitor plugin is active. Therefore, I believe there may be a conflict with one of your plugins as well.


    Link to image: https://d.pr/i/aPi7PM

    You can try downgrading to PHP 8.0 or 8.1. If that doesn’t help, please try disabling all plugins and switching to the Storefront to determine which plugin is causing the issue. ??

    Let us know how it goes!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WooCommerce Analytics – Error getting Stats. Please try again later.’ is closed to new replies.