wp_wc_order_stats’ doesn’t exist for query SELECT COUNT
-
Fresh installation of WordPress and WooCommerce + WPML made yesterday. Did a Dashboard re-installation as I had
[02-Jul-2019 04:03:40 UTC] PHP Warning: Invalid argument supplied for foreach() in /home/user/domains/domain.com/public_html/staging/wp-admin/includes/ajax-actions.php on line 3299
and that issue seems to have been WordPress repo related so fine now. Site is working well too. I can check the orders page which has no orders as this was just set up but no issue. I do get this error however:
[02-Jul-2019 08:04:42 UTC] WordPress database error Table '1111.wp_wc_order_stats' doesn't exist for query SELECT COUNT(*) FROM ( SELECT wp_wc_order_stats.order_id FROM wp_wc_order_stats WHERE1=1 AND wp_wc_order_stats.date_created <= '2019-07-02 08:04:42' AND wp_wc_order_stats.date_created >= '2019-06-25 08:04:42' AND (wp_wc_order_stats.status IN ( 'wc-processing','wc-on-hold' )) ) AS tt made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WC_Admin_REST_Reports_Orders_Controller->get_items, WC_Admin_Reports_Orders_Query->get_data, WC_Data_Store->__call, WC_Admin_Reports_Orders_Data_Store->get_data
And yes, this table does not exist. Any ideas what is going on here? Why didn’t it get created and how should I deal with this? When I checked https://github.com/woocommerce/woocommerce/wiki/Database-Description it seems this table is not needed / standard..
Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
- The topic ‘wp_wc_order_stats’ doesn’t exist for query SELECT COUNT’ is closed to new replies.