Error for order that does not exist

  • Resolved Ashley

    (@ashleyrussell)


    11 months, 1 week ago

    Hi – I’m getting errors in my WooCommerce logs for two orders that do not exist:

    2024-04-24T15:59:09+00:00Warning Error when setting property ‘parent_id’ for order 3334: Invalid parent ID 

    Additional context{ “error_code”: “order_invalid_parent_id”, “error_message”: “Invalid parent ID”, “order_id”: 3334, “property_name”: “parent_id” }

    2024-04-24T15:59:09+00:00Warning Error when setting property ‘parent_id’ for order 76817: Invalid parent ID 

    Additional context{ “error_code”: “order_invalid_parent_id”, “error_message”: “Invalid parent ID”, “order_id”: 76817, “property_name”: “parent_id” }

    2024-04-24T15:59:09+00:00Warning Error when setting property ‘parent_id’ for order 3334: Invalid parent ID CONTEXT: {“exception_code”:400,”exception_msg”:”Invalid parent ID”,”origin”:”Automattic\\WooCommerce\\Internal\\DataStores\\Orders\\OrdersTableDataStore::set_order_props_from_data”,”order_id”:3334,”property_name”:”parent_id”}

    2024-04-24T15:59:09+00:00 Warning Error when setting property ‘parent_id’ for order 76817: Invalid parent ID CONTEXT: {“exception_code”:400,”exception_msg”:”Invalid parent ID”,”origin”:”Automattic\\WooCommerce\\Internal\\DataStores\\Orders\\OrdersTableDataStore::set_order_props_from_data”,”order_id”:76817,”property_name”:”parent_id”}

    Neither of these orders exist. Any idea what’s going on here?

    ` WordPress Environment

WordPress address (URL): https://aetherea.life
Site address (URL): https://aetherea.life
WC Version: 8.8.2
REST API Version: ? 8.8.2
Action Scheduler Version: ? 3.7.4
Log Directory Writable: ?
WP Version: 6.5.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: ? Server Environment

Server Info: nginx
PHP Version: 8.1.28
PHP Post Max Size: 2 GB
PHP Time Limit: 1200
PHP Max Input Vars: 6144
cURL Version: 8.7.1
OpenSSL/1.1.1n

SUHOSIN Installed: –
MySQL Version: 10.4.26-MariaDB-log
Max Upload Size: 2 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 8.8.2
WC Database Prefix: wp_
Total Database Size: 608.18MB
Database Data Size: 348.77MB
Database Index Size: 259.41MB
wp_woocommerce_sessions: Data: 0.14MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.11MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 1.48MB + Index: 0.77MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.14MB + Index: 0.14MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 31.02MB + Index: 28.11MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 42.02MB + Index: 13.03MB + Engine InnoDB
wp_apto_sort_list: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ce4wp_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 1.52MB + Index: 0.56MB + Engine InnoDB
wp_dgwt_wcas_index: Data: 6.52MB + Index: 0.22MB + Engine InnoDB
wp_dgwt_wcas_invindex_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dgwt_wcas_invindex_doclist: Data: 10.52MB + Index: 12.03MB + Engine InnoDB
wp_dgwt_wcas_invindex_wordlist: Data: 4.52MB + Index: 4.52MB + Engine InnoDB
wp_dgwt_wcas_stats: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
wp_dgwt_wcas_tax_index: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_dgwt_wcas_var_index: Data: 11.52MB + Index: 5.00MB + Engine InnoDB
wp_ewwwio_images: Data: 0.20MB + Index: 0.17MB + Engine InnoDB
wp_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 13.05MB + Index: 3.05MB + Engine InnoDB
wp_pmxe_exports: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 5.05MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 8.22MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.30MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 131.44MB + Index: 134.05MB + Engine InnoDB
wp_posts: Data: 27.06MB + Index: 8.23MB + Engine InnoDB
wp_rednaowooextraproduct_global_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 8.19MB + Index: 3.06MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 8.28MB + Index: 3.94MB + Engine InnoDB
wp_users: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_orders: Data: 0.50MB + Index: 0.64MB + Engine InnoDB
wp_wc_orders_meta: Data: 5.52MB + Index: 11.11MB + Engine InnoDB
wp_wc_order_addresses: Data: 0.36MB + Index: 0.48MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_operational_data: Data: 0.28MB + Index: 0.14MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.22MB + Index: 0.25MB + Engine InnoDB
wp_wc_order_stats: Data: 0.14MB + Index: 0.11MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 4.16MB + Index: 3.06MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 4.19MB + Index: 11.14MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpam_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_affiliates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_affiliates_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_creatives: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_impressions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_paypal_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_tracking_tokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_tracking_tokens_purchase_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpam_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpo_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpo_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wapo_addons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wapo_blocks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 12.47MB + Index: 9.86MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 2.06MB + Index: 4.38MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.22MB + Index: 0.16MB + Engine InnoDB Post Type Counts

acf-field: 15
acf-field-group: 4
admin_login_history: 90
apto_sort: 27
attachment: 289
b2bking_conversation: 5
b2bking_custom_field: 10
b2bking_custom_role: 3
b2bking_group: 2
b2bking_list: 3
b2bking_rule: 3
ct_content_block: 2
custom_css: 2
customize_changeset: 1
interviews: 3
jetpack-testimonial: 14
nav_menu_item: 42
oembed_cache: 1
order_form: 1
page: 35
post: 29
practitioners: 9
product: 8949
product_variation: 26828
revision: 629
shop_coupon: 4
shop_order: 1508
shop_order_refund: 8
stackable_temp_post: 1
video_library: 21
wapf_product: 1
wc_order_status: 10
wp_block: 4
wp_global_styles: 1
wp_navigation: 1
wp_template: 2
wpforms: 2 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (26)

Stackable - Gutenberg Blocks (Premium): by Gambit Technologies
Inc – 3.12.15

Admin Menu Editor Pro: by Janis Elsts – 2.24
Advanced Custom Fields PRO: by WP Engine – 6.2.9
FiboSearch - AJAX Search for WooCommerce (Pro): by FiboSearch Team – 1.27.1
Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2
Blocksy Companion (Premium): by CreativeThemes – 2.0.40
aetherea Product Options: by Nikola Petrov – 1.0.0
EWWW Image Optimizer: by Exactly WWW – 7.5.0
Heartbeat Control by WP Rocket: by WP Rocket – 2.0.1
Jetpack Protect: by Automattic - Jetpack Security team – 2.1.0
Jetpack: by Automattic – 13.4-a.3
Pressable Cache Management: by Pressable CS Team – 4.2.1
Pressable OnePress Login: by Pressable – 1.3.2
aetherea Custom Posts: by team A design – 1.0.0
WooCommerce Address Book: by CrossPeak – 2.6.2
WooCommerce Authorize.Net Gateway: by SkyVerge – 3.10.2
WooCommerce Order Status Manager: by SkyVerge – 1.15.2
WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.13.3
WooCommerce Shipping & Tax: by WooCommerce – 2.5.4
WooCommerce USPS Shipping: by WooCommerce – 4.8.3
WooCommerce Wholesale Order Form: by Rymera Web Co – 3.0.4.1
WooCommerce Wholesale Prices Premium: by Rymera Web Co – 1.30.5.1
WooCommerce Wholesale Prices: by Rymera Web Co – 2.1.12
WooCommerce: by Automattic – 8.8.2
Yoast SEO: by Team Yoast – 22.5
WooCommerce Shop As Customer: by Progos – 1.1.0 Inactive Plugins (10)

Custom Post Type UI: by WebDevStudios – 1.16.0
Query Monitor: by John Blackbourn – 3.16.2
WP All Export - ACF Export Add-On Pro: by Soflyy – 1.0.5
WP All Export - User Export Add-On Pro: by Soflyy – 1.0.7
WP All Export - WooCommerce Export Add-On Pro: by Soflyy – 1.0.9
WP All Export Pro: by Soflyy – 1.8.6
WP All Import - ACF Add-On: by Soflyy – 3.3.8
WP All Import - User Import Add-On Pro: by Soflyy – 1.1.8
WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 4.0.0
WP All Import Pro: by Soflyy – 4.8.7 Dropin Plugins ()

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class (Drop-in)
object-cache.php: Memcached Must Use Plugins (2)

Batcache Manager: by Jonathan Harris – 2.0.0
pressable-cache-management.php: by – Settings

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: ?
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: ?
HPOS feature enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: ? Logging

Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 15 MB WC Pages

Shop base: #69 - /shop/
Cart: #70 - /cart/
Checkout: #71 - /checkout/
My account: #72 - /my-account/
Terms and conditions: ? Page not set Theme

Name: aetherea (Blocksy Child)
Version: (update to version 0 is available)
Author URL:
Child Theme: ?
Parent Theme Name: Blocksy
Parent Theme Version: 2.0.40 – 2.0.41 is available
Parent Theme Author URL: https://creativethemes.com
WooCommerce Support: ? Templates

Overrides: blocksy/woocommerce/cart/cart.php
blocksy/woocommerce/cart/mini-cart.php
blocksy/woocommerce/content-widget-product.php
blocksy/woocommerce/content-widget-reviews.php
aetherea/woocommerce/emails/customer-on-hold-order.php
blocksy/woocommerce/myaccount/my-account.php
blocksy/woocommerce/product-searchform.php
blocksy/woocommerce/single-product/tabs/tabs.php Authorize.Net Credit Card

Environment: Production
Tokenization Enabled: ?
Debug Mode: Off
Webhooks Enabled: ?
No signature key configured Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
product-pre-publish-modal
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
product-custom-fields
settings
async-product-editor-category-field
launch-your-store

Daily Cron: ? Next scheduled: 2024-04-25 16:51:29 -05:00
Options: ?
Notes: 50
Onboarding: completed Action Scheduler

Complete: 9,000
Oldest: 2024-03-24 12:57:12 -0500
Newest: 2024-04-24 11:50:56 -0500

Failed: 1,770
Oldest: 2023-06-15 13:47:10 -0500
Newest: 2024-03-25 10:23:11 -0500

Pending: 3
Oldest: 2024-04-24 12:50:56 -0500
Newest: 2024-04-24 22:23:43 -0500 Status report information

Generated at: 2024-04-24 12:04:36 -05:00
`
    • This topic was modified 11 months, 1 week ago by Ashley.
