[05-Apr-2023 07:27:00 UTC] PHP Fatal error:  Uncaught ArgumentCountError: Too few arguments to function WPDesk\FS\TableRate\FreeShipping\FreeShippingNoticeGenerator::__construct(), 2 passed in /home2/projechr/public_html/website/themaskingshop/wp-content/plugins/flexible-shipping/classes/class-flexible-shipping-plugin.php on line 405 and exactly 3 expected in /home2/projechr/public_html/website/themaskingshop/wp-content/plugins/flexible-shipping/src/WPDesk/FS/TableRate/FreeShipping/FreeShippingNoticeGenerator.php:48
Stack trace:
#0 /home2/projechr/public_html/website/themaskingshop/wp-content/plugins/flexible-shipping/classes/class-flexible-shipping-plugin.php(405): WPDesk\FS\TableRate\FreeShipping\FreeShippingNoticeGenerator->__construct(Object(WC_Cart), Object(WC_Session_Handler))
#1 /home2/projechr/public_html/website/themaskingshop/wp-includes/class-wp-hook.php(308): Flexible_Shipping_Plugin->init_free_shipping_notice('')
#2 /home2/projechr/public_html/website/themaskingshop/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
#3  in /home2/projechr/public_html/website/themaskingshop/wp-content/plugins/flexible-shipping/src/WPDesk/FS/TableRate/FreeShipping/FreeShippingNoticeGenerator.php on line 48
[05-Apr-2023 09:24:10 UTC] WordPress database error Unknown column 'gross_total' in 'ms_wc_order_stats' for query ALTER TABLE ms_wc_order_stats CHANGE COLUMN `gross_total` `total_sales` double DEFAULT 0 NOT NULL made by do_action('wp_ajax_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array('woocommerce_run_update_callback'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::run_update_callback, wc_admin_update_0230_rename_gross_total
[05-Apr-2023 09:57:41 UTC] WordPress database error Unknown column 'ms_wc_order_stats.total_sales' in 'field list' for query 
			SELECT
				SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(ms_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(ms_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(ms_wc_order_stats.tax_total) - SUM(ms_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(ms_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(ms_wc_order_stats.tax_total) AS taxes, SUM(ms_wc_order_stats.shipping_total) AS shipping, SUM(ms_wc_order_stats.net_total) AS net_revenue, SUM( ms_wc_order_stats.num_items_sold ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( ms_wc_order_stats.net_total ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( ms_wc_order_stats.customer_id ) ) as total_customers
			FROM
				ms_wc_order_stats
				LEFT JOIN (
						SELECT
							order_id,
							SUM(discount_amount) AS discount_amount,
							COUNT(DISTINCT coupon_id) AS coupons_count
						FROM
							ms_wc_order_coupon_lookup
						GROUP BY
							order_id
						) order_coupon_lookup
						ON order_coupon_lookup.order_id = ms_wc_order_stats.order_id
			WHERE
				1=1
				AND ( ms_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND ms_wc_order_stats.`date_created` <= '2023-04-05 23:59:59' AND ms_wc_order_stats.`date_created` >= '2023-04-01 00:00:00'
		 made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Revenue\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Revenue\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data
[05-Apr-2023 09:57:41 UTC] WordPress database error Unknown column 'ms_wc_order_stats.total_sales' in 'field list' for query 
			SELECT
				DATE_FORMAT(ms_wc_order_stats.`date_created`, '%x-%v') AS time_interval , MAX(ms_wc_order_stats.date_created) AS datetime_anchor , SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(ms_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(ms_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(ms_wc_order_stats.tax_total) - SUM(ms_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(ms_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(ms_wc_order_stats.tax_total) AS taxes, SUM(ms_wc_order_stats.shipping_total) AS shipping, SUM(ms_wc_order_stats.net_total) AS net_revenue, SUM( ms_wc_order_stats.num_items_sold ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( ms_wc_order_stats.net_total ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( ms_wc_order_stats.customer_id ) ) as total_customers
			FROM
				ms_wc_order_stats
				LEFT JOIN (
						SELECT
							order_id,
							SUM(discount_amount) AS discount_amount,
							COUNT(DISTINCT coupon_id) AS coupons_count
						FROM
							ms_wc_order_coupon_lookup
						GROUP BY
							order_id
						) order_coupon_lookup
						ON order_coupon_lookup.order_id = ms_wc_order_stats.order_id
			WHERE
				1=1
				AND ( ms_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND ms_wc_order_stats.`date_created` <= '2023-04-05 23:59:59' AND ms_wc_order_stats.`date_created` >= '2023-04-01 00:00:00'
		
				GROUP BY
					time_interval
			
				ORDER BY
					time_interval desc
			LIMIT 0,10 made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Revenue\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Revenue\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data
[05-Apr-2023 09:57:41 UTC] WordPress database error Unknown column 'ms_wc_order_stats.total_sales' in 'field list' for query 
			SELECT
				SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(ms_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(ms_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(ms_wc_order_stats.tax_total) - SUM(ms_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(ms_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(ms_wc_order_stats.tax_total) AS taxes, SUM(ms_wc_order_stats.shipping_total) AS shipping, SUM(ms_wc_order_stats.net_total) AS net_revenue, SUM( ms_wc_order_stats.num_items_sold ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( ms_wc_order_stats.net_total ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( ms_wc_order_stats.customer_id ) ) as total_customers
			FROM
				ms_wc_order_stats
				LEFT JOIN (
						SELECT
							order_id,
							SUM(discount_amount) AS discount_amount,
							COUNT(DISTINCT coupon_id) AS coupons_count
						FROM
							ms_wc_order_coupon_lookup
						GROUP BY
							order_id
						) order_coupon_lookup
						ON order_coupon_lookup.order_id = ms_wc_order_stats.order_id
			WHERE
				1=1
				AND ( ms_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND ms_wc_order_stats.`date_created` <= '2023-04-05 23:59:59' AND ms_wc_order_stats.`date_created` >= '2023-04-01 00:00:00'
		 made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data
[05-Apr-2023 09:57:41 UTC] WordPress database error Unknown column 'ms_wc_order_stats.total_sales' in 'field list' for query 
			SELECT
				DATE_FORMAT(ms_wc_order_stats.`date_created`, '%x-%v') AS time_interval , MAX(ms_wc_order_stats.date_created) AS datetime_anchor , SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(ms_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(ms_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(ms_wc_order_stats.tax_total) - SUM(ms_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(ms_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(ms_wc_order_stats.tax_total) AS taxes, SUM(ms_wc_order_stats.shipping_total) AS shipping, SUM(ms_wc_order_stats.net_total) AS net_revenue, SUM( ms_wc_order_stats.num_items_sold ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( ms_wc_order_stats.net_total ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( ms_wc_order_stats.customer_id ) ) as total_customers
			FROM
				ms_wc_order_stats
				LEFT JOIN (
						SELECT
							order_id,
							SUM(discount_amount) AS discount_amount,
							COUNT(DISTINCT coupon_id) AS coupons_count
						FROM
							ms_wc_order_coupon_lookup
						GROUP BY
							order_id
						) order_coupon_lookup
						ON order_coupon_lookup.order_id = ms_wc_order_stats.order_id
			WHERE
				1=1
				AND ( ms_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND ms_wc_order_stats.`date_created` <= '2023-04-05 23:59:59' AND ms_wc_order_stats.`date_created` >= '2023-04-01 00:00:00'
		
				GROUP BY
					time_interval
			
				ORDER BY
					time_interval desc
			LIMIT 0,10 made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data
[06-Apr-2023 04:42:44 UTC] WordPress database error Unknown column 'ms_wc_order_stats.total_sales' in 'field list' for query 
			SELECT
				SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(ms_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(ms_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(ms_wc_order_stats.tax_total) - SUM(ms_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(ms_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(ms_wc_order_stats.tax_total) AS taxes, SUM(ms_wc_order_stats.shipping_total) AS shipping, SUM(ms_wc_order_stats.net_total) AS net_revenue, SUM( ms_wc_order_stats.num_items_sold ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( ms_wc_order_stats.net_total ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( ms_wc_order_stats.customer_id ) ) as total_customers
			FROM
				ms_wc_order_stats
				LEFT JOIN (
						SELECT
							order_id,
							SUM(discount_amount) AS discount_amount,
							COUNT(DISTINCT coupon_id) AS coupons_count
						FROM
							ms_wc_order_coupon_lookup
						GROUP BY
							order_id
						) order_coupon_lookup
						ON order_coupon_lookup.order_id = ms_wc_order_stats.order_id
			WHERE
				1=1
				AND ( ms_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND ms_wc_order_stats.`date_created` <= '2023-04-06 23:59:59' AND ms_wc_order_stats.`date_created` >= '2023-04-01 00:00:00'
		 made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Revenue\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Revenue\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data
[06-Apr-2023 04:42:44 UTC] WordPress database error Unknown column 'ms_wc_order_stats.total_sales' in 'field list' for query 
			SELECT
				DATE_FORMAT(ms_wc_order_stats.`date_created`, '%x-%v') AS time_interval , MAX(ms_wc_order_stats.date_created) AS datetime_anchor , SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(ms_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(ms_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(ms_wc_order_stats.tax_total) - SUM(ms_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(ms_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(ms_wc_order_stats.tax_total) AS taxes, SUM(ms_wc_order_stats.shipping_total) AS shipping, SUM(ms_wc_order_stats.net_total) AS net_revenue, SUM( ms_wc_order_stats.num_items_sold ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( ms_wc_order_stats.net_total ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( ms_wc_order_stats.customer_id ) ) as total_customers
			FROM
				ms_wc_order_stats
				LEFT JOIN (
						SELECT
							order_id,
							SUM(discount_amount) AS discount_amount,
							COUNT(DISTINCT coupon_id) AS coupons_count
						FROM
							ms_wc_order_coupon_lookup
						GROUP BY
							order_id
						) order_coupon_lookup
						ON order_coupon_lookup.order_id = ms_wc_order_stats.order_id
			WHERE
				1=1
				AND ( ms_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND ms_wc_order_stats.`date_created` <= '2023-04-06 23:59:59' AND ms_wc_order_stats.`date_created` >= '2023-04-01 00:00:00'
		
				GROUP BY
					time_interval
			
				ORDER BY
					time_interval desc
			LIMIT 0,10 made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Revenue\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Revenue\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data
[06-Apr-2023 04:42:44 UTC] WordPress database error Unknown column 'ms_wc_order_stats.total_sales' in 'field list' for query 
			SELECT
				SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(ms_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(ms_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(ms_wc_order_stats.tax_total) - SUM(ms_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(ms_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(ms_wc_order_stats.tax_total) AS taxes, SUM(ms_wc_order_stats.shipping_total) AS shipping, SUM(ms_wc_order_stats.net_total) AS net_revenue, SUM( ms_wc_order_stats.num_items_sold ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( ms_wc_order_stats.net_total ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( ms_wc_order_stats.customer_id ) ) as total_customers
			FROM
				ms_wc_order_stats
				LEFT JOIN (
						SELECT
							order_id,
							SUM(discount_amount) AS discount_amount,
							COUNT(DISTINCT coupon_id) AS coupons_count
						FROM
							ms_wc_order_coupon_lookup
						GROUP BY
							order_id
						) order_coupon_lookup
						ON order_coupon_lookup.order_id = ms_wc_order_stats.order_id
			WHERE
				1=1
				AND ( ms_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND ms_wc_order_stats.`date_created` <= '2023-04-06 23:59:59' AND ms_wc_order_stats.`date_created` >= '2023-04-01 00:00:00'
		 made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data
[06-Apr-2023 04:42:44 UTC] WordPress database error Unknown column 'ms_wc_order_stats.total_sales' in 'field list' for query 
			SELECT
				DATE_FORMAT(ms_wc_order_stats.`date_created`, '%x-%v') AS time_interval , MAX(ms_wc_order_stats.date_created) AS datetime_anchor , SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(ms_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(ms_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(ms_wc_order_stats.tax_total) - SUM(ms_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(ms_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN ms_wc_order_stats.net_total < 0 THEN ms_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(ms_wc_order_stats.tax_total) AS taxes, SUM(ms_wc_order_stats.shipping_total) AS shipping, SUM(ms_wc_order_stats.net_total) AS net_revenue, SUM( ms_wc_order_stats.num_items_sold ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( ms_wc_order_stats.net_total ) / SUM( CASE WHEN ms_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( ms_wc_order_stats.customer_id ) ) as total_customers
			FROM
				ms_wc_order_stats
				LEFT JOIN (
						SELECT
							order_id,
							SUM(discount_amount) AS discount_amount,
							COUNT(DISTINCT coupon_id) AS coupons_count
						FROM
							ms_wc_order_coupon_lookup
						GROUP BY
							order_id
						) order_coupon_lookup
						ON order_coupon_lookup.order_id = ms_wc_order_stats.order_id
			WHERE
				1=1
				AND ( ms_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND ms_wc_order_stats.`date_created` <= '2023-04-06 23:59:59' AND ms_wc_order_stats.`date_created` >= '2023-04-01 00:00:00'
		
				GROUP BY
					time_interval
			
				ORDER BY
					time_interval desc
			LIMIT 0,10 made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data
