• Resolved spurs123

    (@spurs123)


    We are getting PHP error logs building up everyday. When we look at the logs is says the following below It has been suggested that Woocommerce forgot to add the column, ‘nonce_action’, back in on one of their updates. Can you correct this and add it back in on the next update as the file size of the error logs is getting very large and using the space up on our server.
    If this can’t be done, is it safe for us to add this column back in ourselves, which is not want we want to do.

    [14-Jan-2022 15:48:24 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 wp_wc_admin_note_actions
                                                              WHERE note_id = 8 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, Automattic\WooCommerce\Admin\Notes\Notes::get_note, Automattic\WooCommerce\Admin\Notes\Note->__construct, WC_Data_Store->read, Automattic\WooCommerce\Admin\Notes\DataStore->read, Automattic\WooCommerce\Admin\Notes\DataStore->read_actions, QM_DB->query
    [14-Jan-2022 15:48:24 UTC] WordPress database error Unknown column 'is_read' in 'field list' for query UPDATE <code>wp_wc_admin_notes</code> SET <code>name</code> = 'woocommerce-services', <code>type</code> = 'info', <code>locale</code> = 'en_US', <code>title</code> = 'WooCommerce Shipping & Tax', <code>content</code> = 'WooCommerce Shipping & Tax helps get your store a€?ready to sella€? as quickly as possible. You create your products. We take care of tax calculation, payment processing, and shipping label printing! Learn more about the extension that you just installed.', <code>content_data</code> = '{}', <code>status</code> = 'pending', <code>source</code> = 'woocommerce.com', <code>date_created</code> = '2020-03-29 01:56:15', <code>date_reminder</code> = NULL, <code>is_snoozable</code> = '0', <code>layout</code> = 'plain', <code>image</code> = '', <code>is_deleted</code> = '', <code>is_read</code> = '' WHERE <code>note_id</code> = '8' 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, QM_DB->query
    [14-Jan-2022 15:48:24 UTC] WordPress database error Unknown column 'nonce_action' in 'field list' for query REPLACE INTO <code>wp_wc_admin_note_actions</code> (<code>note_id</code>, <code>name</code>, <code>label</code>, <code>query</code>, <code>status</code>, <code>is_primary</code>, <code>actioned_text</code>, <code>nonce_action</code>, <code>nonce_name</code>) VALUES (8, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox', 'unactioned', 1, '', NULL, NULL) 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, QM_DB->query
    [14-Jan-2022 15:48:24 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 wp_wc_admin_note_actions
                                                              WHERE note_id = 8 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, QM_DB->query
    [14-Jan-2022 15:48:24 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 wp_wc_admin_note_actions
                                                              WHERE note_id = 9 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, Automattic\WooCommerce\Admin\Notes\Notes::get_note, Automattic\WooCommerce\Admin\Notes\Note->__construct, WC_Data_Store->read, Automattic\WooCommerce\Admin\Notes\DataStore->read, Automattic\WooCommerce\Admin\Notes\DataStore->read_actions, QM_DB->query
    [14-Jan-2022 15:48:24 UTC] WordPress database error Unknown column 'is_read' in 'field list' for query UPDATE <code>wp_wc_admin_notes</code> SET <code>name</code> = 'ecomm-unique-shopping-experience', <code>type</code> = 'info', <code>locale</code> = 'en_US', <code>title</code> = 'For a shopping experience as unique as your customers', <code>content</code> = 'Product Add-Ons allow your customers to personalize products while theya€?re shopping on your online store. No more follow-up email requestsa€”customers get what they want, before theya€?re done checking out. Learn more about this extension that comes included in your plan.', <code>content_data</code> = '{}', <code>status</code> = 'pending', <code>source</code> = 'woocommerce.com', <code>date_created</code> = '2020-03-29 01:56:15', <code>date_reminder</code> = NULL, <code>is_snoozable</code> = '0', <code>layout</code> = 'plain', <code>image</code> = '', <code>is_deleted</code> = '', <code>is_read</code> = '' WHERE <code>note_id</code> = '9' 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, QM_DB->query
    [14-Jan-2022 15:48:24 UTC] WordPress database error Unknown column 'nonce_action' in 'field list' for query REPLACE INTO <code>wp_wc_admin_note_actions</code> (<code>note_id</code>, <code>name</code>, <code>label</code>, <code>query</code>, <code>status</code>, <code>is_primary</code>, <code>actioned_text</code>, <code>nonce_action</code>, <code>nonce_name</code>) VALUES (9, 'learn-more-ecomm-unique-shopping-experience', 'Learn more', 'https://docs.woocommerce.com/document/product-add-ons/?utm_source=inbox', 'actioned', 1, '', NULL, NULL) 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, QM_DB->query
    [14-Jan-2022 15:48:24 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 wp_wc_admin_note_actions
                                                              WHERE note_id = 9 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, QM_DB->query
    [14-Jan-2022 15:48:24 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

    Thanks

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Sérgio L. a11n

    (@csnlima)

    Hi @spurs123!

    As a first step, to get a better understanding of your setup, could you please share a copy of your site’s System Status?

    You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Thanks

    Thread Starter spurs123

    (@spurs123)

    Hi,
    Here it is:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://eurekavideo.co.uk
    Site address (URL): https://eurekavideo.co.uk
    WC Version: 6.1.0
    REST API Version: ? 6.1.0
    WC Blocks Version: ? 6.5.1
    Action Scheduler Version: ? 3.4.0
    WC Admin Version: ? 3.0.3
    Log Directory Writable: ?
    WP Version: 5.8.3
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.27
    PHP Post Max Size: 512 MB
    PHP Time Limit: 900
    PHP Max Input Vars: 3000
    cURL Version: 7.81.0
    OpenSSL/1.1.1m
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.0.38-MariaDB
    Max Upload Size: 512 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.1.0
    WC Database Prefix: wp_
    Total Database Size: 1980.25MB
    Database Data Size: 1524.24MB
    Database Index Size: 456.01MB
    wp_woocommerce_sessions: Data: 624.47MB + Index: 13.16MB + 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: 11.52MB + Index: 4.52MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 76.63MB + Index: 67.19MB + 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.03MB + 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.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    legacy: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    orders: Data: 0.00MB + Index: 0.00MB + Engine
    preorders: Data: 0.00MB + Index: 0.00MB + Engine
    vw_join: Data: 0.00MB + Index: 0.00MB + Engine
    wpstg0_atum_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_atum_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_atum_product_data: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpstg0_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_comments: Data: 2.52MB + Index: 1.27MB + Engine InnoDB
    wpstg0_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpstg0_hustle_modules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_hustle_modules_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpstg0_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpstg0_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpstg0_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_options: Data: 2.52MB + Index: 0.08MB + Engine InnoDB
    wpstg0_postmeta: Data: 22.56MB + Index: 10.03MB + Engine InnoDB
    wpstg0_posts: Data: 4.52MB + Index: 0.73MB + Engine InnoDB
    wpstg0_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpstg0_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_term_relationships: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
    wpstg0_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_UPCP_Catalogues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Catalogue_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Custom_Fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Fields_Meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Item_Images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_SubCategories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Tagged_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Tags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Tag_Groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_UPCP_Videos: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_usermeta: Data: 4.52MB + Index: 3.03MB + Engine InnoDB
    wpstg0_users: Data: 0.22MB + Index: 0.20MB + Engine InnoDB
    wpstg0_vtprd_purchase_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_vtprd_purchase_log_product: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_vtprd_purchase_log_product_rule: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wcpdf_credit_note_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wcpdf_packing_slip_number: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
    wpstg0_wcpdf_proforma_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_wc_product_meta_lookup: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
    wpstg0_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpstg0_wdp_orders: Data: 0.11MB + Index: 0.05MB + Engine MyISAM
    wpstg0_wdp_order_items: Data: 0.17MB + Index: 0.15MB + Engine MyISAM
    wpstg0_wdp_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wfblockediplog: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpstg0_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wfconfig: Data: 0.38MB + Index: 0.01MB + Engine MyISAM
    wpstg0_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wffilemods: Data: 1.71MB + Index: 0.35MB + Engine MyISAM
    wpstg0_wfhits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wfissues: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpstg0_wfknownfilelist: Data: 0.93MB + Index: 0.10MB + Engine MyISAM
    wpstg0_wflivetraffichuman: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
    wpstg0_wflocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wflogins: Data: 0.14MB + Index: 0.03MB + Engine MyISAM
    wpstg0_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpstg0_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpstg0_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wfpendingissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpstg0_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_wfstatus: Data: 0.07MB + Index: 0.03MB + Engine MyISAM
    wpstg0_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpstg0_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpstg0_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpstg0_woocommerce_order_itemmeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
    wpstg0_woocommerce_order_items: Data: 0.50MB + Index: 0.17MB + Engine InnoDB
    wpstg0_woocommerce_order_preoder_split: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
    wpstg0_woocommerce_order_preorder_release_prereq: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_woocommerce_order_preorder_release_prereq_order: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_woocommerce_order_preorder_split_prereq: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_woocommerce_order_reporting_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpstg0_woocommerce_sessions: Data: 0.42MB + Index: 0.02MB + Engine InnoDB
    wpstg0_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpstg0_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpstg0_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpstg0_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpstg0_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_yoast_seo_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpstg0_yoast_seo_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_actions: Data: 8.05MB + Index: 4.05MB + Engine MyISAM
    wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_actionscheduler_logs: Data: 12.62MB + Index: 10.44MB + Engine MyISAM
    wp_aioseo_notifications: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_aioseo_posts: Data: 1.19MB + Index: 0.10MB + Engine MyISAM
    wp_atum_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_atum_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_atum_product_data: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 23.56MB + Index: 15.09MB + Engine InnoDB
    wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gdpr_cc_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_hustle_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_hustle_entries_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_hustle_modules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_hustle_modules_meta: Data: 0.16MB + Index: 0.01MB + Engine MyISAM
    wp_hustle_tracking: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_options: Data: 5.36MB + Index: 2.06MB + Engine InnoDB
    wp_postmeta: Data: 109.66MB + Index: 66.20MB + Engine InnoDB
    wp_posts: Data: 27.55MB + Index: 9.92MB + Engine InnoDB
    wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_UPCP_Catalogues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Catalogue_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Custom_Fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Fields_Meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Item_Images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_SubCategories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Tagged_Items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Tags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Tag_Groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_UPCP_Videos: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_usermeta: Data: 46.58MB + Index: 32.66MB + Engine InnoDB
    wp_users: Data: 2.52MB + Index: 1.16MB + Engine InnoDB
    wp_vtprd_purchase_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_vtprd_purchase_log_product: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_vtprd_purchase_log_product_rule: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wccs_conditions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wccs_condition_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wcpdf_credit_note_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wcpdf_packing_slip_number: Data: 1.03MB + Index: 0.51MB + Engine MyISAM
    wp_wcpdf_proforma_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wp_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_customer_lookup: Data: 0.84MB + Index: 0.67MB + Engine MyISAM
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_product_lookup: Data: 1.16MB + Index: 1.08MB + Engine MyISAM
    wp_wc_order_stats: Data: 0.45MB + Index: 0.36MB + Engine MyISAM
    wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_meta_lookup: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
    wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_reserved_stock: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
    wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wdp_orders: Data: 1.58MB + Index: 0.67MB + Engine MyISAM
    wp_wdp_order_items: Data: 2.72MB + Index: 2.38MB + Engine MyISAM
    wp_wdp_rules: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wp_wfblockediplog: Data: 4.39MB + Index: 3.52MB + Engine MyISAM
    wp_wfblocks7: Data: 5.51MB + Index: 3.33MB + Engine MyISAM
    wp_wfconfig: Data: 0.40MB + Index: 0.01MB + Engine MyISAM
    wp_wfcrawlers: Data: 0.14MB + Index: 0.08MB + Engine MyISAM
    wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wffilemods: Data: 1.43MB + Index: 0.21MB + Engine MyISAM
    wp_wfhits: Data: 380.60MB + Index: 81.09MB + Engine MyISAM
    wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfissues: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wfknownfilelist: Data: 0.75MB + Index: 0.09MB + Engine MyISAM
    wp_wflivetraffichuman: Data: 38.78MB + Index: 54.34MB + Engine MyISAM
    wp_wflocs: Data: 0.62MB + Index: 0.15MB + Engine MyISAM
    wp_wflogins: Data: 16.36MB + Index: 3.49MB + Engine MyISAM
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfreversecache: Data: 0.45MB + Index: 0.13MB + Engine MyISAM
    wp_wfsnipcache: Data: 0.82MB + Index: 1.26MB + Engine MyISAM
    wp_wfstatus: Data: 0.12MB + Index: 0.05MB + Engine MyISAM
    wp_wftrafficrates: Data: 68.78MB + Index: 55.38MB + Engine MyISAM
    wp_woocommerce_order_preoder_split: Data: 1.13MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_preorder_release_prereq: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_preorder_release_prereq_order: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_preorder_split_prereq: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_reporting_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yoast_seo_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yoast_seo_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    acf-field: 53
    acf-field-group: 8
    attachment: 1642
    custom_css: 1
    customize_changeset: 3
    jetpack_migration: 2
    jp_img_sitemap: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    movie: 423
    nav_menu_item: 5
    o-discount: 1
    o-list: 1
    page: 31
    post: 177
    product: 464
    revision: 2301
    rl_gallery: 1
    shop_coupon: 11
    shop_order: 53789
    shop_order_refund: 507
    vtprd-rule: 1
    woo_discount: 1
    woo_discount_cart: 1
    wpcf7_contact_form: 1
    ywdpd_discount: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (26) ###
    
    Query Monitor: by John Blackbourn – 3.8.2
    ACF: Better Search: by Mateusz Gbiorczyk – 4.0.0
    Additional Order Filters for WooCommerce: by Anton Bond – 1.10
    Admin Menu Editor: by Janis Elsts – 1.10
    Advanced Coupons for WooCommerce Free: by Rymera Web Co – 3.0.2
    Advanced Custom Fields PRO: by Delicious Brains – 5.11.4
    Advanced Dynamic Pricing for WooCommerce: by AlgolPlus – 3.3.2
    Contact Form 7 iContact Extension: by Renzo Johnson – 0.5.25
    Classic Editor: by WordPress Contributors – 1.6.2
    Contact Form 7: by Takayuki Miyoshi – 5.5.3
    WooCommerce Discontinued Products: by Leon @ 211J – 1.1.5
    GDPR Cookie Compliance: by Moove Agency – 4.7.2
    Login No Captcha reCAPTCHA (Google): by Robert Peake and Contributors – 1.6.11
    Responsive Lightbox & Gallery: by dFactory – 2.3.3
    WooCommerce WorldPay Gateway: by Andrew Benbow – 4.0.1
    WooCommerce Pixel Manager: by woopt – 1.12.4
    WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.12.1
    WooCommerce PDF Invoices & Packing Slips Professional: by Ewout Fernhout – 2.2.11
    WooCommerce Social Login: by SkyVerge – 2.11.0
    WooCommerce: by Automattic – 6.1.0
    Wordfence Security: by Wordfence – 7.5.7
    Hustle: by WPMU DEV – 7.4.11
    WP Mail SMTP: by WPForms – 3.2.1
    WP Maintenance Mode: by Designmodo – 2.4.1
    WPS Hide Login: by WPServeur
    NicolasKulka
    wpformation – 1.9.3
    
    YITH Pre-Order for WooCommerce Premium: by YITH – 1.5.7
    
    ### Inactive Plugins (3) ###
    
    WooCommerce Extended Coupon Features FREE: by Soft79 – 3.2.8
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.20
    Worldpay Online Payments: by Worldpay
    WooCommerce
    Andrew Benbow – 2.0.3
    
    ### Dropin Plugins (2) ###
    
    db.php: Query Monitor Database Class
    maintenance.php: maintenance.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: #36 - /shop/
    Basket: #37 - /basket/
    Checkout: #38 - /checkout/
    My account: #39 - /my-account/
    Terms and conditions: #9 - /terms-of-use/
    
    ### Theme ###
    
    Name: E-2018
    Version: (update to version 0 is available)
    Author URL: https://twitter.com/duckbox
    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: ? Not declared
    
    ### Templates ###
    
    Overrides: E-2018/woocommerce/cart/cart.php
    E-2018/woocommerce/checkout/form-billing.php
    E-2018/woocommerce/checkout/terms.php
    E-2018/woocommerce/emails/customer-completed-order.php
    E-2018/woocommerce/emails/customer-invoice.php
    E-2018/woocommerce/emails/customer-new-account.php version 3.7.0 is out of date. The core version is 6.0.0
    E-2018/woocommerce/emails/customer-note.php
    E-2018/woocommerce/emails/customer-on-hold-order.php
    E-2018/woocommerce/emails/customer-processing-order.php
    E-2018/woocommerce/emails/customer-reset-password.php
    E-2018/woocommerce/emails/email-header.php
    E-2018/woocommerce/emails/email-styles.php
    
    Outdated Templates: ?
    					
    					
    						Learn how to update
    
    ### Social Login ###
    
    Facebook: ? Available
    Twitter: Disabled
    Google: Disabled
    Amazon: Disabled
    Linkedin: Disabled
    Paypal: Disabled
    Disqus: Disabled
    Yahoo: Disabled
    Vkontakte: Disabled
    
    ### Action Scheduler ###
    
    Canceled: 35,152
    Oldest: -0001-11-29 23:58:45 -0001
    Newest: -0001-11-29 23:58:45 -0001
    
    Complete: 846
    Oldest: 2020-09-11 15:16:17 +0100
    Newest: 2022-01-14 13:54:18 +0000
    
    Pending: 8
    Oldest: -0001-11-29 23:58:45 -0001
    Newest: 2022-01-18 15:19:43 +0000
    
    ### Status report information ###
    
    Generated at: 2022-01-18 15:21:48 +00:00
    
    Mirko P.

    (@rainfallnixfig)

    Hi there ??

    Thanks for sharing your system status.

    This seems to be a known issue with the WooCommerce Admin plugin which introduces database schema changes on install and it was reported in Github:

    https://github.com/woocommerce/woocommerce-admin/pull/6726

    A possible fix is to add the columns directly via SQL, there is an example here:

    https://github.com/woocommerce/woocommerce-admin/pull/6726#issuecomment-973900351

    If you require further inputs I’d suggest that you post your comments directly in Github and subscribe to the Github thread to follow updates.

    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘PHP ERROR LOGS’ is closed to new replies.