order notes with URL corrupted & same as note with URL

  • slservice33

    (@slservice33)


    1 day, 20 hours ago

    for orders which have a URL added inside an order note and are before 12/8/24 the order notes have become corrupted and all read the same as the one order note which contains the URL.

    bit strange, does not effect orders after 12/8/24 and does not effect orders without a URL in one of the order notes (https://www.mysite/etc/etc)

    also the corrupted notes are not in my backups from a few months ago.

    any idea how I can get the original order notes back ??

    System Status Report

    ### WordPress Environment ###

    WordPress address (URL): [Redacted]
    Site address (URL): [Redacted]
    WC Version: 10.7.0
    Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
    Action Scheduler Version: ✔ 3.9.3
    Log Directory Writable: ✔
    WP Version: 6.9.4
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: ✔
    WP Cron: –
    WP Environment Type: production
    Language: en_GB
    External object cache: ✔

    ### Server Environment ###

    Server Info: Apache/2.4.67 (Debian)
    Server Architecture: Linux 6.1.0-41-cloud-amd64 x86_64
    PHP Version: 8.1.33
    PHP Post Max Size: 48 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 3000
    cURL Version: 7.88.1
    OpenSSL/3.0.18

    SUHOSIN Installed: –
    MySQL Version: 10.11.14-MariaDB-0+deb12u2
    Max Upload Size: 32 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔

    ### Database ###

    [REDACTED]

    ### Post Type Counts ###

    attachment: 598
    custom_css: 4
    customize_changeset: 20
    elementor_library: 7
    gblocks_global_style: 4
    gblocks_styles: 18
    gp_elements: 55
    mailpoet_page: 2
    nav_menu_item: 82
    page: 28
    popup: 1
    popup_theme: 8
    post: 953
    product: 100
    product_variation: 52
    revision: 67
    shop_order_placehold: 9486
    wp_block: 71
    wp_global_styles: 2
    wp_navigation: 1

    ### Security ###

    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔

    ### Active Plugins (35) ###

    Add Customer for WooCommerce: by Dan's Art – 1.9.5
    Antispam Bee: by pluginkollektiv – 2.11.11
    Code Snippets: by Code Snippets Pro – 3.9.6
    Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.6
    Error Log Monitor: by Janis Elsts – 1.7.12
    Turn Yoast SEO FAQ Block to Accordion: by WPHowKnow – 1.0.6
    Advanced Shipping Rates for WooCommerce: by wpcentrics – 2.1.8
    FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.2.95
    Fluent Forms: by Contact Form - WPManageNinja LLC – 6.2.2
    WP OPcache: by nierdz – 4.2.3
    Reviews and Rating – Google Reviews: by Noah Hearle
    Design Extreme – 5.10

    GenerateBlocks Pro: by Tom Usborne – 2.5.0
    GenerateBlocks: by Tom Usborne – 2.2.1
    Site Kit by Google: by Google – 1.178.0
    GP Premium: by Tom Usborne – 2.5.5
    Index WP MySQL For Speed: by Oliver Jones
    Rick James – 1.5.6

    IndexNow: by Microsoft Bing – 1.0.3
    MailPoet: by MailPoet – 5.25.0
    Popup Maker: by Popup Maker – 1.22.0
    Redirection: by John Godley – 5.7.5
    Redis Object Cache: by Till Krüss – 2.8.0
    Simple History: by Pär Thernström – 5.27.0
    Ultimate Category Excluder: by Marios Alexandrou – 1.7
    UpdraftPlus - Backup/Restore: by TeamUpdraft
    DavidAnderson – 2.26.4.26

    WooCommerce Stripe Gateway: by Stripe – 10.5.3
    WooCommerce PayPal Payments: by PayPal – 4.0.2 (update to version 4.0.3 is available)
    PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 5.11.0
    WooCommerce: by Automattic – 10.7.0
    Yoast SEO: by Team Yoast – 27.5
    WP Crontrol: by John Blackbourn – 1.21.0
    WP Fail2Ban Redux: by Brandon Allen – 0.9.2
    WP Fastest Cache Premium: by Emre Vona – 1.7.6
    WP Fastest Cache: by Emre Vona – 1.4.8
    WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.8
    WPS Hide Login: by WPServeur
    NicolasKulka
    wpformation – 1.9.18


    ### Inactive Plugins (1) ###

    GTM Kit: by GTM Kit – 2.10.0

    ### Dropin Plugins () ###

    object-cache.php: Redis Object Cache Drop-In

    ### Must Use Plugins (1) ###

    Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by  – 1.4.18

    ### Settings ###

    Legacy API Enabled: –
    Force SSL: –
    Currency: GBP (£)
    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 enabled: ✔
    Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
    HPOS data sync enabled: –
    Enabled Features: analytics
    rate_limit_checkout
    marketplace
    order_attribution
    site_visibility_badge
    hpos_fts_indexes
    hpos_datastore_caching
    blueprint
    destroy-empty-sessions
    custom_order_tables


    ### Logging ###

    Enabled: ✔
    Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
    Retention period: 30 days
    Level threshold: –
    Log directory size: 7 MB

    ### WC Pages ###

    Shop base: #327 - /
    Basket: #328 - /cart/ -  Contains the [woocommerce_cart] shortcode
    Checkout: #329 - /checkout/ -  Contains the [woocommerce_checkout] shortcode
    My account: #330 - /my-account/ -  Contains the [woocommerce_my_account] shortcode
    Terms and conditions: #4755 - /information/refund_returns/

    ### Theme ###

    Name: GeneratePress
    Version: 3.6.1
    Author URL: https://generatepress.com/about
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    Theme type: Classic theme
    WooCommerce Support: ✔

    ### Templates ###

    Overrides: –

    ### WooCommerce Stripe Payment Gateway ###

    Version: 10.5.3
    Account ID: acct_1CIGK1Ji9ffg38lF
    Test Mode Enabled: ✔
                        No
    OAuth Connected: ✔
                        Yes
    Sync Enabled: ✔
                        Yes
    Optimized Checkout Enabled: No
    Enabled Payment Methods: apple_pay,card,google_pay
    Express Checkout: ✔
                        Enabled (product,cart)
    Auth and Capture: ✔
                        Yes
    Logging: No

    ### MailPoet ###

    Sending Method: PHPMail
    Send all site's emails with: Default WordPress sending method
    Task Scheduler method: Linux Cron
    Cron ping URL: https://www.slservice.net?mailpoet_router&endpoint=cron_daemon&action=ping

    ### WooCommerce PayPal Payments ###

    Onboarded: ✔
    Branded only: –
    Shop country code: GB
    WooCommerce currency supported: ✔
    Advanced Card Processing available in country: ✔
    Pay Later messaging available in country: ✔
    Webhook status: ✔
    PayPal Vault enabled: –
    ACDC Vault enabled: –
    Logging enabled: –
    Reference Transactions: ✔
    Used PayPal Checkout plugin: ✔
    Subscriptions Mode: Disabled
    PayPal Shipping Callback: –
    Apple Pay: –
    Google Pay: –
    Fastlane: –

    ### Admin ###

    Enabled Features: activity-panels
    analytics
    analytics-scheduled-import
    product-block-editor
    experimental-iapi-mini-cart
    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
    onboarding
    onboarding-tasks
    pattern-toolkit-full-composability
    product-custom-fields
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    printful
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    launch-your-store

    Disabled Features: product-data-views
    experimental-blocks
    experimental-iapi-runtime
    coming-soon-newsletter-template
    minified-js
    product-pre-publish-modal
    products-catalog-api
    settings
    async-product-editor-category-field
    product-editor-template-system
    use-wp-horizon
    rest-api-v4

    Daily Cron: ✔ Next scheduled: 2026-05-08 21:26:49 +01:00
    Options: ✔
    Notes: 154
    Onboarding: completed

    ### Action Scheduler ###

    Complete: 3,613
    Oldest: 2026-04-07 12:13:02 +0100
    Newest: 2026-05-08 12:13:03 +0100

    Failed: 114
    Oldest: 2023-02-28 22:50:46 +0000
    Newest: 2025-09-11 14:27:07 +0100

    Pending: 15
    Oldest: 2026-05-08 13:13:03 +0100
    Newest: 2026-05-31 02:33:02 +0100


    ### Status report information ###

    Generated at: 2026-05-08 12:17:30 +01:00
    • This topic was modified 1 day, 20 hours ago by slservice33.

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    1 day, 18 hours ago

    Hi there!

    Thank you for the detailed explanation.

    That does sound unusual. Since:

    • the issue only affects older orders (before 12/8/24),
    • only order notes containing URLs are affected,
    • and even older backups now show the corrupted notes,

    this may indicate that something modified the order notes directly in the database at some point, rather than the issue being caused by WooCommerce itself displaying the notes incorrectly. Also, could you please confirm whether the issue started after any plugin/theme update or migration?

    Unfortunately, WooCommerce does not keep historical revisions for order notes, so if the original note content was overwritten in the database, WooCommerce itself would not be able to restore the previous versions automatically.

    If you are comfortable checking the database (or your developer can), compare:

    • affected order notes,
    • unaffected order notes,
    • and whether the same URL/content appears duplicated across multiple rows.

    That may help identify whether the content was overwritten globally.

    1. Caching or object cache
      If you are using Redis, Memcached, or server-level object caching, try clearing all caches first just to rule out cached note content being displayed incorrectly.

    At the moment, if the original note text no longer exists in the database or in an older backup, there unfortunately may not be a way to recover the exact original notes.

    Thread Starter slservice33

    (@slservice33)

    1 day, 15 hours ago

    I’ve cleared redis, opcache & wpfastest cache. The uncorrupted version is actually from Oct 25 and I’ll check some later backups when I have time. I’ve done a few thing like turn on HPOS Full text search indexes & HPOS Data Caching since then.

    I’ve tried logging in as a customer and the corrupted order notes show to users in my-account-orders also.
    The total number of order notes is not effected and the color of each order note in wp-admin is what it was originally but every single order note has the same content as the note with the URL in it eg

    Hello, please click the link below to pay:
    https://www.MYSITE.net/checkout/order-pay/336764/?pay_for_order=true&key=wc_order_GqJKDhrK


    Thread Starter slservice33

    (@slservice33)

    1 day, 7 hours ago

    I think it must have happened when I searched replaced http://www.mysite with https://www.mysite and the effected older order notes had http://www.mysite

    Can you recommend a reliable method to copy all the pre 12/8/24 orders & notes from my uncorrupted test site to my working site ?

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.