Upon login WooCommerce queries each users entire purchase history

  • Resolved bsteeletx

    (@bsteeletx)


    5 years ago

    We have a couple of problems–

    1) Some of our super users, who have purchased nearly all of our products (nearly 10,000) can no longer log in.

    2) We had a sale, and no one was able to log in.

    per our server admin, this is due to the site doing a query on the database for all of the user’s purchases.

    I have disabled every plugin that has anything to do with a customer’s orders and purchase except for WooCommerce.

    So does WooCommerce query the database for this information upon login? Is there a way to make it NOT do that and not break some other functionality? This was working last month for sure. Problem #1 didn’t pop up until maybe 2 weeks ago.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter bsteeletx

    (@bsteeletx)

    In particular, the SQL query that is running over and over again is:

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.

    Thread Starter bsteeletx

    (@bsteeletx)

    Adding Tags

    Thread Starter bsteeletx

    (@bsteeletx)

    Solved it.

    What was the solution?
    Always post the solution for others who search for the same issue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Upon login WooCommerce queries each users entire purchase history’ is closed to new replies.

Tags