Taxes by Date report critical error
-
When I go to the tab under Reports > Taxes> by Date tab it shows “There has been a critical error on this website.” instead of the report.
All my plugins and the core WordPress are up to date. The new Analytics reports for Taxes is not sufficient for the report that we need each month, because it does not include the order total.
The page I need help with: [log in to see the link]
-
It sounds like a potential conflict or issue with your WooCommerce setup is causing the critical error in the Tax Reports section. Here’s how you can troubleshoot and resolve it:
1. Enable WordPress Debugging:- To get more insight into the error, you can enable debugging in WordPress.
- Open your
wp-config.php
file and add the following lines
define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );
define( 'WP_DEBUG_DISPLAY', false );After reproducing the error, check the log file at
/wp-content/debug.log
to find any specific error message related to the issue. This can help narrow down the cause (plugin conflict, PHP memory issue, etc.).2. Check for Plugin Conflicts:
- Even though everything is up to date, there may still be a conflict between plugins.
- Temporarily disable all plugins except WooCommerce and switch to a default WordPress theme like Twenty Twenty-Three.
- If the report works without the error, re-enable plugins one by one to identify the conflicting plugin.
Thanks
Ahir HemantHi @amberwellhealth,
Did you already have a chance to try out the suggested steps by community member @hemant-ahir? If not, could you please try them out and let us know your findings?
Looking forward to hearing back from you.
I turned off all plugins except the core WooCommerce and WooCommerce Shipping and Tax. Here is the debug log, although I replaced our root url with XXXXXXX:
[24-Oct-2024 14:07:33 UTC] PHP Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in XXXXXXX/wp-includes/kses.php on line 1805
[24-Oct-2024 14:07:33 UTC] PHP Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in XXXXXXX/wp-includes/kses.php on line 1805
[24-Oct-2024 14:07:33 UTC] PHP Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in XXXXXXX/wp-includes/kses.php on line 1805
[24-Oct-2024 14:07:33 UTC] PHP Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in XXXXXXX/wp-includes/kses.php on line 1805
[24-Oct-2024 14:07:33 UTC] PHP Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in XXXXXXX/wp-includes/kses.php on line 1805
[24-Oct-2024 14:07:33 UTC] PHP Deprecated: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in XXXXXXX/wp-includes/kses.php on line 1805
[24-Oct-2024 14:07:34 UTC] PHP Warning: Undefined array key 20240924 in XXXXXXX/wp-content/plugins/woocommerce/includes/admin/reports/class-wc-report-taxes-by-date.php on line 183
[24-Oct-2024 14:07:34 UTC] PHP Fatal error: Uncaught Error: Attempt to assign property “tax_amount” on null in XXXXXXX/wp-content/plugins/woocommerce/includes/admin/reports/class-wc-report-taxes-by-date.php:183
Stack trace:0 XXXXXXX/wp-content/plugins/woocommerce/includes/admin/views/html-report-by-date.php(96): WC_Report_Taxes_By_Date->get_main_chart()
1 XXXXXXX/wp-content/plugins/woocommerce/includes/admin/reports/class-wc-report-taxes-by-date.php(66): include(‘/home/amberwell…’)
2 XXXXXXX/wp-content/plugins/woocommerce/includes/admin/class-wc-admin-reports.php(177): WC_Report_Taxes_By_Date->output_report()
3 XXXXXXX/wp-content/plugins/woocommerce/includes/admin/views/html-admin-page-reports.php(81): WC_Admin_Reports::get_report(‘taxes-by-date’)
4 XXXXXXX/wp-content/plugins/woocommerce/includes/admin/class-wc-admin-reports.php(36): include_once(‘/home/amberwell…’)
5 XXXXXXX/wp-content/plugins/woocommerce/includes/admin/class-wc-admin-menus.php(343): WC_Admin_Reports::output()
6 XXXXXXX/wp-includes/class-wp-hook.php(324): WC_Admin_Menus->reports_page(”)
7 XXXXXXX/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(”, Array)
8 XXXXXXX/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
9 XXXXXXX/wp-admin/admin.php(259): do_action(‘woocommerce_pag…’)
10 {main} thrown in XXXXXXX/wp-content/plugins/woocommerce/includes/admin/reports/class-wc-report-taxes-by-date.php on line 183
Hi @amberwellhealth,
Looking at your debug log, it appears that there are two issues: a deprecated PHP function and an undefined array key. Just curious, could you have modified your core WooCommerce files?
By modifying, I mean adding custom code and functions to the WooCommerce core plugin?
No, no modifications have been made. This is a very straightforward ecommerce site.
Thanks for the update @amberwellhealth.
I’d like to have a better understanding of how your site is set up. Please share with us your System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
WordPress Environment<br><br><br>WC Version: 9.3.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.8.1<br>Log Directory Writable: ?<br>WP Version: 6.6.2<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: ?<br>WP Cron: ?<br>Language: en_US<br>External object cache: – Server Environment<br><br>Server Info: LiteSpeed<br>PHP Version: 8.1.30<br>PHP Post Max Size: 32 MB<br>PHP Time Limit: 60<br>PHP Max Input Vars: 1000<br>cURL Version: 7.61.1<br>OpenSSL/1.1.1k<br><br>SUHOSIN Installed: –<br>MySQL Version: 8.0.40<br>Max Upload Size: 32 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database<br><br>WC Database Version: 9.3.3<br>WC Database Prefix: wp_<br>Total Database Size: 125.45MB<br>Database Data Size: 95.07MB<br>Database Index Size: 30.38MB<br>wp_woocommerce_sessions: Data: 0.10MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_downloadable_product_permissions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_order_items: Data: 1.17MB + Index: 0.51MB + Engine MyISAM<br>wp_woocommerce_order_itemmeta: Data: 11.34MB + Index: 4.57MB + Engine MyISAM<br>wp_woocommerce_tax_rates: Data: 0.05MB + Index: 0.04MB + Engine MyISAM<br>wp_woocommerce_tax_rate_locations: Data: 0.06MB + Index: 0.07MB + Engine MyISAM<br>wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_payment_tokens: Data: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM<br>wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_acfw_gift_cards: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_acfw_store_credits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_actionscheduler_actions: Data: 0.55MB + Index: 0.24MB + Engine MyISAM<br>wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_actionscheduler_logs: Data: 0.37MB + Index: 0.26MB + Engine MyISAM<br>wp_berocket_termmeta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_bp_activity: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_bp_activity_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_bp_invitations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_bp_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_bp_notifications_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_bp_xprofile_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_bp_xprofile_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_bp_xprofile_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_bp_xprofile_meta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_commentmeta: Data: 0.05MB + Index: 0.04MB + Engine MyISAM<br>wp_comments: Data: 4.99MB + Index: 1.57MB + Engine MyISAM<br>wp_e_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_e_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_e_notes_users_relations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_e_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_e_submissions_actions_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_e_submissions_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_draft_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_entry: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_entry_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_entry_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_form_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_form_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_form_view: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_gf_rest_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_jetpack_sync_queue: Data: 0.55MB + Index: 0.07MB + Engine MyISAM<br>wp_learndash_pro_quiz_category: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_learndash_pro_quiz_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_learndash_pro_quiz_lock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_learndash_pro_quiz_master: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_learndash_pro_quiz_prerequisite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_learndash_pro_quiz_question: Data: 0.07MB + Index: 0.00MB + Engine MyISAM<br>wp_learndash_pro_quiz_statistic: Data: 0.25MB + Index: 0.04MB + Engine MyISAM<br>wp_learndash_pro_quiz_statistic_ref: Data: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wp_learndash_pro_quiz_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_learndash_pro_quiz_toplist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_learndash_user_activity: Data: 0.01MB + Index: 0.03MB + Engine MyISAM<br>wp_learndash_user_activity_meta: Data: 0.14MB + Index: 0.14MB + Engine MyISAM<br>wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_litespeed_avatar: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_litespeed_img_optming: Data: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wp_litespeed_url: Data: 0.03MB + Index: 0.04MB + Engine MyISAM<br>wp_litespeed_url_file: Data: 0.04MB + Index: 0.05MB + Engine MyISAM<br>wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_options: Data: 6.56MB + Index: 0.18MB + Engine MyISAM<br>wp_partial_shipment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_partial_shipment_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_postmeta: Data: 37.18MB + Index: 15.11MB + Engine MyISAM<br>wp_posts: Data: 4.12MB + Index: 1.23MB + Engine MyISAM<br>wp_redirection_404: Data: 0.26MB + Index: 0.09MB + Engine MyISAM<br>wp_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_redirection_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_redirection_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_signups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_term_relationships: Data: 0.20MB + Index: 0.37MB + Engine MyISAM<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.02MB + Engine MyISAM<br>wp_termmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM<br>wp_terms: Data: 0.02MB + Index: 0.04MB + Engine MyISAM<br>wp_usermeta: Data: 4.82MB + Index: 1.92MB + Engine MyISAM<br>wp_users: Data: 0.19MB + Index: 0.15MB + Engine MyISAM<br>wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_admin_notes: Data: 0.09MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_category_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_customer_lookup: Data: 0.14MB + Index: 0.10MB + Engine MyISAM<br>wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_order_addresses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_order_bundle_lookup: Data: 0.11MB + Index: 0.15MB + Engine MyISAM<br>wp_wc_order_coupon_lookup: Data: 0.09MB + Index: 0.15MB + Engine MyISAM<br>wp_wc_order_operational_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_order_product_lookup: Data: 0.85MB + Index: 0.73MB + Engine MyISAM<br>wp_wc_order_stats: Data: 0.35MB + Index: 0.23MB + Engine MyISAM<br>wp_wc_order_tax_lookup: Data: 0.04MB + Index: 0.05MB + Engine MyISAM<br>wp_wc_product_attributes_lookup: Data: 0.13MB + Index: 0.12MB + Engine MyISAM<br>wp_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_product_meta_lookup: Data: 0.57MB + Index: 0.54MB + Engine MyISAM<br>wp_wc_rate_limits: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wcpv_commissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wcpv_per_product_shipping_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM<br>wp_woocommerce_bundled_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_exported_csv_items: Data: 0.57MB + Index: 0.01MB + Engine MyISAM<br>wp_wpf_filters: Data: 0.03MB + Index: 0.00MB + Engine MyISAM<br>wp_wpf_meta_data: Data: 0.71MB + Index: 1.14MB + Engine MyISAM<br>wp_wpf_meta_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wpf_meta_values: Data: 0.02MB + Index: 0.04MB + Engine MyISAM<br>wp_wpf_meta_values_bk: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpf_modules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpf_modules_type: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpf_statistics: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpf_statistics_det: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpf_statistics_sum: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpf_statistics_val: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpf_usage_stat: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_emails_log: Data: 10.52MB + Index: 0.08MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpml_mails: Data: 7.52MB + Index: 0.02MB + Engine InnoDB<br>wp_wt_iew_action_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wt_iew_cron: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wt_iew_ftp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM Post Type Counts<br><br>acf-field: 15<br>acf-field-group: 2<br>acf-taxonomy: 1<br>attachment: 2800<br>bp-email: 15<br>br_product_filter: 1<br>custom_css: 1<br>elementor_library: 16<br>gift_card: 522<br>nav_menu_item: 97<br>page: 16<br>post: 5<br>product: 669<br>product_variation: 2277<br>revision: 2343<br>sfwd-question: 26<br>sfwd-quiz: 2<br>shop_coupon: 760<br>shop_order: 4934<br>shop_order_refund: 243 Security<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (2)<br><br>WooCommerce Shipping & Tax: by WooCommerce – 2.8.2<br>WooCommerce: by Automattic – 9.3.3 Inactive Plugins (41)<br><br>Addify - Advanced Product Quantity: by Addify – 1.4.5<br>Advanced Order Export For WooCommerce: by AlgolPlus – 3.5.5<br>Better Search Replace: by WP Engine – 1.4.7<br>Classic Editor: by WordPress Contributors – 1.6.5<br>Code Snippets: by Code Snippets Pro – 3.6.5.1<br>Elementor: by Elementor.com – 3.24.7<br>Elementor Pro: by Elementor.com – 3.24.4<br>Gravity Forms: by Gravity Forms – 2.8.18<br>Hide Categories Or Products On Shop Page: by wordpplugin – 1.0.6<br>Import Export WordPress Users and WooCommerce Customers: by WebToffee – 2.5.7<br>LiteSpeed Cache: by LiteSpeed Technologies – 6.5.2<br>ManageWP - Worker: by GoDaddy – 4.9.20<br>Max Mega Menu: by megamenu.com – 3.3.2<br>PDF Embedder: by PDF Embedder – 4.8.2<br>Printful Integration for WooCommerce: by Printful – 2.2.10<br>Printify Shipping Method: by Printify – 3.0<br>Product Filter by WBW: by woobewoo – 2.7.2<br>Redirection: by John Godley – 5.5.0<br>Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6<br>Secure Custom Fields: by www.ads-software.com – 6.3.9<br>Show Stock Status for WooCommerce: by Bright Plugins – 1.0.5<br>Smart Image Resize PRO: by Nabil Lemsieh – 1.9.4<br>Smush: by WPMU DEV – 3.16.6<br>User Switching: by John Blackbourn – 1.8.0<br>WBW Product Filter PRO: by WBW – 2.7.2<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>WooCommerce Checkout Field Editor: by WooCommerce – 1.7.18<br>WooCommerce Coupon Generator: by Jeroen Sormani – 1.2.0<br>WooCommerce Customer/Order/Coupon Export: by SkyVerge – 5.5.3<br>Woocommerce Partial Shipment: by WpExperts Hub – 3.2<br>WooCommerce PayPal Payments: by WooCommerce – 2.9.3<br>WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.13.6<br>WooCommerce Product Bundles: by Woo – 8.1.2<br>Woo Conditional Shipping and Payments: by Woo – 2.0.3<br>WooPayments: by WooCommerce – 8.4.0<br>WP Mail Logging: by WP Mail Logging Team – 1.13.1<br>WP Mail SMTP: by WP Mail SMTP – 4.1.1<br>WP Mail SMTP Pro: by WP Mail SMTP – 4.1.1<br>WPO365 | LOGIN: by marco@wpo365.com – 33.1<br>WPO365 | LOGIN PLUS: by marco@wpo365.com – 33.0<br>YITH WooCommerce Gift Cards Premium: by YITH – 4.18.0 Settings<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: advanced_gift_card (advanced_gift_card)<br>bundle (bundle)<br>external (external)<br>gift-card (gift-card)<br>grouped (grouped)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: ?<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 6 MB WC Pages<br><br>Shop base: #6 - /<br>Cart: #7 - /cart/ - Contains the [woocommerce_cart] shortcode<br>Checkout: #8 - /checkout/ - Contains the [woocommerce_checkout] shortcode<br>My account: #9 - /my-account/<br>Terms and conditions: ? Page not set Theme<br><br>Name: Hello Elementor<br>Version: 3.1.1<br>Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash<br>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<br>WooCommerce Support: ? Templates<br><br>Overrides: – Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>blueprint<br>reactify-classic-payments-settings<br><br>Daily Cron: ? Next scheduled: 2024-10-26 16:43:42 -05:00<br>Options: ?<br>Notes: 219<br>Onboarding: completed Action Scheduler<br><br>Complete: 1,661<br>Oldest: 2024-09-25 02:05:14 -0500<br>Newest: 2024-10-25 16:09:52 -0500<br><br>Pending: 6<br>Oldest: 2024-10-25 16:10:47 -0500<br>Newest: 2024-10-25 22:32:51 -0500<br><br>Failed: 80<br>Oldest: 2023-02-14 23:30:37 -0600<br>Newest: 2024-06-11 12:29:07 -0500<br><br>Canceled: 17<br>Oldest: 2024-09-26 09:11:59 -0500<br>Newest: 2024-10-18 11:12:14 -0500 Status report information<br><br>Generated at: 2024-10-25 16:10:39 -05:00<br>
Thanks for sending us the status report of your site @amberwellhealth!
I tested on my site but couldn’t replicate the issue. After checking the status report of your site, it appears your PHP version is outdated. As a next step, I strongly recommend updating the PHP version to the latest version and see if the issue is resolved: PHP Version: 8.1.30 –> 8.3.13
I suggest completing this step on a staging site or creating a backup of your site before proceeding. You can clone your site to a staging environment and perform tests without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.
I have updated our PHP version to 8.3.12 and the error persists.
Hey @amberwellhealth ,
I understand that you’ve already disabled all plugins except for WooCommerce and WooCommerce Shipping and Tax, however it’s possible that there may be a theme conflict happening here.
Since the PHP version has been updated, can you try running through a full conflict test and see if this resolves the issue? This involves temporarily switching to a default theme, like Storefront, and disabling all plugins except for WooCommerce and WooCommerce Shipping and Tax.
You can read more on how to test for conflicts here: https://woocommerce.com/document/how-to-test-for-conflicts/
We recommend using the free?Health Check?plugin which allows you to change the theme while still logged in, without affecting normal visitors to your site or making direct changes to your live site.
If that makes no difference, a fresh install may be helpful here. Can you try deleting WooCommerce,?downloading a fresh copy here, and then installing that to see if it makes any difference?
We always recommend ensuring that you have a good?backup?of your?full site and database?before doing this, so that, should something go wrong, you are able to easily restore your site to a functioning state.
Just to add – deleting the WooCommerce plugin will not affect your WooCommerce data in any way, all orders, customers, etc will still be there once WooCommerce has been reinstalled.
Please let us know how this goes!
I am now using the Storefront theme, I deleted and reinstalled Woocommerce, and also added Health Check. None of the recommendations there seem to be pertinent to this issue. The report still causes the critical error.
Here is the information from the Health Check
` wp-core
version: 6.6.2
site_language: en_US
user_language: en_US
timezone: America/Chicago
permalink: /%category%/%postname%/
https_status: true
multisite: false
user_registration: 1
blog_public: 0
default_comment_status: open
environment_type: production
user_count: 1608
dotorg_communication: true wp-paths-sizes
wordpress_path: XXXX
wordpress_size: 1.98 GB (2121513167 bytes)
uploads_path: /wp-content/uploads
uploads_size: 3.63 GB (3893621300 bytes)
themes_path: /wp-content/themes
themes_size: 29.38 MB (30806007 bytes)
plugins_path: /wp-content/plugins
plugins_size: 248.19 MB (260246851 bytes)
fonts_path: /wp-content/uploads/fonts
fonts_size: directory not found
database_size: 124.27 MB (130306596 bytes)
total_size: 5.99 GB (6436493921 bytes) wp-active-theme
name: Storefront (storefront)
version: 4.6.0
author: Automattic
author_website: https://woocommerce.com/
parent_theme: none
theme_features: core-block-patterns, widgets-block-editor, post-thumbnails, automatic-feed-links, custom-logo, menus, html5, custom-background, custom-header, title-tag, customize-selective-refresh-widgets, wp-block-styles, align-wide, editor-styles, editor-font-sizes, editor-style, responsive-embeds, appearance-tools, amp, woocommerce, wc-product-gallery-zoom, wc-product-gallery-lightbox, wc-product-gallery-slider, starter-content, widgets
theme_path: /wp-content/themes/storefront
auto_update: Disabled wp-themes-inactive (9)
Hello Elementor: version: 3.1.1, author: Elementor Team, Auto-updates disabled
Twenty Nineteen: version: 2.9, author: the WordPress team, Auto-updates disabled
Twenty Seventeen: version: 3.7, author: the WordPress team, Auto-updates disabled
Twenty Sixteen: version: 3.3, author: the WordPress team, Auto-updates disabled
Twenty Twenty: version: 2.7, author: the WordPress team, Auto-updates disabled
Twenty Twenty-Four: version: 1.2, author: the WordPress team, Auto-updates disabled
Twenty Twenty-One: version: 2.3, author: the WordPress team, Auto-updates disabled
Twenty Twenty-Three: version: 1.5, author: the WordPress team, Auto-updates disabled
Twenty Twenty-Two: version: 1.8, author: the WordPress team, Auto-updates disabled wp-mu-plugins (1)
Health Check Troubleshooting Mode: author: (undefined), version: 1.9.2 wp-plugins-active (2)
Health Check & Troubleshooting: version: 1.7.1, author: The www.ads-software.com community, Auto-updates disabled
WooCommerce: version: 9.3.3, author: Automattic, Auto-updates enabled wp-plugins-inactive (34)
Addify - Advanced Product Quantity: version: 1.4.5, author: Addify, Auto-updates enabled
Advanced Order Export For WooCommerce: version: 3.5.5, author: AlgolPlus, Auto-updates enabled
Better Search Replace: version: 1.4.7, author: WP Engine, Auto-updates enabled
Classic Editor: version: 1.6.5, author: WordPress Contributors, Auto-updates enabled
Code Snippets: version: 3.6.5.1, author: Code Snippets Pro, Auto-updates enabled
Elementor: version: 3.25.1, author: Elementor.com (latest version: 3.25.2), Auto-updates enabled
Elementor Pro: version: 3.24.4, author: Elementor.com, Auto-updates enabled
Gravity Forms: version: 2.8.18, author: Gravity Forms, Auto-updates enabled
Hide Categories Or Products On Shop Page: version: 1.0.6, author: wordpplugin, Auto-updates enabled
Import Export WordPress Users and WooCommerce Customers: version: 2.5.8, author: WebToffee, Auto-updates enabled
LiteSpeed Cache: version: 6.5.2, author: LiteSpeed Technologies, Auto-updates enabled
ManageWP - Worker: version: 4.9.20, author: GoDaddy, Auto-updates enabled
Max Mega Menu: version: 3.3.2, author: megamenu.com, Auto-updates enabled
PDF Embedder: version: 4.8.2, author: PDF Embedder, Auto-updates enabled
Printful Integration for WooCommerce: version: 2.2.10, author: Printful, Auto-updates enabled
Printify Shipping Method: version: 3.0, author: Printify, Auto-updates enabled
Redirection: version: 5.5.0, author: John Godley, Auto-updates enabled
Regenerate Thumbnails: version: 3.1.6, author: Alex Mills (Viper007Bond), Auto-updates enabled
Secure Custom Fields: version: 6.3.9, author: www.ads-software.com, Auto-updates enabled
Smart Image Resize PRO: version: 1.9.4, author: Nabil Lemsieh, Auto-updates enabled
Smush: version: 3.16.6, author: WPMU DEV, Auto-updates enabled
User Switching: version: 1.8.0, author: John Blackbourn, Auto-updates enabled
WBW Product Filter PRO: version: 2.7.2, author: WBW, Auto-updates disabled
WooCommerce.com Update Manager: version: 1.0.3, author: Automattic, Auto-updates disabled
WooCommerce Checkout Field Editor: version: 1.7.18, author: WooCommerce, Auto-updates enabled
WooCommerce Coupon Generator: version: 1.2.0, author: Jeroen Sormani, Auto-updates enabled
WooCommerce Customer/Order/Coupon Export: version: 5.5.3, author: SkyVerge, Auto-updates enabled
WooCommerce Print Invoices/Packing Lists: version: 3.13.6, author: SkyVerge, Auto-updates enabled
WP Mail Logging: version: 1.13.1, author: WP Mail Logging Team, Auto-updates disabled
WP Mail SMTP: version: 4.1.1, author: WP Mail SMTP, Auto-updates enabled
WP Mail SMTP Pro: version: 4.1.1, author: WP Mail SMTP, Auto-updates enabled
WPO365 | LOGIN: version: 33.1, author: marco@wpo365.com, Auto-updates enabled
WPO365 | LOGIN PLUS: version: 33.0, author: marco@wpo365.com, Auto-updates enabled
YITH WooCommerce Gift Cards Premium: version: 4.18.0, author: YITH, Auto-updates enabled wp-media
image_editor: WP_Image_Editor_GD
imagick_module_version: Not available
imagemagick_version: Not available
imagick_version: Not available
file_uploads: 1
post_max_size: 32M
upload_max_filesize: 32M
max_effective_size: 32 MB
max_file_uploads: 20
gd_version: bundled (2.1.0 compatible)
gd_formats: GIF, JPEG, PNG, WebP, BMP, AVIF, XPM
ghostscript_version: 9.27 wp-server
server_architecture: Linux 3.10.0 x86_64
httpd_software: LiteSpeed
php_version: 8.3.12 64bit
php_sapi: litespeed
max_input_variables: 1000
time_limit: 60
memory_limit: 512M
max_input_time: 60
upload_max_filesize: 32M
php_post_max_size: 32M
curl_version: 7.61.1 OpenSSL/1.1.1k
suhosin: false
imagick_availability: false
pretty_permalinks: true
htaccess_extra_rules: true
current: 2024-10-29T21:55:56+00:00
utc-time: Tuesday, 29-Oct-24 21:55:56 UTC
server-time: 2024-10-29T16:55:56-05:00 wp-database
extension: mysqli
server_version: 8.0.40
client_version: mysqlnd 8.3.12
max_allowed_packet: 268435456
max_connections: 100 wp-constants
WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /wp-content
WP_PLUGIN_DIR: /wp-content/plugins
WP_MEMORY_LIMIT: 40M
WP_MAX_MEMORY_LIMIT: 512M
WP_DEBUG: true
WP_DEBUG_DISPLAY: false
WP_DEBUG_LOG: true
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Undefined
WP_DEVELOPMENT_MODE: undefined
DB_CHARSET: utf8mb4
DB_COLLATE: undefined wp-filesystem
wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
fonts: not writable
mu-plugins: writableHi @amberwellhealth,
Sorry to hear you struggle with the error. However, I’d like to note, that the reports were deprecated long ago, and the amount of support and improvements there may be limited.
I was not able to reproduce it on my test environment. But looking, at the code, I was able to mimic the same error by corrupting/erasing the
post_date
of one of the orders. It’s worth double-checking if there is not other plugin, or code fiddling with that, or one of the hooks (woocommerce_reports_get_order_report_data
,woocommerce_reports_get_order_report_query
,woocommerce_reports_get_order_report_data_args
).
To help us debug it further, could you try to narrow down the range of orders , by filtering a single date that produces this error? Like:/wp-admin/admin.php?page=wc-reports&tab=taxes&report=taxes_by_date&range=custom&start_date=2024-10-30&end_date=2024-10-31
. Then, check those orders for something suspicious.Thank you for your reply. Based on what you were able to reproduce using the post date, I tested pulling the report on every single day. Finally I narrowed it down to one day on which an unusual order came in. Here is what happened, in case you can fix this:
On 9/25, a order came in that was 100% covered by gift cards generated from the store. The total due on the order was zero through use of the gift card payment. However, tax was still due on the item (as tax is not collected on the original gift card sale) and still calculated on the order, and hence created a negative amount of next profit. So, the code likely needs updated to allow the report to generate even if there is a negative total on a particular day.
For now, I was able to do a work around by excluding the negative day from the entire month report and doing 2 partial month reports and combining.
Hello amberwellhealth,
Thank you for your reply.
I am glad to know that you were able to find the root cause.
Please note that WooCommerce Reports have been deprecated since March 2020 and won’t receive further updates.I recommend you switch to the new Analytics and Sales Reports.
Please go through the guide for a detailed tour of features.Please don’t hesitate to contact us again if you have more questions or concerns.
We are here to help ??Best regards.
- You must be logged in to reply to this topic.