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

  • Resolved rsurfer

    (@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): https://www.thepartyexperts.co.uk
    Site address (URL): https://www.thepartyexperts.co.uk
    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
    OpenSSL/1.1.1k
    
    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 megamenu.com – 2.2.2
    Max Mega Menu: by megamenu.com – 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 WebPerfect.com – 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 – 2.0.4.04013
    
    ### 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 WooCommerce.com: ✔
    
    ### 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: https://randomsurfer.net/
    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-shipping.php
    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/loop/price.php
    partyexperts/woocommerce/single-product/add-to-cart/simple.php
    partyexperts/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
    partyexperts/woocommerce/single-product/meta.php
    partyexperts/woocommerce/single-product/related.php version 3.0.0 is out of date. The core version is 3.9.0
    partyexperts/woocommerce/single-product/up-sells.php
    partyexperts/woocommerce/single-product.php
    
    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

    (@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_?

    Thanks!

    Thread Starter rsurfer

    (@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

    (@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

    (@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.

    @jeff0504
    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”?

    @jeff0504
    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 5 months, 1 week ago by Stas.
    bogdanarizancu

    (@bogdanarizancu)

    We are also seeing this issue on our sites, I tracked down the cause for this to be: https://github.com/woocommerce/woocommerce-admin/pull/6726, 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)
  • You must be logged in to reply to this topic.