Too many errors – Abandoned

Too many errors during install and then while viewing reports. Please check and fix.

Can you also please make this less garish – the colour scheme is an eye-sore, sorry!

[15-Aug-2024 04:45:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'BillingCountry' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID WHERE it_posts.post_type	=	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'BillingCountry' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID WHERE it_posts.post_type	=	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'BillingCountry' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID WHERE it_posts.post_type	=	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'BillingCountry' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID WHERE it_posts.post_type	=	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'billing_state' ,it_postmeta3.meta_value AS 'billing_country' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta3 ON it_postmeta3.post_id=it_posts.ID WHERE it_posts.post_type =	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_state' AND it_postmeta3.meta_key	= '_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'billing_state' ,it_postmeta3.meta_value AS 'billing_country' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta3 ON it_postmeta3.post_id=it_posts.ID WHERE it_posts.post_type =	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_state' AND it_postmeta3.meta_key	= '_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'billing_state' ,it_postmeta3.meta_value AS 'billing_country' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta3 ON it_postmeta3.post_id=it_posts.ID WHERE it_posts.post_type =	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_state' AND it_postmeta3.meta_key	= '_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'billing_state' ,it_postmeta3.meta_value AS 'billing_country' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta3 ON it_postmeta3.post_id=it_posts.ID WHERE it_posts.post_type =	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_state' AND it_postmeta3.meta_key	= '_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:13 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'BillingCountry' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID WHERE it_posts.post_type	=	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:13 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'BillingCountry' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID WHERE it_posts.post_type	=	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:13 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'BillingCountry' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID WHERE it_posts.post_type	=	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:13 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'BillingCountry' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID WHERE it_posts.post_type	=	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:13 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'billing_state' ,it_postmeta3.meta_value AS 'billing_country' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta3 ON it_postmeta3.post_id=it_posts.ID WHERE it_posts.post_type =	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_state' AND it_postmeta3.meta_key	= '_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:13 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'billing_state' ,it_postmeta3.meta_value AS 'billing_country' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta3 ON it_postmeta3.post_id=it_posts.ID WHERE it_posts.post_type =	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_state' AND it_postmeta3.meta_key	= '_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:13 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'billing_state' ,it_postmeta3.meta_value AS 'billing_country' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta3 ON it_postmeta3.post_id=it_posts.ID WHERE it_posts.post_type =	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_state' AND it_postmeta3.meta_key	= '_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2023'-01-01' AND ''2023'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:45:13 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GRO...' at line 1 for query SELECT SUM(it_postmeta1.meta_value) AS 'Total' ,it_postmeta2.meta_value AS 'billing_state' ,it_postmeta3.meta_value AS 'billing_country' ,Count(*) AS 'OrderCount' FROM wp_posts as it_posts LEFT JOIN wp_postmeta as it_postmeta1 ON it_postmeta1.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta2 ON it_postmeta2.post_id=it_posts.ID LEFT JOIN wp_postmeta as it_postmeta3 ON it_postmeta3.post_id=it_posts.ID WHERE it_posts.post_type =	'shop_order' AND it_postmeta1.meta_key =	'_order_total' AND it_postmeta2.meta_key	=	'_billing_state' AND it_postmeta3.meta_key	= '_billing_country' AND it_posts.post_status IN ('wc-completed', 'wc-on-hold', 'wc-processing') AND DATE(it_posts.post_date) BETWEEN ''2024'-01-01' AND ''2024'-12-30' AND it_posts.post_status NOT IN ('trash') GROUP BY it_postmeta2.meta_value Order By Total DESC made by do_action('admin_page_wcx_wcreport_plugin_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, it_report_wcreport_class->wcx_plugin_dashboard, it_report_wcreport_class->pages_fetch, include('/plugins/ithemelandco-woo-report/class/pages_fetch_dashboards.php'), include('/plugins/ithemelandco-woo-report/class/dashboard_report.php')
[15-Aug-2024 04:48:08 UTC] PHP Warning:  Attempt to read property "display_name" on bool in [path]\wp-content\plugins\ithemelandco-woo-report\includes\fetch_data_details.php on line 2476
[15-Aug-2024 04:48:08 UTC] billing_country was called incorrectly. Order properties should not be accessed directly. Backtrace: do_action('wp_ajax_it_rpt_fetch_data'), WP_Hook->do_action, WP_Hook->apply_filters, it_rpt_fetch_data, it_rpt_datatable_generate->table_html, require('/plugins/ithemelandco-woo-report/includes/fetch_data_details.php'), WC_Abstract_Legacy_Order->__get, wc_doing_it_wrong. This message was added in version 3.0.
[15-Aug-2024 04:48:08 UTC] PHP Warning:  Undefined array key 16069 in [path]\wp-content\plugins\ithemelandco-woo-report\includes\fetch_data_details.php on line 2855
[15-Aug-2024 04:48:42 UTC] WordPress database error Unknown column '???' in 'order clause' for query SELECT 
		it_woocommerce_order_itemmeta_product.meta_value 			as id
		,it_woocommerce_order_items.order_item_name 				as product_name
		,it_woocommerce_order_items.order_item_name 				as item_name
		,it_woocommerce_order_items.order_item_id 					as order_item_id
		,it_woocommerce_order_itemmeta_product.meta_value 			as product_id
		,it_woocommerce_order_items.order_id						as order_id
		,SUM(it_woocommerce_order_itemmeta_product_total.meta_value) 	as total
		,SUM(it_woocommerce_order_itemmeta_product_qty.meta_value) 	as quantity

		,MONTH(shop_order.post_date) 					as month_number
		,DATE_FORMAT(shop_order.post_date, '%Y-%m')		as month_key
				FROM 
		wp_woocommerce_order_items 			as it_woocommerce_order_items
		LEFT JOIN  wp_woocommerce_order_itemmeta 	as it_woocommerce_order_itemmeta_product 			ON it_woocommerce_order_itemmeta_product.order_item_id=it_woocommerce_order_items.order_item_id
		LEFT JOIN  wp_posts 						as shop_order 									ON shop_order.id								=	it_woocommerce_order_items.order_id

		LEFT JOIN  wp_woocommerce_order_itemmeta 	as it_woocommerce_order_itemmeta_product_total 	ON it_woocommerce_order_itemmeta_product_total.order_item_id=it_woocommerce_order_items.order_item_id
		LEFT JOIN  wp_woocommerce_order_itemmeta 	as it_woocommerce_order_itemmeta_product_qty		ON it_woocommerce_order_itemmeta_product_qty.order_item_id		=	it_woocommerce_order_items.order_item_id  
				WHERE 
		it_woocommerce_order_itemmeta_product.meta_key		=	'_product_id'
		AND it_woocommerce_order_items.order_item_type		=	'line_item'
		AND shop_order.post_type						=	'shop_order'

		AND it_woocommerce_order_itemmeta_product_total.meta_key		='_line_total'
		AND it_woocommerce_order_itemmeta_product_qty.meta_key			=	'_qty'  AND DATE_FORMAT(shop_order.post_date, '%Y-%m-%d') BETWEEN ('2024-08-01') and ('2024-12-31')   
				   
				 
				group by it_woocommerce_order_itemmeta_product.meta_value ORDER BY -1 ASC made by do_action('wp_ajax_it_rpt_fetch_data'), WP_Hook->do_action, WP_Hook->apply_filters, it_rpt_fetch_data, it_rpt_datatable_generate->table_html, it_rpt_datatable_generate->fetch_sql