I am having a new issue, when I enable the pro plugin I am unable to access my orders screen in the dashboard. It just sits loading.
I have disabled all plugins except WC and Multi Order for WooCommerce I am not getting debug info unless I stop mysql If I do then I get the following error…
[15-Aug-2018 01:39:42 UTC] PHP Warning: mysqli_query(): (08S01/1053): Server shutdown in progress in /var/www/html/wp-includes/wp-db.php on line 1924
[15-Aug-2018 01:39:42 UTC] WordPress database error Server shutdown in progress for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id AND mt1.meta_key = ‘_alg_mowc_is_suborder’ ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id AND mt3.meta_key = ‘_alg_mowc_sort_id’ ) WHERE 1=1 AND (
(
( wp_postmeta.meta_key = ‘_alg_mowc_is_suborder’ AND wp_postmeta.meta_value NOT IN (‘1′,’on’) )
OR
mt1.post_id IS NULL
)
AND
(
mt2.meta_key = ‘_alg_mowc_sort_id’
OR
mt3.post_id IS NULL
)
) AND wp_posts.post_type = ‘shop_order’ AND ((wp_posts.post_status = ‘wc-pending’ OR wp_posts.post_status = ‘wc-processing’ OR wp_posts.post_status = ‘wc-on-hold’ OR wp_posts.post_status = ‘wc-completed’ OR wp_posts.post_status = ‘wc-cancelled’ OR wp_posts.post_status = ‘wc-refunded’ OR wp_posts.post_status = ‘wc-failed’)) GROUP BY wp_posts.ID ORDER BY CAST(mt2.meta_value AS CHAR) DESC, CAST(mt3.meta_value AS CHAR) ASC LIMIT 0, 20 made by WP_Posts_List_Table->prepare_items, wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[15-Aug-2018 01:39:42 UTC] PHP Warning: Error while sending QUERY packet. PID=2826 in /var/www/html/wp-includes/wp-db.php on line 1924
[15-Aug-2018 01:39:46 UTC] PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /var/www/html/wp-includes/wp-db.php on line 1531
this shows the query that is being run.
We have a lot of orders in our table. Is there any way to increase the speed.
Would it be faster if there were no suborder id’s?
The order splitting works well, and the front end loads fast. I am just unable to view the orders.
If you have the time please send me your email address I would like to consult with you if you have the time.
Thanks!!
-
This reply was modified 6 years, 3 months ago by kjphilips.
-
This reply was modified 6 years, 3 months ago by kjphilips.