Title: Woocommerce DataBase Last modified: January 26, 2021 --- # Woocommerce DataBase * Resolved [sogeel24](https://wordpress.org/support/users/sogeel24/) * (@sogeel24) * [5 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-database-2/) * Hello, * I keep getting woocommerce database needs update daily on my website [http://www.waracake.com](http://www.waracake.com) and this affects some of my plugins such as ‘woocommerce tm extra product options’. I get to miss a lot of information from customers. * Can you help? * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwoocommerce-database-2%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 6 replies - 1 through 6 (of 6 total) * Plugin Support [Riaan K.](https://wordpress.org/support/users/riaanknoetze/) * (@riaanknoetze) * [5 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-database-2/#post-13957341) * Hi there, * Just to make sure: What happens when you follow the prompts on that notice to update the database, does it get updated? Is it reverting to an earlier version every day? Also, can you share a copy of your status report as found under ** WooCommerce > Status**? * Thread Starter [sogeel24](https://wordpress.org/support/users/sogeel24/) * (@sogeel24) * [5 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-database-2/#post-13957349) * It says update complete… * See status report below: * ``` ### WordPress Environment ### WordPress address (URL): https://waracake.com Site address (URL): https://waracake.com WC Version: 4.9.2 REST API Version: ✔ 4.9.2 WC Blocks Version: ✔ 4.0.0 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.8.3 Log Directory Writable: ✔ WP Version: 5.6 WP Multisite: – WP Memory Limit: 768 MB WP Debug Mode: ✔ WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.3.26 PHP Post Max Size: 256 MB PHP Time Limit: 120 PHP Max Input Vars: 3000 cURL Version: 7.66.0 OpenSSL/1.1.1g-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: 4.9.2 WC Database Prefix: wc_ Total Database Size: 167.06MB Database Data Size: 143.65MB Database Index Size: 23.41MB wc_woocommerce_sessions: Data: 0.05MB + Index: 0.00MB + Engine MyISAM wc_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wc_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_woocommerce_order_items: Data: 0.37MB + Index: 0.19MB + Engine MyISAM wc_woocommerce_order_itemmeta: Data: 9.91MB + Index: 1.96MB + Engine MyISAM wc_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wc_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB APBCT_TBL_SESSIONS: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_404_to_301: Data: 88.90MB + Index: 6.15MB + Engine MyISAM wc_actionscheduler_actions: Data: 6.02MB + Index: 2.08MB + Engine InnoDB wc_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_actionscheduler_logs: Data: 1.52MB + Index: 0.84MB + Engine InnoDB wc_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_cleantalk_sessions: Data: 0.51MB + Index: 0.28MB + Engine MyISAM wc_cleantalk_sfw: Data: 0.14MB + Index: 0.27MB + Engine MyISAM wc_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_commentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wc_comments: Data: 0.44MB + Index: 0.19MB + Engine MyISAM wc_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_mailerlite_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_action_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wc_nf3_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_field_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM wc_nf3_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_form_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wc_nf3_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_object_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_options: Data: 2.66MB + Index: 0.23MB + Engine MyISAM wc_pmxe_exports: Data: 0.08MB + Index: 0.00MB + Engine MyISAM wc_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM wc_pmxe_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_postmeta: Data: 15.07MB + Index: 6.17MB + Engine MyISAM wc_posts: Data: 4.65MB + Index: 0.61MB + Engine MyISAM wc_pts_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_pts_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_pts_tables: Data: 0.36MB + Index: 0.00MB + Engine InnoDB wc_pts_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_rmmuc_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_swift_performance_warmup: Data: 0.11MB + Index: 0.16MB + Engine InnoDB wc_termmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM wc_terms: Data: 0.02MB + Index: 0.04MB + Engine MyISAM wc_term_relationships: Data: 0.06MB + Index: 0.13MB + Engine MyISAM wc_term_taxonomy: Data: 0.02MB + Index: 0.02MB + Engine MyISAM wc_ulp_campaigns: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_ulp_campaign_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_ulp_layers: Data: 0.17MB + Index: 0.00MB + Engine MyISAM wc_ulp_popups: Data: 0.05MB + Index: 0.00MB + Engine MyISAM wc_ulp_subscribers: Data: 0.19MB + Index: 0.01MB + Engine MyISAM wc_ulp_targets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_ulp_webfonts: Data: 0.05MB + Index: 0.01MB + Engine MyISAM wc_usermeta: Data: 1.47MB + Index: 0.78MB + Engine MyISAM wc_users: Data: 0.09MB + Index: 0.08MB + Engine MyISAM wc_w3tc_cdn_pathmap: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_w3tc_cdn_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_wc_customer_lookup: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wc_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_wc_order_product_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wc_wc_order_stats: Data: 0.09MB + Index: 0.05MB + Engine InnoDB wc_wc_order_tax_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wc_wc_product_meta_lookup: Data: 0.25MB + Index: 0.55MB + Engine InnoDB wc_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfConfig: Data: 0.42MB + Index: 0.02MB + Engine MyISAM wc_wfCrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfFileMods: Data: 4.89MB + Index: 1.03MB + Engine MyISAM wc_wfHits: Data: 0.76MB + Index: 0.16MB + Engine MyISAM wc_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfIssues: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wc_wfKnownFileList: Data: 2.53MB + Index: 0.32MB + Engine MyISAM wc_wfLiveTrafficHuman: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wc_wfLocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfLogins: Data: 0.04MB + Index: 0.01MB + Engine MyISAM wc_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_wfNotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wc_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfReverseCache: Data: 0.04MB + Index: 0.01MB + Engine MyISAM wc_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfStatus: Data: 0.08MB + Index: 0.04MB + Engine MyISAM wc_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_woocommerce_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_woof_query_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_affiliates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_commissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_commission_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_payments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_payment_commission: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_payment_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcwl: Data: 0.12MB + Index: 0.06MB + Engine MyISAM wc_yith_wcwl_lists: Data: 0.17MB + Index: 0.26MB + Engine MyISAM wc_yoast_seo_links: Data: 0.15MB + Index: 0.04MB + Engine MyISAM wc_yoast_seo_meta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM ### Post Type Counts ### amn_mi-lite: 3 attachment: 1730 custom_css: 1 nav_menu_item: 62 nf_sub: 1 page: 53 post: 58 product: 254 product_variation: 2154 revision: 833 schema: 3 service: 3 shop_coupon: 51 shop_order: 2228 sidebar: 1 testimonials: 1 tm_global_cp: 4 wpcf7_contact_form: 8 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ❌Error messages should not be shown to visitors. ### Active Plugins (30) ### Akismet Anti-Spam: by Automattic – 4.1.8 Schema - All In One Schema Rich Snippets: by Brainstorm Force – 1.6.4 Anti-Spam by CleanTalk: by СleanTalk – 5.151.4 Contact Form 7: by Takayuki Miyoshi – 5.3.2 Envato Market: by Envato – 2.0.6 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.15.0 Google XML Sitemaps: by Auctollo – 4.1.1 My Custom Functions: by Space X-Chimp – 4.48 Nextend Social Login: by Nextendweb – 3.0.26 Nextend Google Connect: by Roland Soos Jamie Bainbridge – 1.6.2 oAuth Twitter Feed for Developers: by Liam Gladdy (Storm Consultancy) – 2.3.0 Official MailerLite Sign Up Forms: by MailerGroup – 1.4.8 Pricing Table by Supsystic: by supsystic.com – 1.8.8 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.4 States, Cities, and Places for WooCommerce: by Kingsley Ochu – 1.3.2 Tawk.to Live Chat: by Tawkto – 0.4.3 Aelia Foundation Classes for WooCommerce: by Aelia – 2.1.2.210108 Payment Gateway - 2Checkout for WooCommerce: by Emran Ahmed – 2.0.3 Checkout Field Editor for WooCommerce: by ThemeHigh – 1.4.5 WooCommerce Random Product Sorting with Pagination: by William Crowley – 0.9.2 WooCommerce Rave Payment Gateway: by Tunbosun Ayinla – 2.2.4 Aelia Currency Switcher for WooCommerce: by Aelia – 4.8.13.200617 WooCommerce Export Customer Email: by MH Mithu – 1.3 WooCommerce TM Extra Product Options: by themeComplete – 5.0.12.11 WooCommerce: by Automattic – 4.9.2 WooSidebars: by WooCommerce – 1.4.5 WP Add Mime Types: by Kimiya Kitani – 2.5.8 WP Change Default From Email: by Subodh Ghulaxe – 1.1.2 WPS Hide Login: by WPServeur NicolasKulka wpformation – 1.6.1 YITH WooCommerce Wishlist: by YITH – 3.0.18 ### Inactive Plugins (5) ### 2FAS Light — Google Authenticator: by Two Factor Authentication Service Inc. – 3.0.2 404 to 301 - Redirect, Log and Notify 404 Errors: by Joel James – 3.0.6 Snow My WP: by Chetan Vengurlekar – 1.5 Under Construction / Maintenance Mode From Acurax: by Acurax – 2.5.9 Valentine's Day Hearts: by Digitally Cultured – 2.0 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: ✔ Force SSL: – Currency: USD ($) 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: #7 - /shop/ Cart: #8 - /cart/ Checkout: #9 - /checkout/ My account: #10 - /my-account/ Terms and conditions: #111 - /terms-of-use/ ### Theme ### Name: Flatsome Child Version: 3.0 Author URL: Child Theme: ✔ Parent Theme Name: Flatsome Parent Theme Version: 3.13.1 Parent Theme Author URL: http://www.uxthemes.com/ WooCommerce Support: ✔ ### Templates ### Overrides: flatsome/woocommerce/archive-product.php flatsome/woocommerce/cart/cart-empty.php flatsome/woocommerce/cart/cart-shipping.php flatsome/woocommerce/cart/cart.php flatsome/woocommerce/checkout/form-checkout.php flatsome/woocommerce/checkout/form-coupon.php flatsome/woocommerce/checkout/terms.php flatsome/woocommerce/checkout/thankyou.php flatsome/woocommerce/content-product-cat.php flatsome/woocommerce/content-product.php flatsome/woocommerce/content-single-product.php flatsome/woocommerce/content-widget-product.php flatsome/woocommerce/global/breadcrumb.php flatsome/woocommerce/global/quantity-input.php flatsome/woocommerce/global/wrapper-end.php flatsome/woocommerce/global/wrapper-start.php flatsome/woocommerce/loop/loop-end.php flatsome/woocommerce/loop/loop-start.php flatsome/woocommerce/loop/pagination.php flatsome/woocommerce/loop/result-count.php flatsome/woocommerce/loop/sale-flash.php flatsome/woocommerce/myaccount/form-login.php flatsome/woocommerce/myaccount/navigation.php flatsome/woocommerce/notices/error.php flatsome/woocommerce/notices/notice.php flatsome/woocommerce/notices/success.php flatsome/woocommerce/product-searchform.php flatsome/woocommerce/single-product/photoswipe.php flatsome/woocommerce/single-product/price.php flatsome/woocommerce/single-product/product-image.php flatsome/woocommerce/single-product/product-thumbnails.php flatsome/woocommerce/single-product/rating.php flatsome/woocommerce/single-product/related.php flatsome/woocommerce/single-product/review.php flatsome/woocommerce/single-product/sale-flash.php flatsome/woocommerce/single-product/share.php flatsome/woocommerce/single-product/short-description.php flatsome/woocommerce/single-product/tabs/tabs.php flatsome/woocommerce/single-product/title.php flatsome/woocommerce/single-product/up-sells.php flatsome/woocommerce/single-product-reviews.php flatsome/woocommerce/single-product.php flatsome/woocommerce/content-product_cat.php ### Action Scheduler ### Complete: 9,049 Oldest: 2020-12-26 09:12:52 +0100 Newest: 2021-01-26 08:54:56 +0100 Failed: 1 Oldest: 2019-10-26 08:12:23 +0100 Newest: 2019-10-26 08:12:23 +0100 Pending: 2 Oldest: 2021-01-26 09:09:56 +0100 Newest: 2021-01-26 09:09:56 +0100 ``` * Plugin Support [Tseten a11n](https://wordpress.org/support/users/tibetanitech/) * (@tibetanitech) * [5 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-database-2/#post-13965324) * Looking at the system status report, it looks like your WooCommerce database is updated to the latest version i.e 4.9.2 * Please confirm, if you are still getting the message to update your database if yes, can you send us the status report again? * Thread Starter [sogeel24](https://wordpress.org/support/users/sogeel24/) * (@sogeel24) * [5 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-database-2/#post-13965333) * HI, I just got it again. * where can i share a screenshot? * ``` ### WordPress Environment ### WordPress address (URL): https://waracake.com Site address (URL): https://waracake.com WC Version: 4.9.2 REST API Version: ✔ 4.9.2 WC Blocks Version: ✔ 4.0.0 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.8.3 Log Directory Writable: ✔ WP Version: 5.6 WP Multisite: – WP Memory Limit: 768 MB WP Debug Mode: ✔ WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.3.26 PHP Post Max Size: 256 MB PHP Time Limit: 120 PHP Max Input Vars: 3000 cURL Version: 7.66.0 OpenSSL/1.1.1g-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: 2.5.4 WC Database Prefix: wc_ Total Database Size: 167.05MB Database Data Size: 143.64MB Database Index Size: 23.41MB wc_woocommerce_sessions: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wc_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wc_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_woocommerce_order_items: Data: 0.37MB + Index: 0.19MB + Engine MyISAM wc_woocommerce_order_itemmeta: Data: 9.91MB + Index: 1.95MB + Engine MyISAM wc_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wc_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB APBCT_TBL_SESSIONS: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_404_to_301: Data: 88.90MB + Index: 6.15MB + Engine MyISAM wc_actionscheduler_actions: Data: 6.02MB + Index: 2.08MB + Engine InnoDB wc_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_actionscheduler_logs: Data: 1.52MB + Index: 0.84MB + Engine InnoDB wc_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_cleantalk_sessions: Data: 0.51MB + Index: 0.28MB + Engine MyISAM wc_cleantalk_sfw: Data: 0.14MB + Index: 0.28MB + Engine MyISAM wc_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_commentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wc_comments: Data: 0.44MB + Index: 0.19MB + Engine MyISAM wc_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_mailerlite_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_action_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wc_nf3_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_field_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM wc_nf3_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_form_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wc_nf3_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_object_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_nf3_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_options: Data: 2.67MB + Index: 0.23MB + Engine MyISAM wc_pmxe_exports: Data: 0.08MB + Index: 0.00MB + Engine MyISAM wc_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM wc_pmxe_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_postmeta: Data: 15.07MB + Index: 6.17MB + Engine MyISAM wc_posts: Data: 4.65MB + Index: 0.61MB + Engine MyISAM wc_pts_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_pts_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_pts_tables: Data: 0.36MB + Index: 0.00MB + Engine InnoDB wc_pts_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_rmmuc_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_swift_performance_warmup: Data: 0.11MB + Index: 0.16MB + Engine InnoDB wc_termmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM wc_terms: Data: 0.02MB + Index: 0.04MB + Engine MyISAM wc_term_relationships: Data: 0.06MB + Index: 0.13MB + Engine MyISAM wc_term_taxonomy: Data: 0.02MB + Index: 0.02MB + Engine MyISAM wc_ulp_campaigns: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_ulp_campaign_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_ulp_layers: Data: 0.17MB + Index: 0.00MB + Engine MyISAM wc_ulp_popups: Data: 0.05MB + Index: 0.00MB + Engine MyISAM wc_ulp_subscribers: Data: 0.19MB + Index: 0.01MB + Engine MyISAM wc_ulp_targets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_ulp_webfonts: Data: 0.05MB + Index: 0.01MB + Engine MyISAM wc_usermeta: Data: 1.47MB + Index: 0.78MB + Engine MyISAM wc_users: Data: 0.09MB + Index: 0.08MB + Engine MyISAM wc_w3tc_cdn_pathmap: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_w3tc_cdn_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_wc_customer_lookup: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wc_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_wc_order_product_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wc_wc_order_stats: Data: 0.09MB + Index: 0.05MB + Engine InnoDB wc_wc_order_tax_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wc_wc_product_meta_lookup: Data: 0.25MB + Index: 0.55MB + Engine InnoDB wc_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfConfig: Data: 0.42MB + Index: 0.02MB + Engine MyISAM wc_wfCrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfFileMods: Data: 4.89MB + Index: 1.03MB + Engine MyISAM wc_wfHits: Data: 0.76MB + Index: 0.16MB + Engine MyISAM wc_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfIssues: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wc_wfKnownFileList: Data: 2.53MB + Index: 0.32MB + Engine MyISAM wc_wfLiveTrafficHuman: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wc_wfLocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfLogins: Data: 0.04MB + Index: 0.01MB + Engine MyISAM wc_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wc_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_wfNotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wc_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfReverseCache: Data: 0.04MB + Index: 0.01MB + Engine MyISAM wc_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_wfStatus: Data: 0.08MB + Index: 0.04MB + Engine MyISAM wc_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wc_woocommerce_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wc_woof_query_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_affiliates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_commissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_commission_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_payments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_payment_commission: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcaf_payment_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wc_yith_wcwl: Data: 0.12MB + Index: 0.06MB + Engine MyISAM wc_yith_wcwl_lists: Data: 0.17MB + Index: 0.26MB + Engine MyISAM wc_yoast_seo_links: Data: 0.15MB + Index: 0.04MB + Engine MyISAM wc_yoast_seo_meta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM ### Post Type Counts ### amn_mi-lite: 3 attachment: 1730 custom_css: 1 nav_menu_item: 62 nf_sub: 1 page: 53 post: 58 product: 254 product_variation: 2154 revision: 833 schema: 3 service: 3 shop_coupon: 51 shop_order: 2228 sidebar: 1 testimonials: 1 tm_global_cp: 4 wpcf7_contact_form: 8 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ❌Error messages should not be shown to visitors. ### Active Plugins (30) ### Akismet Anti-Spam: by Automattic – 4.1.8 Schema - All In One Schema Rich Snippets: by Brainstorm Force – 1.6.4 Anti-Spam by CleanTalk: by СleanTalk – 5.151.4 Contact Form 7: by Takayuki Miyoshi – 5.3.2 Envato Market: by Envato – 2.0.6 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.15.0 Google XML Sitemaps: by Auctollo – 4.1.1 My Custom Functions: by Space X-Chimp – 4.48 Nextend Social Login: by Nextendweb – 3.0.26 Nextend Google Connect: by Roland Soos Jamie Bainbridge – 1.6.2 oAuth Twitter Feed for Developers: by Liam Gladdy (Storm Consultancy) – 2.3.0 Official MailerLite Sign Up Forms: by MailerGroup – 1.4.8 Pricing Table by Supsystic: by supsystic.com – 1.8.8 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.4 States, Cities, and Places for WooCommerce: by Kingsley Ochu – 1.3.2 Tawk.to Live Chat: by Tawkto – 0.4.3 Aelia Foundation Classes for WooCommerce: by Aelia – 2.1.2.210108 Payment Gateway - 2Checkout for WooCommerce: by Emran Ahmed – 2.0.3 Checkout Field Editor for WooCommerce: by ThemeHigh – 1.4.5 WooCommerce Random Product Sorting with Pagination: by William Crowley – 0.9.2 WooCommerce Rave Payment Gateway: by Tunbosun Ayinla – 2.2.4 Aelia Currency Switcher for WooCommerce: by Aelia – 4.8.13.200617 WooCommerce Export Customer Email: by MH Mithu – 1.3 WooCommerce TM Extra Product Options: by themeComplete – 5.0.12.11 WooCommerce: by Automattic – 4.9.2 WooSidebars: by WooCommerce – 1.4.5 WP Add Mime Types: by Kimiya Kitani – 2.5.8 WP Change Default From Email: by Subodh Ghulaxe – 1.1.2 WPS Hide Login: by WPServeur NicolasKulka wpformation – 1.6.1 YITH WooCommerce Wishlist: by YITH – 3.0.18 ### Inactive Plugins (5) ### 2FAS Light — Google Authenticator: by Two Factor Authentication Service Inc. – 3.0.2 404 to 301 - Redirect, Log and Notify 404 Errors: by Joel James – 3.0.6 Snow My WP: by Chetan Vengurlekar – 1.5 Under Construction / Maintenance Mode From Acurax: by Acurax – 2.5.9 Valentine's Day Hearts: by Digitally Cultured – 2.0 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: ✔ Force SSL: – Currency: USD ($) 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: #7 - /shop/ Cart: #8 - /cart/ Checkout: #9 - /checkout/ My account: #10 - /my-account/ Terms and conditions: #111 - /terms-of-use/ ### Theme ### Name: Flatsome Child Version: 3.0 Author URL: Child Theme: ✔ Parent Theme Name: Flatsome Parent Theme Version: 3.13.1 Parent Theme Author URL: http://www.uxthemes.com/ WooCommerce Support: ✔ ### Templates ### Overrides: flatsome/woocommerce/archive-product.php flatsome/woocommerce/cart/cart-empty.php flatsome/woocommerce/cart/cart-shipping.php flatsome/woocommerce/cart/cart.php flatsome/woocommerce/checkout/form-checkout.php flatsome/woocommerce/checkout/form-coupon.php flatsome/woocommerce/checkout/terms.php flatsome/woocommerce/checkout/thankyou.php flatsome/woocommerce/content-product-cat.php flatsome/woocommerce/content-product.php flatsome/woocommerce/content-single-product.php flatsome/woocommerce/content-widget-product.php flatsome/woocommerce/global/breadcrumb.php flatsome/woocommerce/global/quantity-input.php flatsome/woocommerce/global/wrapper-end.php flatsome/woocommerce/global/wrapper-start.php flatsome/woocommerce/loop/loop-end.php flatsome/woocommerce/loop/loop-start.php flatsome/woocommerce/loop/pagination.php flatsome/woocommerce/loop/result-count.php flatsome/woocommerce/loop/sale-flash.php flatsome/woocommerce/myaccount/form-login.php flatsome/woocommerce/myaccount/navigation.php flatsome/woocommerce/notices/error.php flatsome/woocommerce/notices/notice.php flatsome/woocommerce/notices/success.php flatsome/woocommerce/product-searchform.php flatsome/woocommerce/single-product/photoswipe.php flatsome/woocommerce/single-product/price.php flatsome/woocommerce/single-product/product-image.php flatsome/woocommerce/single-product/product-thumbnails.php flatsome/woocommerce/single-product/rating.php flatsome/woocommerce/single-product/related.php flatsome/woocommerce/single-product/review.php flatsome/woocommerce/single-product/sale-flash.php flatsome/woocommerce/single-product/share.php flatsome/woocommerce/single-product/short-description.php flatsome/woocommerce/single-product/tabs/tabs.php flatsome/woocommerce/single-product/title.php flatsome/woocommerce/single-product/up-sells.php flatsome/woocommerce/single-product-reviews.php flatsome/woocommerce/single-product.php flatsome/woocommerce/content-product_cat.php ### Action Scheduler ### Complete: 9,047 Oldest: 2020-12-27 16:05:24 +0100 Newest: 2021-01-27 15:52:58 +0100 Failed: 1 Oldest: 2019-10-26 08:12:23 +0100 Newest: 2019-10-26 08:12:23 +0100 Pending: 2 Oldest: 2021-01-27 16:07:58 +0100 Newest: 2021-01-27 16:07:58 +0100 ``` * Plugin Support [Tseten a11n](https://wordpress.org/support/users/tibetanitech/) * (@tibetanitech) * [5 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-database-2/#post-13969972) * Looking at the latest status report, it shows WC Database Version: 2.5.4, which means your database update was reverted indeed. Since this behavior is not something that is generated from WooCommerce directly, we recommend contacting your host provider to confirm if they reverted the database – it’s worth ruling out. * Also, make sure you’ve cleared the caching on your host, I see that you have the following caching, it might be coming from your host as well: * advanced-cache.php: advanced-cache.php * Clear your cache and try to update the database again. Test if that works. There were some cases in the past where this behavior was caused due to caching as mentioned here: * [https://wordpress.org/support/topic/woocommerce-db-version-keeps-reverting-after-db-data-upgrade/](https://wordpress.org/support/topic/woocommerce-db-version-keeps-reverting-after-db-data-upgrade/) * If you need to share a screenshot and you don’t already have a screenshot service installed, here are a few options: * * [https://snipboard.io](https://snipboard.io) * * [http://skitch.com/](http://skitch.com/) * * [http://getcloudapp.com/](http://getcloudapp.com/) * * [http://awesomescreenshot.com/](http://awesomescreenshot.com/) There is also a walkthrough guide here: [https://en.support.wordpress.com/make-a-screenshot/](https://en.support.wordpress.com/make-a-screenshot/). * Plugin Support [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * (@gabrielfuentes) * [5 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-database-2/#post-14007999) * We’ve not heard back from you in a while, so I’m marking this thread as resolved. * Hopefully, you were able to find a solution to your problem! If you have further questions, please feel free to open a new topic. * Cheers! 🙂 Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Woocommerce DataBase’ 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 * [database](https://wordpress.org/support/topic-tag/database/) * 6 replies * 4 participants * Last reply from: [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * Last activity: [5 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-database-2/#post-14007999) * Status: resolved