Support » Plugin: WooCommerce » Repeating database error Unknown column ‘nonce_action’

  • Resolved rsurfer


    I have a repeating database error showing in my error_log file, as below. I updated to the latest version of WooCommerce 4 days ago so perhaps it’s related to that? The error doesn’t seem to be causing issues with the site. Each line in the log is the same but with a different note_id. Does anyone have an idea what’s causing this? System status report is below also. Thanks in advance.

    [16-Jun-2021 08:42:03 UTC] WordPress database error Unknown column 'nonce_action' in 'field list' for query SELECT action_id, name, label, query, status, is_primary, actioned_text, nonce_action, nonce_name
    				FROM tpe_wc_admin_note_actions
    				WHERE note_id = 48 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Install::check_version, do_action('woocommerce_admin_updated'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\RemoteInboxNotifications\RemoteInboxNotificationsEngine::run_on_woocommerce_admin_updated, Automattic\WooCommerce\Admin\RemoteInboxNotifications\RemoteInboxNotificationsEngine::run, Automattic\WooCommerce\Admin\RemoteInboxNotifications\SpecRunner::run_spec, WC_Data->save, WC_Data_Store->update, Automattic\WooCommerce\Admin\Notes\DataStore->update, Automattic\WooCommerce\Admin\Notes\DataStore->save_actions, Automattic\WooCommerce\Admin\Notes\DataStore->read_actions
    ### WordPress Environment ###
    WordPress address (URL):
    Site address (URL):
    WC Version: 5.4.1
    REST API Version: ✔ 5.4.1
    WC Blocks Version: ✔ 5.1.0
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 2.3.1
    Log Directory Writable: ✔
    WP Version: 5.7.2
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_GB
    External object cache: –
    ### Server Environment ###
    Server Info: LiteSpeed
    PHP Version: 7.3.28
    PHP Post Max Size: 64 MB
    PHP Time Limit: 180
    PHP Max Input Vars: 3000
    cURL Version: 7.74.0
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.2.38-MariaDB
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    ### Database ###
    WC Database Version: 5.4.1
    WC Database Prefix: partyexperts_
    Total Database Size: 447.36MB
    Database Data Size: 300.59MB
    Database Index Size: 146.77MB
    partyexperts_woocommerce_sessions: Data: 88.06MB + Index: 2.40MB + Engine MyISAM
    partyexperts_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    partyexperts_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_woocommerce_order_items: Data: 3.66MB + Index: 1.92MB + Engine MyISAM
    partyexperts_woocommerce_order_itemmeta: Data: 22.96MB + Index: 16.42MB + Engine MyISAM
    partyexperts_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    partyexperts_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_woocommerce_payment_tokens: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    partyexperts_woocommerce_payment_tokenmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
    partyexperts_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_actionscheduler_actions: Data: 2.63MB + Index: 0.83MB + Engine MyISAM
    partyexperts_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    partyexperts_actionscheduler_logs: Data: 1.61MB + Index: 1.01MB + Engine MyISAM
    partyexperts_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_comments: Data: 9.54MB + Index: 3.92MB + Engine MyISAM
    partyexperts_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_litespeed_img_optm: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
    partyexperts_options: Data: 9.50MB + Index: 0.77MB + Engine MyISAM
    partyexperts_postmeta: Data: 80.45MB + Index: 45.00MB + Engine MyISAM
    partyexperts_posts: Data: 10.89MB + Index: 2.35MB + Engine MyISAM
    partyexperts_termmeta: Data: 0.26MB + Index: 0.16MB + Engine MyISAM
    partyexperts_terms: Data: 0.03MB + Index: 0.06MB + Engine MyISAM
    partyexperts_term_relationships: Data: 0.31MB + Index: 0.64MB + Engine MyISAM
    partyexperts_term_taxonomy: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
    partyexperts_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_usermeta: Data: 4.36MB + Index: 2.76MB + Engine MyISAM
    partyexperts_users: Data: 0.21MB + Index: 0.19MB + Engine MyISAM
    partyexperts_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wc_category_lookup: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
    partyexperts_wc_customer_lookup: Data: 1.35MB + Index: 1.10MB + Engine MyISAM
    partyexperts_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    partyexperts_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    partyexperts_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    partyexperts_wc_order_product_lookup: Data: 2.76MB + Index: 2.36MB + Engine MyISAM
    partyexperts_wc_order_stats: Data: 1.40MB + Index: 0.77MB + Engine MyISAM
    partyexperts_wc_order_tax_lookup: Data: 0.75MB + Index: 0.82MB + Engine MyISAM
    partyexperts_wc_product_meta_lookup: Data: 0.25MB + Index: 0.50MB + Engine InnoDB
    partyexperts_wc_reserved_stock: Data: 0.28MB + Index: 0.01MB + Engine MyISAM
    partyexperts_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    partyexperts_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    partyexperts_wfblockediplog: Data: 0.08MB + Index: 0.07MB + Engine MyISAM
    partyexperts_wfblocks7: Data: 0.05MB + Index: 0.03MB + Engine MyISAM
    partyexperts_wfconfig: Data: 2.43MB + Index: 0.02MB + Engine MyISAM
    partyexperts_wfcrawlers: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wffilemods: Data: 2.45MB + Index: 0.49MB + Engine MyISAM
    partyexperts_wfhits: Data: 4.57MB + Index: 1.04MB + Engine MyISAM
    partyexperts_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wfissues: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
    partyexperts_wfknownfilelist: Data: 1.31MB + Index: 0.15MB + Engine MyISAM
    partyexperts_wflivetraffichuman: Data: 0.11MB + Index: 0.17MB + Engine MyISAM
    partyexperts_wflocs: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    partyexperts_wflogins: Data: 0.39MB + Index: 0.10MB + Engine MyISAM
    partyexperts_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    partyexperts_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    partyexperts_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wfreversecache: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    partyexperts_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wfstatus: Data: 0.15MB + Index: 0.07MB + Engine MyISAM
    partyexperts_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_wm_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    partyexperts_wm_trees: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    partyexperts_woocommerce_exported_csv_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    partyexperts_woocommerce_gpf_google_taxonomy: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    partyexperts_wps_hit: Data: 6.52MB + Index: 23.64MB + Engine InnoDB
    partyexperts_wps_index: Data: 16.55MB + Index: 24.55MB + Engine InnoDB
    partyexperts_wps_key: Data: 0.45MB + Index: 0.36MB + Engine InnoDB
    partyexperts_wps_object_term: Data: 0.75MB + Index: 1.06MB + Engine MyISAM
    partyexperts_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    partyexperts_wps_query: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    partyexperts_wps_uri: Data: 5.52MB + Index: 3.52MB + Engine InnoDB
    partyexperts_wps_user_agent: Data: 0.34MB + Index: 0.16MB + Engine InnoDB
    partyexperts_yoast_indexable: Data: 7.48MB + Index: 2.43MB + Engine MyISAM
    partyexperts_yoast_indexable_hierarchy: Data: 0.17MB + Index: 0.55MB + Engine MyISAM
    partyexperts_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    partyexperts_yoast_primary_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    partyexperts_yoast_seo_links: Data: 2.52MB + Index: 1.95MB + Engine InnoDB
    partyexperts_yoast_seo_meta: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    ### Post Type Counts ###
    acf-field: 55
    acf-field-group: 8
    attachment: 3484
    custom_css: 1
    cwginstocknotifier: 144
    nav_menu_item: 199
    oembed_cache: 27
    page: 11
    post: 2
    postman_sent_mail: 250
    product: 2574
    revision: 52
    seedprod: 1
    shop_coupon: 6
    shop_order: 16103
    shop_order_refund: 899
    testimonials: 2
    wafs: 1
    wpcf7_contact_form: 1
    wphash_ntf_bar: 1
    wpmm_theme: 1
    ### Security ###
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    ### Active Plugins (31) ###
    Admin Category Tree: by Stefan Andernach – 1.3.2
    Advanced Custom Fields PRO: by Elliot Condon – 5.9.6
    Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 2.2
    WordPress Backup & Security Plugin - BlogVault: by Backup by BlogVault – 4.61
    Contact Form 7: by Takayuki Miyoshi – 5.4.1
    Google Tag Manager for WordPress: by Thomas Geiger – 1.13.1
    Facebook for WooCommerce: by Facebook – 2.6.0
    MonsterInsights - eCommerce Addon: by MonsterInsights Team – 7.5.0
    MonsterInsights Pro: by MonsterInsights – 7.17.0
    Cookie and Consent Solution for the GDPR & ePrivacy: by iubenda – 2.5.3
    Maintenance: by WebFactory Ltd – 4.02
    Max Mega Menu - Pro Addon: by – 2.2.2
    Max Mega Menu: by – 2.9.3
    Post SMTP: by Yehuda Hassine – 2.0.23
    Product Category Tree: by AWESOME TOGI – 2.5
    Really Simple SSL: by Really Simple Plugins – 4.0.15
    CTX Feed Pro: by WebAppick – 5.2.58
    Widget Options: by Widget Options Team – 3.7.8
    WooCommerce Advanced Free Shipping: by Jeroen Sormani – 1.1.4
    WooCommerce Customer/Order/Coupon Export: by SkyVerge – 5.0.5 (update to version 5.3.2 is available)
    WooCommerce Stripe Gateway: by WooCommerce – 5.2.3
    Woocommerce Google Merchant Center Customer Reviews: by – 1.1.2 (update to version 1.1.7 is available)
    WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.8.6 (update to version 3.11.3 is available)
    WooCommerce Google Product Feed: by Ademti Software Ltd. – 9.0.4 (update to version 10.1.0 is available)
    WooCommerce Product Search: by itthinx – 3.7.0
    WooCommerce Sequential Order Numbers Pro: by SkyVerge – 1.17.0
    WooCommerce: by Automattic – 5.4.1
    Wordfence Security: by Wordfence – 7.5.4
    Yoast SEO: by Team Yoast – 16.4
    WP-Optimize - Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.1.11
    WPFront Scroll Top: by Syam Mohan –
    ### Inactive Plugins (8) ###
    Coming Soon Page, Maintenance Mode & Landing Pages by SeedProd: by SeedProd – 6.2.4
    HashBar - WordPress Notification Bar: by HT Plugins – 1.1.9
    Jetpack: by Automattic – 9.8.1
    LiteSpeed Cache: by LiteSpeed Technologies – 3.6.4
    WooCommerce Side Cart Premium: by XootiX – 1.1
    WPSSO Core: by JS Morisset – 8.30.1
    WPSSO Schema JSON-LD Markup: by JS Morisset – 4.17.0
    WPSSO Update Manager: by JS Morisset – 2.8.0
    ### Dropin Plugins (1) ###
    advanced-cache.php: advanced-cache.php
    ### Settings ###
    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 ✔
    ### WC Pages ###
    Shop base: #45 - /shop/
    Basket: #46 - /cart/
    Checkout: #47 - /checkout/
    My account: #48 - /my-account/
    Terms and conditions: #2412 - /terms-conditions/
    ### Theme ###
    Name: Party Experts
    Version: 1.0.0
    Author URL:
    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
    WooCommerce Support: ✔
    ### Templates ###
    Overrides: partyexperts/woocommerce/archive-product.php version 2.0.0 is out of date. The core version is 3.4.0
    partyexperts/woocommerce/cart/cart.php version 3.1.0 is out of date. The core version is 3.8.0
    partyexperts/woocommerce/cart/cross-sells.php version 3.0.0 is out of date. The core version is 4.4.0
    partyexperts/woocommerce/content-product.php version 3.0.0 is out of date. The core version is 3.6.0
    partyexperts/woocommerce/content-single-product.php version 3.0.0 is out of date. The core version is 3.6.0
    partyexperts/woocommerce/global/quantity-input.php version 3.2.0 is out of date. The core version is 4.0.0
    partyexperts/woocommerce/single-product/related.php version 3.0.0 is out of date. The core version is 3.9.0
    Outdated Templates: ❌
    						Learn how to update
    ### WooCommerce Google Product Feed options ###
    Google merchant centre product feed: Enabled
    Google merchant centre product review feed: -
    Bing merchant centre feed: -
    Google merchant centre local product inventory feed: -
    Google merchant centre local products feed (legacy): -
    Google merchant centre product inventory feed (legacy): -
    Include variations in feed: No
    Send "item group ID": No
    Debug key: 6bd2ec1d-934d-44bc-af2d-e10d5484fe5b
    ### WooCommerce Google Product Feed fields ###
    Product description: Variation description only
    fallback to main description (full preferred)
    Availability: Defaults to "in stock".
    Condition: Defaults to "new".
    Brand: Pre-populates from pa_supplier taxonomy.
    Manufacturer Part Number (MPN): Pre-populates from product sku.
    Product Type: Pre-populates from product_cat taxonomy.
    Global Trade Item Number (GTIN): 
    Colour: Pre-populates from pa_colour taxonomy.
    ### WooCommerce Customer/Order/Coupon Export ###
    Automated exports: 2
    Custom formats: 3
    Next export: Not scheduled
    ### Action Scheduler ###
    Complete: 6,237
    Oldest: 2021-05-16 10:29:18 +0100
    Newest: 2021-06-16 09:48:19 +0100
    Failed: 82
    Oldest: 2020-07-03 03:04:41 +0100
    Newest: 2021-04-29 18:42:52 +0100
    Pending: 4
    Oldest: 2021-06-16 14:56:23 +0100
    Newest: 2021-06-16 17:45:50 +0100
    ### Status report information ###
    Generated at: 2021-06-16 10:29:05 +01:00

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

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Support gabrielfuentes


    Hi there 👋

    This is strange. The error says that it is looking for a column within a table that doesn’t seem to exist on your database.

    The errors indicate that is looking for a table called tpe_wc_admin_note_actions but after inspecting your System Status, I can see that it exists but with another database prefix (partyexperts_wc_admin_note_actions). So by any chance, have you recently changed your database prefix from tpe_ to partyexperts_?


    Thread Starter rsurfer


    Hi! Thanks for replying. Sorry I changed the DB prefix in my initial post thinking it might not be a good idea to reveal it, but it was in the status report anyway. Not sure what I was thinking.. The prefix is partyexperts_, I definitely haven’t changed it 🙂

    Plugin Support gabrielfuentes


    Oh, I see! No worries 🙂

    Please be sure to rerun the database update (e.g. from WooCommerce > Status > Tools > Update database)

    Another option is to go to WooCommerce > Status > Tools and select the tool for Verify Database Tables – this can verify the DB tables and make sure they are correct.

    Let us know how it goes!

    Thread Starter rsurfer


    Thanks, verifying the database tables returned an OK. Updating the DB doesn’t seem to have made a difference unfortunately – the same errors are still being written to the error log file.

    I took a look in the wc_admin_note_actions table and noticed the note_id’s referenced in the errors don’t exist. I don’t know if that helps at all.

    Can you think of anything else I could try to stop these errors?

    Appreciate your help so far.

    Hi @gabrielfuentes,

    Any solution to this issue? I am having the same problem.

    WooCommerce > Status > Tools > Update database

    remember to make backup of database first



    Hi @stan97

    Thanks for replying, mate. But I’ve tried all those suggestions, and I still getting this error logged into my error_log file.

    I’ve verified the database, updated the database. I’ve also checked the DB user has all privileges – checked for appropriate file permission, and I still have this issue logged.

    Not sure what’s happening.



    And my guess would be because of this plugin “WooCommerce Admin”?



    that might be, I don’t use this plugin since there always were some troubles with it.

    my solution with updating database worked for me, I checked database before and ‘nonce…’ columns were missing, after DB update those columns appeared and error stopped showing up.

    • This reply was modified 7 months ago by Stas.

    We are also seeing this issue on our sites, I tracked down the cause for this to be:, which introduces database schema changes on install, but no update for it.

    Thanks @bogdanarizancu for linking the GitHub issue here. Got the same problem, hope it will be fixed soon.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Repeating database error Unknown column ‘nonce_action’’ is closed to new replies.