Title: Cannot view orders
Last modified: April 10, 2025

---

# Cannot view orders

 *  Resolved [ktaylor310](https://wordpress.org/support/users/ktaylor310/)
 * (@ktaylor310)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/cannot-view-orders/)
 * I migrated this store to a new server and now cannot view any orders. When clicking
   the orders link they briefly flash and then it just shows the splash screen “
   When you receive a new order, it will appear here.”
 * I am seeing this DB error:
 * `[10-Apr-2025 16:24:50 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 'GROUP BY post_status' at line 1 for query SELECT
   post_status, COUNT( * ) AS num_posts FROM wp_posts WHERE post_type = 'shop_order'
   AND post_author != GROUP BY post_status made by WP_List_Table->display, WP_List_Table-
   >display_tablenav, WP_Posts_List_Table->extra_tablenav, do_action('manage_posts_extra_tablenav'),
   WP_Hook->do_action, WP_Hook->apply_filters, WC_Admin_List_Table->maybe_render_blank_state,
   wp_count_posts, apply_filters('wp_count_posts'), WP_Hook->apply_filters, wp_count_posts_extends,
   QM_DB->query`
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcannot-view-orders%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [ktaylor310](https://wordpress.org/support/users/ktaylor310/)
 * (@ktaylor310)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/cannot-view-orders/#post-18410457)
 * I found a conflict with a plugin that was not installed on the website but had
   lingering tables in the DB.
 *  [Jonayed (woo-hc)](https://wordpress.org/support/users/jonayedhosen/)
 * (@jonayedhosen)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/cannot-view-orders/#post-18411633)
 * Hi [@ktaylor310](https://wordpress.org/support/users/ktaylor310/) ,
 * Thanks so much for reaching out!
 * I’m really glad to hear you were able to track down the plugin that was causing
   the issue—that’s awesome detective work on your end.
 * If you’ve got a minute, we’d love to hear how your experience with WooCommerce
   has been so far. You can share your thoughts with us by leaving a quick review
   here:
   [https://wordpress.org/support/plugin/woocommerce/reviews](https://wordpress.org/support/plugin/woocommerce/reviews)
 * And of course, if anything else comes up or you need a hand with something, feel
   free to [open a new topic](https://wordpress.org/support/plugin/woocommerce/?view=all#new-topic-0)
   anytime. We’re always here to help.
 * Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Cannot view orders’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Jonayed (woo-hc)](https://wordpress.org/support/users/jonayedhosen/)
 * Last activity: [1 year, 1 month ago](https://wordpress.org/support/topic/cannot-view-orders/#post-18411633)
 * Status: resolved