Viewing 4 replies - 16 through 19 (of 19 total)
  • Plugin Support Rajesh K. (woo-hc)

    (@rajeshml)

    Hello @berkmh,

    Sorry to hear that you are experiencing a similar issue.

    Per WordPress?forum guidelines, would you mind?opening up a new thread?for this so that we can keep things organized and offer more personalized support for you?

    Thanks!

    Thread Starter Ashley

    (@ashleyrussell)

    @berkmh I did not – would love to hear if you find any answers. Did you start a new thread?

    • This reply was modified 5 months, 2 weeks ago by Ashley.

    Same here.

    Woocommerce is creating error logs with fake order numbers on our website, this has also been reported by many other users with no resolution.

    Logs show:

    2024-12-07T00:34:37+00:00 Warning Error when setting property 'parent_id' for order 34556: Invalid parent ID
    Additional context
    {
    "error_code": "order_invalid_parent_id",
    "error_message": "Invalid parent ID",
    "order_id": 34556,
    "property_name": "parent_id"
    }
    2024-12-07T00:34:40+00:00 Warning Error when setting property 'parent_id' for order 56595: Invalid parent ID
    Additional context
    2024-12-07T00:34:48+00:00 Warning Error when setting property 'parent_id' for order 34556: Invalid parent ID
    Additional context
    2024-12-07T00:34:48+00:00 Warning Error when setting property 'parent_id' for order 56595: Invalid parent ID
    Additional context
    2024-12-07T00:39:50+00:00 Warning Error when setting property 'parent_id' for order 56595: Invalid parent ID
    Additional context
    2024-12-07T00:41:13+00:00 Warning Error when setting property 'parent_id' for order 34556: Invalid parent ID
    Additional context
    2024-12-07T07:41:55+00:00 Warning Unable to load the post record for order 119965
    Additional context
    2024-12-07T07:42:33+00:00 Warning Unable to load the post record for order 119965
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 114612
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 119423
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 122206
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 122206
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 119423
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 114612
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 119423
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 119423
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 114612
    Additional context
    2024-12-07T20:45:28+00:00 Warning Unable to load the post record for order 114612
    Additional context
    {
    "exception_code": 0,
    "exception_msg": "Invalid order.",
    "origin": "Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore::get_post_orders_for_ids"
    }

    We already did all of this and none of them needed to have been done:

    WooCommerce transients – Clear
    Expired transients – Clear
    Clear template cache – Clear
    Capabilities – Reset Capabilities
    Clear customer sessions -Clear
    Product lookup tables – Regenerate
    Regenerate the product attributes lookup table – Regenerate
    Plugin Support Jonayed (woo-hc)

    (@jonayedhosen)

    Hi @joyryde ,

    I understand you’re dealing with the same issue, and I know how frustrating it can be. This seems to be linked to orders with invalid or missing parent_id values or orders mistakenly marked as children of others.

    These issues are often caused by third-party plugins, such as those handling subscriptions, abandoned cart recovery, or custom order management. From what you’ve shared, it sounds like the issue persists even after deactivating those plugins.

    To address this, I recommend checking for any plugins that may be modifying order data. You can also try cleaning up or updating the parent_id field in the database. Have you tried using the Advanced Database Cleaner plugin to help with this? It could streamline the cleanup process.

    If you’re comfortable working with SQL, you might also inspect the wp_posts and wp_postmeta tables for inconsistencies. Since orders are stored as custom post types, look for orders with missing parent_id values or incorrect statuses. Updating these manually could resolve the issue.

    That said, because this involves more in-depth database investigation, I’d recommend consulting a developer to ensure everything is handled safely. You can reach out to services like Codeable or a Certified WooExpert for professional help.

    I hope this helps!

Viewing 4 replies - 16 through 19 (of 19 total)
  • You must be logged in to reply to this topic.