Title: Posts and Preview saving very slow (Db tables missing _wc_admin_notes)
Last modified: July 26, 2021

---

# Posts and Preview saving very slow (Db tables missing _wc_admin_notes)

 *  Resolved [andrewmperryman](https://wordpress.org/support/users/andrewmperryman/)
 * (@andrewmperryman)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/posts-saving-slow-db-tables-missing-_wc_admin_notes/)
 * Hello,
 * My site is a fresh new install and was super fast before my woocommerce plugin
   install. I only have a few plugins.
 * two days ago, I started to install your latest woocommerce version 5.5.2
    I stopped
   and removed the plugin after accepting too many additional extensions (e.g. mailpoet,
   newsletter and more). The reason I deactivated and deleted the plugin is because
   my site ground to a halt with the load of the other plugins.
 * So I started from a clean slate and reinstalled your plugin from scratch after
   cleaning up removing the additional plugins and clearing the Db with WP-optimise..
 * Now I am at a stage where my wordpress site has an issue when saving a post or
   previewing a post, however the main admin panel works and its response is fine.
   I have just setup a woocommerce shop and I am adding products.
 * The posts take ages to save or load the preview so I decided to install Query
   Monitor to take a look.
 * I found that there are complaints of one table in particular missing
    _wc_admin_notes..
 * “Table ‘**************.chb_wc_admin_notes’ doesn’t exist”
 * 11 Db errors of the same completing different actions on the same table..
 * So I took a look at PHPMYadmin and found that there are a few other tables missing
   too but I am not sure what ones should exist as it depends on what sections I
   setup.
 * I also seem to be missing wp_wc_admin_note_actions..
 * I realise I would have to change the wp_ to chb_ as from the above example.
 * In Status / tools / I have run a Db validation and a Db upgrade routine. Db validation
   came back fine but the Db update has not run fully yet as it is running in the
   background.
 * is it safe to add import the tables below after adding it to a text file and 
   renaming the text to a-filename.sql. or is that bad practice?
 * Do you have a list of Db import files to upload to SQL just in case the table
   exists but didn’t get cleared down successfully and has left remnants and hence
   not allowed the table above to install?
 * The table below is form a post referring to version 4.0. as said above I am on
   V5.5.2.
    [https://wordpress.org/support/topic/wordpress-database-error-table-during-upgrade-to-4-0/](https://wordpress.org/support/topic/wordpress-database-error-table-during-upgrade-to-4-0/)
 * I don’t want to import this just in case the tables content have changed in version
   5.5.2
 * I am stuck at the moment as I have notice of 11 Db errors trying to access the
   first table mentioned above and believe this is why my saving functionality is
   trashed.
 * Can you assist and help advise what to do next?
 * Thanks in advance.
 * Andrew
 *     ```
       CREATE TABLE IF NOT EXISTS wp_wc_admin_notes (
       note_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
       name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
       type varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
       locale varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
       title longtext COLLATE utf8mb4_unicode_ci NOT NULL,
       content longtext COLLATE utf8mb4_unicode_ci NOT NULL,
       icon varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
       content_data longtext COLLATE utf8mb4_unicode_ci,
       status varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
       source varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
       date_created datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
       date_reminder datetime DEFAULT NULL,
       is_snoozable tinyint(1) NOT NULL DEFAULT ‘0’,
       PRIMARY KEY (note_id)
       ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
   
       CREATE TABLE IF NOT EXISTS wp_wc_admin_note_actions (
       action_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
       note_id bigint(20) unsigned NOT NULL,
       name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
       label varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
       query longtext COLLATE utf8mb4_unicode_ci NOT NULL,
       status varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
       is_primary tinyint(1) NOT NULL DEFAULT ‘0’,
       PRIMARY KEY (action_id),
       KEY note_id (note_id)
       ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
       ```
   
    -  This topic was modified 4 years, 9 months ago by [andrewmperryman](https://wordpress.org/support/users/andrewmperryman/).
    -  This topic was modified 4 years, 9 months ago by [andrewmperryman](https://wordpress.org/support/users/andrewmperryman/).
    -  This topic was modified 4 years, 9 months ago by [andrewmperryman](https://wordpress.org/support/users/andrewmperryman/).
    -  This topic was modified 4 years, 9 months ago by [andrewmperryman](https://wordpress.org/support/users/andrewmperryman/).

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

 *  Thread Starter [andrewmperryman](https://wordpress.org/support/users/andrewmperryman/)
 * (@andrewmperryman)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/posts-saving-slow-db-tables-missing-_wc_admin_notes/#post-14703121)
 * Support report info below and a list of Db errors added for the above initial
   post.
 * Plus I have excluded the three main pages from cache plugin. Basket/checkout/
   my-account.
 *     ```
       SELECT *
       FROM chb_wc_admin_notes
       WHERE 1=1
       AND type IN ('survey')
       AND status IN ('actioned')
       AND is_deleted = 0
       ORDER BY date_created DESC
       LIMIT 0, 10	
   
       Automattic\W\A\N\DataStore->get_notes()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_notes' doesn't exist	1146
       SELECT note_id
       FROM chb_wc_admin_notes
       WHERE name = 'wc-admin-wc-helper-connection'
       ORDER BY note_id ASC	
   
       Automattic\W\A\N\DataStore->get_notes_with_name()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_notes' doesn't exist	1146
   
       SELECT note_id
       FROM chb_wc_admin_notes
       WHERE name = 'wc-admin-wc-helper-connection'
       ORDER BY note_id ASC	
       Automattic\W\A\N\DataStore->get_notes_with_name()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_notes' doesn't exist	1146
   
       SELECT note_id
       FROM chb_wc_admin_notes
       WHERE name = 'wc-admin-wc-helper-subscription'
       ORDER BY note_id ASC	
       Automattic\W\A\N\DataStore->get_notes_with_name()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_notes' doesn't exist	1146
   
       SHOW FULL COLUMNS
       FROM <code>chb_wc_admin_notes</code>	
       Automattic\W\A\N\DataStore->create()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_notes' doesn't exist	1146
   
       DELETE
       FROM chb_wc_admin_note_actions
       WHERE note_id = 0	
       Automattic\W\A\N\DataStore->save_actions()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_note_actions' doesn't exist	
   
       1146
       SHOW FULL COLUMNS
       FROM <code>chb_wc_admin_note_actions</code>	
       Automattic\W\A\N\DataStore->save_actions()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_note_actions' doesn't exist	
   
       1146
       SELECT action_id, name, label, query, status, is_primary, actioned_text, nonce_action, nonce_name
       FROM chb_wc_admin_note_actions
       WHERE note_id = 0	
       Automattic\W\A\N\DataStore->read_actions()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_note_actions' doesn't exist	1146
   
       SELECT note_id
       FROM chb_wc_admin_notes
       WHERE name = 'wc-update-db-reminder'
       ORDER BY note_id ASC	
       Automattic\W\A\N\DataStore->get_notes_with_name()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_notes' doesn't exist	1146
   
       SELECT COUNT(*)
       FROM chb_wc_admin_notes
       WHERE 1=1
       AND type IN ('error','update')
       AND status IN ('unactioned')
       AND is_deleted = 0	
       Automattic\W\A\N\DataStore->get_notes_count()
       Plugin: woocommerce	Table 'dbsshefjreungw.chb_wc_admin_notes' doesn't exist	1146
       ```
   
 * ### WordPress Environment ###
 * WordPress address (URL): [https://revamp-atelier.fr](https://revamp-atelier.fr)
   
   Site address (URL): [https://revamp-atelier.fr](https://revamp-atelier.fr) WC
   Version: 5.5.2 REST API Version: ✔ 5.5.2 WC Blocks Version: ✔ 5.3.3 Action Scheduler
   Version: ✔ 3.2.1 WC Admin Version: ✔ 2.4.4 Log Directory Writable: ✔ WP Version:
   5.8 WP Multisite: – WP Memory Limit: 768 MB WP Debug Mode: – WP Cron: ✔ Language:
   en_GB External object cache: ✔
 * ### Server Environment ###
 * Server Info: Apache
    PHP Version: 7.4.21 PHP Post Max Size: 256 MB PHP Time Limit:
   120 PHP Max Input Vars: 3000 cURL Version: 7.66.0 OpenSSL/1.1.1k-fips
 * SUHOSIN Installed: –
    MySQL Version: 5.7.32-35-log Max Upload Size: 256 MB Default
   Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte
   String: ✔ Remote Post: ✔ Remote Get: ✔
 * ### Database ###
 * WC Database Version: 5.5.2
    WC Database Prefix: chb_ Total Database Size: 10.67MB
   Database Data Size: 8.52MB Database Index Size: 2.15MB chb_woocommerce_sessions:
   Data: 0.02MB + Index: 0.02MB + Engine InnoDB chb_woocommerce_api_keys: Data: 
   0.02MB + Index: 0.03MB + Engine InnoDB chb_woocommerce_attribute_taxonomies: 
   Data: 0.02MB + Index: 0.02MB + Engine InnoDB chb_woocommerce_downloadable_product_permissions:
   Data: 0.02MB + Index: 0.06MB + Engine InnoDB chb_woocommerce_order_items: Data:
   0.02MB + Index: 0.02MB + Engine InnoDB chb_woocommerce_order_itemmeta: Data: 
   0.02MB + Index: 0.03MB + Engine InnoDB chb_woocommerce_tax_rates: Data: 0.02MB
   + Index: 0.06MB + Engine InnoDB chb_woocommerce_tax_rate_locations: Data: 0.02MB
   + Index: 0.03MB + Engine InnoDB chb_woocommerce_shipping_zones: Data: 0.02MB 
   + Index: 0.00MB + Engine InnoDB chb_woocommerce_shipping_zone_locations: Data:
   0.02MB + Index: 0.03MB + Engine InnoDB chb_woocommerce_shipping_zone_methods:
   Data: 0.02MB + Index: 0.00MB + Engine InnoDB chb_woocommerce_payment_tokens: 
   Data: 0.02MB + Index: 0.02MB + Engine InnoDB chb_woocommerce_payment_tokenmeta:
   Data: 0.02MB + Index: 0.03MB + Engine InnoDB chb_woocommerce_log: Data: 0.02MB
   + Index: 0.02MB + Engine InnoDB chb_actionscheduler_actions: Data: 0.08MB + Index:
   0.13MB + Engine InnoDB chb_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB
   + Engine InnoDB chb_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine
   InnoDB chb_actionscheduler_logs: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
   chb_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB chb_ce4wp_contacts:
   Data: 0.02MB + Index: 0.02MB + Engine InnoDB chb_commentmeta: Data: 0.02MB + 
   Index: 0.03MB + Engine InnoDB chb_comments: Data: 0.02MB + Index: 0.09MB + Engine
   InnoDB chb_gdpr_cc_consentlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB chb_gdpr_cc_geoip:
   Data: 0.02MB + Index: 0.00MB + Engine InnoDB chb_gdpr_cc_options: Data: 0.05MB
   + Index: 0.00MB + Engine InnoDB chb_gla_budget_recommendations: Data: 0.20MB 
   + Index: 0.11MB + Engine InnoDB chb_gla_merchant_issues: Data: 0.02MB + Index:
   0.02MB + Engine InnoDB chb_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB +
   Engine InnoDB chb_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
   chb_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB chb_mailchimp_carts: 
   Data: 0.02MB + Index: 0.00MB + Engine InnoDB chb_mailchimp_jobs: Data: 0.02MB
   + Index: 0.00MB + Engine InnoDB chb_options: Data: 2.52MB + Index: 0.06MB + Engine
   InnoDB chb_postmeta: Data: 1.44MB + Index: 0.14MB + Engine InnoDB chb_posts: 
   Data: 2.36MB + Index: 0.06MB + Engine InnoDB chb_sgs_log_events: Data: 0.48MB
   + Index: 0.00MB + Engine InnoDB chb_sgs_log_visitors: Data: 0.02MB + Index: 0.00MB
   + Engine InnoDB chb_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB chb_terms:
   Data: 0.02MB + Index: 0.03MB + Engine InnoDB chb_term_relationships: Data: 0.02MB
   + Index: 0.02MB + Engine InnoDB chb_term_taxonomy: Data: 0.02MB + Index: 0.03MB
   + Engine InnoDB chb_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
   chb_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB chb_trp_dictionary_en_gb_fr_fr:
   Data: 0.06MB + Index: 0.05MB + Engine InnoDB chb_trp_gettext_en_gb: Data: 0.27MB
   + Index: 0.34MB + Engine InnoDB chb_trp_gettext_en_us: Data: 0.02MB + Index: 
   0.05MB + Engine InnoDB chb_trp_gettext_fr_fr: Data: 0.08MB + Index: 0.05MB + 
   Engine InnoDB chb_trp_original_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
   chb_trp_original_strings: Data: 0.05MB + Index: 0.02MB + Engine InnoDB chb_usermeta:
   Data: 0.02MB + Index: 0.03MB + Engine InnoDB chb_users: Data: 0.02MB + Index:
   0.05MB + Engine InnoDB chb_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine
   InnoDB chb_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
   chb_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB chb_wc_tax_rate_classes:
   Data: 0.02MB + Index: 0.02MB + Engine InnoDB chb_wc_webhooks: Data: 0.02MB + 
   Index: 0.02MB + Engine InnoDB
 * ### Post Type Counts ###
 * attachment: 184
    contx_post_type: 7 custom_css: 1 customize_changeset: 24 frm_form_actions:
   2 frm_styles: 1 language_switcher: 3 mailpoet_page: 1 nav_menu_item: 6 nimble_post_type:
   6 nimble_section: 9 nimble_template: 1 oembed_cache: 2 page: 8 post: 18 product:
   20 revision: 59 wp_block: 1 wpforms: 1
 * ### Security ###
 * Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
 * ### Active Plugins (14) ###
 * Query Monitor: by John Blackbourn – 3.7.1
    Advanced noCaptcha & invisible Captcha:
   by Shamim Hasan – 6.1.5 GDPR Cookie Compliance – Premium Add-On: by Moove Agency–
   3.0.7 GDPR Cookie Compliance (CCPA, PIPEDA ready): by Moove Agency – 4.5.8 GDPR
   Data Request Form: by audrasjb – 1.5 Health Check & Troubleshooting: by The WordPress.
   org community – 1.4.5 Nimble Builder Pro: by Press Customizr – 1.0.14 Nimble 
   Page Builder: by Press Customizr – 3.1.20 Regenerate Thumbnails: by Alex Mills(
   Viper007Bond) – 3.1.5 SiteGround Optimizer: by SiteGround – 5.8.2 SG Security:
   by SiteGround – 1.0.4 WooCommerce PayPal Payments: by WooCommerce – 1.3.2 WooCommerce:
   by Automattic – 5.5.2 WP Crontrol: by John Blackbourn & contributors – 1.10.0
 * ### Inactive Plugins (2) ###
 * TranslatePress – Multilingual: by Cozmoslabs
    Razvan Mocanu Madalin Ungureanu
   Cristophor Hurduban – 2.0.5
 * Widget Disable: by required – 2.0.0
 * ### Dropin Plugins (2) ###
 * db.php: Query Monitor Database Class
    object-cache.php: Memcached
 * ### Must Use Plugins (1) ###
 * Health Check Troubleshooting Mode: by – 1.7.2
 * ### Settings ###
 * API Enabled: –
    Force SSL: – Currency: EUR (€) 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: #4068 – /shop/
    Basket: #4069 – /basket/ Checkout: #4070 – /checkout/
   My account: #4071 – /my-account/ Terms and conditions: #4171 – /terms-and-conditions-
   cgv/
 * ### Theme ###
 * Name: huemanchild
    Version: 1.0 Author URL: Child Theme: ✔ Parent Theme Name:
   Hueman Pro Parent Theme Version: 1.4.13 Parent Theme Author URL: [http://presscustomizr.com](http://presscustomizr.com)
   WooCommerce Support: ✔
 * ### Templates ###
 * Overrides: –
 * ### Action Scheduler ###
 * Complete: 193
    Oldest: 2021-06-26 17:30:14 +0200 Newest: 2021-07-26 19:56:20 
   +0200
 * Pending: 2
    Oldest: 2021-07-27 00:10:07 +0200 Newest: 2021-07-27 00:10:07 +0200
 * ### Status report information ###
 * Generated at: 2021-07-26 20:17:38 +02:00
    `
 *  [3 Sons Development](https://wordpress.org/support/users/3sonsdevelopment/)
 * (@3sonsdevelopment)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/posts-saving-slow-db-tables-missing-_wc_admin_notes/#post-14730470)
 * Hey [@andrewmperryman](https://wordpress.org/support/users/andrewmperryman/),
 * Typically speaking you can deactivate WooCommerce and then activate it again 
   to create any missing database tables. It has a routine that runs to make sure
   they are all installed upon activation.
 * If you want to do it manually, you’d probably want to clone the site and then
   give it a try on the staging site first to make sure it all works. If it was 
   my site, I’d try the deactivate/activate WooCommerce route first.
 * Best of luck
 *  Thread Starter [andrewmperryman](https://wordpress.org/support/users/andrewmperryman/)
 * (@andrewmperryman)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/posts-saving-slow-db-tables-missing-_wc_admin_notes/#post-14745038)
 * hello [@3sonsdevelopment](https://wordpress.org/support/users/3sonsdevelopment/)
 * Thanks for your input.
 * I have had to recreate the tables and posted the result to this problem here:
 * [https://wordpress.org/support/topic/database-tables-missing-wc_admin_notes-and-wc_admin_note_actions/](https://wordpress.org/support/topic/database-tables-missing-wc_admin_notes-and-wc_admin_note_actions/)
 * I will mark this post issue as resolved..
 * Thanks again.. 🙂
 * Andrew

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

The topic ‘Posts and Preview saving very slow (Db tables missing _wc_admin_notes)’
is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [post](https://wordpress.org/support/topic-tag/post/)
 * [preview](https://wordpress.org/support/topic-tag/preview/)
 * [Saving](https://wordpress.org/support/topic-tag/saving/)

 * 3 replies
 * 2 participants
 * Last reply from: [andrewmperryman](https://wordpress.org/support/users/andrewmperryman/)
 * Last activity: [4 years, 9 months ago](https://wordpress.org/support/topic/posts-saving-slow-db-tables-missing-_wc_admin_notes/#post-14745038)
 * Status: resolved