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): 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 Gabriel – a11n
(@gabrielfuentes)

3 years, 6 months ago
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!
- This reply was modified 3 years, 6 months ago by Gabriel - a11n.
Thread Starter rsurfer
(@rsurfer)

3 years, 6 months ago

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 Gabriel – a11n
(@gabrielfuentes)

3 years, 6 months ago

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)

3 years, 6 months ago

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.

jeff0504
(@jeff0504)

3 years, 5 months ago

Hi @gabrielfuentes,

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

Stas
(@stan97)

3 years, 5 months ago

@jeff0504
WooCommerce > Status > Tools > Update database

remember to make backup of database first

jeff0504
(@jeff0504)

3 years, 5 months ago

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.

jeff0504
(@jeff0504)

3 years, 5 months ago

And my guess would be because of this plugin “WooCommerce Admin”?
Stas
(@stan97)

3 years, 5 months ago
@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 3 years, 5 months ago by Stas.
bogdanarizancu
(@bogdanarizancu)

3 years, 5 months ago

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.

Serhiy Zakharchenko
(@zahardoc)

3 years, 5 months ago

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.