HPOS Cleaning Metadata Tool

Hi @svenms,

Thank you for reaching out. The error message you’re encountering indicates that the order with ID 93102 is not recognized as a valid order within the WooCommerce system, even though it appears in the Post table in your database. This discrepancy can happen for various reasons, such as manual database entries or incomplete order deletions. To assist you further and ensure we provide the most accurate solution, could you please confirm a few details for us?

1. Have you manually added or removed any order entries directly in the database?
2. Have you used any database optimization or cleaning tools prior to this issue?
3. Can you check if there are any residual entries related to order 93102 in other tables, such as woocommerce_order_items or woocommerce_order_itemmeta?

Once we have this information, we’ll be better positioned to guide you through the next steps.

1. Have you manually added or removed any order entries directly in the database? NO
2. Have you used any database optimization or cleaning tools prior to this issue? Yes, we have used some in the past but I do not remember their name.
3. Can you check if there are any residual entries related to order 93102 in other tables, such as?woocommerce_order_items?or?woocommerce_order_itemmeta? No, there ir no info in those tables.

By the way there are more order numbers with this problem, at least 10 more that I could see in the logs Error.

Hello svenms

Thank you for your reply.

Could you please share screenshots of the search results in the tables woocommerce_order_items and woocommerce_order_itemmeta?

Just to be sure, could you also search the wp_posts table for ID 93102?
This will make sure whether there is an entry with this ID or not.

Let me know about your results. ??

Best regards.

Hello, sure!

woocommerce_order_items: https://ibb.co/1Tg5YPC (nothing)

woocommerce_order_itemmeta: https://ibb.co/Ytyk9gs and https://ibb.co/Y7LN56z

wp_post: https://ibb.co/sgrYvBV

wp_postmeta: https://ibb.co/82V2N4Z

Thanks!

Hi @svenms,

This could be due to the past use of database optimization or cleaning tools that might have deleted entries from some tables but not others. However, is the “Enable compatibility mode” enabled by any chance? Can you check whether this order ID is in the shop_order_placehold table or not?

Looking forward to hearing from you soon.

Hello,

• Enable compatibility mode is off

• Post type is shop_order in wp_post table

Best regards!

Hi @svenms,

Since “Enable compatibility mode” is off and the post type is shop_order in the wp_post table, the order ID might be recognized in some parts of your database but not others.

To resolve this issue, you might need to remove the problematic order ID from the database manually. However, please be aware that this should be done cautiously as it could affect other parts of your website.

Before proceeding, please ensure to back up your website and database.

Let us know how that goes. Looking forward to hearing from you!

Hey there. We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.