Cannot view orders

  • Resolved ktaylor310

    (@ktaylor310)


    1 year, 1 month ago

    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 to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter ktaylor310

    (@ktaylor310)

    1 year, 1 month ago

    I found a conflict with a plugin that was not installed on the website but had lingering tables in the DB.

    Jonayed (woo-hc)

    (@jonayedhosen)

    1 year, 1 month ago

    Hi @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://ww.wp.xz.cn/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 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.