Table wp_wc_order_product_lookup has not recorded data since 2022-08-12

  • Resolved mano03

    (@mano03)


    4 months, 3 weeks ago

    Table wp_wc_order_product_lookup has not recorded data since 2022-08-12

    While updating a plugin for gift lists, I find the problem that within this list it does not show the orders to the products in this list, then I check the plugin and see that it uses the wp_wc_order_product_lookup table for the query that shows the information.

    After understanding this, I decide to connect to the database to consult the wp_wc_order_product_lookup table and I find that it has not made records since 2022-08-12. I have created a test environment with a copy of the website and I have deactivated all the plugins except woocommerce, I have placed an order to verify that it is not an incompatibility with the plugin and still nothing is recorded in the wp_wc_order_product_lookup table.

    I have already performed the actions from Woocommerce > Tools, checking the status of the tables, I have used the tool to regenerate the table and still the last record inside is from 2022-08-12

    I have also tried with the WPCLI to regenerate the wp_wc_order_product_lookup table but it does not work either.

    I would like to understand why this happened and how to solve it, I hope you can help me.

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello mano03,

    Thank you for contacting WooCommerce support.

    To assist you further, I’d like to gather more details about your setup.

    Could you please share a copy of your site’s System Status Report?
    You can find it by navigating to WooCommerce > Status, then selecting Get system report and clicking Copy for support.

    Additionally, please go to WooCommerce → Status → Tools and click the Regenerate button next to Product lookup tables.

    Looking forward to your response. ??

    Best regards.

    Jol

    (@jolebrahim)

    Hello, I am Jol, a colleague of Jesus (mano03), I have already regenerated the tables as you indicate, I have recorded it on video, but I have no way to connect to the database, I also attach the WooCommerce status report.

    https://drive.google.com/drive/folders/1xtKBwJpyoW53xJKbc7glW2SUMZ4E-dsj?usp=sharing

    I hope that when Jesus sees this, he can connect to the Database and can check if the tables have been regenerated, anyway, I think we are going to be out of luck, since we already did this test before and did not get a result satisfying.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello Jol,

    Thank you for your reply.

    To confirm, it seems you’re unable to access the database directly to verify whether the wp_wc_order_product_lookup table has been properly regenerated.

    In that case, it would be best to wait for Jesus (mano03) to check and confirm the status of the tables once he has access to the database.

    Best regards.

    Thread Starter mano03

    (@mano03)

    Thanks @doublezed2 we have carried out the entire process of regenerating the tables but still the last record that is observed in the database is from the date 2022-08-12

    We have also decided to deactivate all third-party plugins and leave only woocommerce, to carry out this action and still we do not see changes in the database.

    Is there any other recommendation or action that we can try to continue trying to regenerate this table, we remain attentive, greetings

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello mano03,

    Thank you for the update and for trying those steps.

    It sounds like the issue might be related to WP Cron.
    Could you check if any Pending actions related to wc_update_order_product_lookup_tables have failed or are stuck? This could prevent the table from regenerating properly.

    Additionally, I recommend checking the fatal error log (WooCommerce > System Status > Logs) after attempting to place an order to see if any errors related to the lookup table are recorded.

    If you’re comfortable with more advanced steps, you could also:

    • Run a database integrity check to verify if there are any corruption issues.
      This can be done through phpMyAdmin or WP-CLI with the following commands:
      wp db check
      wp db repair
    • You might consider manually recreating the wp_wc_order_product_lookup table.
      After making a backup of your database, you can delete the current table and allow WooCommerce to regenerate it from scratch.

    Let me know if you need more detailed instructions on any of these steps.
    I’ll be here to assist you further.

    Best regards.

    Plugin Support Feten L. a11n

    (@fetenlakhal)

    Hi! Since we haven’t heard back from you, I’ll close this for now. You can always reconnect with us when you’re ready to move forward.

Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.

Tags