Table does not exist all WC table

Resolved goldenfish125
(@goldenfish125)

4 years, 11 months ago

My previous post related to this but this is about database problem.
https://wordpress.org/support/topic/item-not-show-in-oder-admin-and-no-option-to-select-varial-product/
Those table gone, but i still able see product detail in wc admin ???

How to fix this ?

### WordPress Environment ###

WordPress address (URL): https://www.quynhanmobile.com
Site address (URL): https://www.quynhanmobile.com
WC Version: 4.2.2
REST API Version: ✔ 1.0.8
WC Blocks Version: ✔ 2.5.16
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 1.2.4
Log Directory Writable: ✔
WP Version: 5.4.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ✔
Language: Because
External object cache: ✔

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.7
PHP Post Max Size: 80 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 7.29.0
NSS / 3.44

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.1.45-MariaDB
Max Upload Size: 80 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 4.2.2
WC Database Prefix: wp_
Total data size: 393.74MB
Database size: 288.24MB
Data index size: 105.50MB
wp_woocommerce_sessions: ❌ Table does not exist
wp_woocommerce_api_keys: ❌ Table does not exist
wp_woocommerce_attribute_taxonomies: ❌ Table does not exist
wp_woocommerce_downloadable_product_permissions: ❌ Table does not exist
wp_woocommerce_order_items: ❌ Table does not exist
wp_woocommerce_order_itemmeta: ❌ Table does not exist
wp_woocommerce_tax_rates: ❌ Table does not exist
wp_woocommerce_tax_rate_locations: ❌ Table does not exist
wp_woocommerce_shipping_zones: ❌ Table does not exist
wp_woocommerce_shipping_zone_locations: ❌ Table does not exist
wp_woocommerce_shipping_zone_methods: ❌ Table does not exist
wp_woocommerce_payment_tokens: ❌ Table does not exist
wp_woocommerce_payment_tokenmeta: ❌ Table does not exist
wp_woocommerce_log: ❌ Table does not exist
ahc_browsers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ahc_countries: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
ahc_hits: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
ahc_keywords: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
ahc_online_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ahc_recent_visitors: Data: 0.83MB + Index: 0.11MB + Engine MyISAM
ahc_refering_sites: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
ahc_searching_visits: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
ahc_search_engines: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ahc_search_engine_crawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ahc_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
ahc_title_traffic: Data: 0.15MB + Index: 0.02MB + Engine MyISAM
ahc_visitors: Data: 0.25MB + Index: 0.15MB + Engine MyISAM
ahc_visits_time: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
backupdb_wp_actionscheduler_actions: Data: 0.17MB + Index: 0.14MB + Engine InnoDB
backupdb_wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_actionscheduler_logs: Data: 0.16MB + Index: 0.13MB + Engine InnoDB
backupdb_wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
backupdb_wp_ewwwio_images: Data: 18.55MB + Index: 17.16MB + Engine InnoDB
backupdb_wp_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_litespeed_cssjs: Data: 3.52MB + Index: 0.14MB + Engine InnoDB
backupdb_wp_litespeed_img_optm: Data: 13.52MB + Index: 11.02MB + Engine InnoDB
backupdb_wp_litespeed_img_optming: Data: 0.30MB + Index: 0.55MB + Engine InnoDB
backupdb_wp_litespeed_optimizer: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_lstat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_options: Data: 6.52MB + Index: 0.56MB + Engine InnoDB
backupdb_wp_pmxe_exports: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxe_posts: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_popularpostsdata: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_popularpostssummary: Data: 0.09MB + Index: 0.19MB + Engine InnoDB
backupdb_wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
backupdb_wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_rank_math_internal_links: Data: 0.30MB + Index: 0.16MB + Engine InnoDB
backupdb_wp_rank_math_internal_meta: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_rank_math_sc_analytics: Data: 10.52MB + Index: 10.59MB + Engine InnoDB
backupdb_wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_rmp_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_stt2_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_tbl_agents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_tbl_conversation: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_tbl_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_tbl_offlinechat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
backupdb_wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
backupdb_wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
backupdb_wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_wc_product_meta_lookup: Data: 0.20MB + Index: 0.45MB + Engine InnoDB
backupdb_wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
backupdb_wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_woocommerce_order_itemmeta: Data: 0.11MB + Index: 0.16MB + Engine InnoDB
backupdb_wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_woocommerce_sessions: Data: 0.42MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
backupdb_wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
backupdb_wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
backupdb_wp_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_wpcc_urls: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
backupdb_wp_xsg_sitemap_meta: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
backupdb_wp_yasr_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_yasr_multi_set: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_yasr_multi_set_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_yasr_multi_values: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_yasr_votes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
backupdb_wp_yoast_seo_links: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
backupdb_wp_yoast_seo_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 64.59MB + Index: 1.39MB + Engine InnoDB
wp_ewwwio_images: Data: 18.55MB + Index: 17.16MB + Engine InnoDB
wp_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_litespeed_cssjs: Data: 4.52MB + Index: 0.16MB + Engine InnoDB
wp_litespeed_img_optm: Data: 13.52MB + Index: 11.02MB + Engine InnoDB
wp_litespeed_img_optming: Data: 0.30MB + Index: 0.55MB + Engine InnoDB
wp_litespeed_optimizer: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_options: Data: 7.47MB + Index: 0.39MB + Engine InnoDB
wp_pmxe_exports: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_popularpostsdata: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_popularpostssummary: Data: 0.09MB + Index: 0.19MB + Engine InnoDB
wp_postmeta: Data: 39.58MB + Index: 12.03MB + Engine InnoDB
wp_posts: Data: 58.56MB + Index: 4.91MB + Engine InnoDB
wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_internal_links: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wp_rank_math_internal_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_redirections_cache: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_sc_analytics: Data: 11.52MB + Index: 10.59MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rmp_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_stock_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_stt2_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_tbl_agents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tbl_conversation: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tbl_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tbl_offlinechat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.30MB + Index: 0.34MB + Engine InnoDB
wp_term_relationships: Data: 1.52MB + Index: 0.50MB + Engine InnoDB
wp_term_taxonomy: Data: 0.25MB + Index: 0.23MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.20MB + Index: 0.42MB + Engine InnoDB
wp_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpcc_urls: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_xsg_sitemap_meta: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
wp_yasr_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yasr_multi_set: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yasr_multi_set_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yasr_multi_values: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yasr_votes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amp_validated_url: 3
attachment: 11920
blocks: 8
custom_css: first
elementor_library: first
featured_item: 8
nav_menu_item: 42
oembed_cache: 19
page: 24
post: 2896
product: 1205
product_variation: 559
revision: 429
shop_coupon: first
shop_order: 140
ufaq: 6
vc_grid_item: first
wcc_sites: 7
woodmart_slide: first
wpcf7_contact_form: 5

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (17) ###

Advanced noCaptcha & invisible Captcha: by Shamim Hasan – 5.7.1 – Installed version not tested with active version of WooCommerce 4.2.2
Classic Editor: by WordPress Collaborators – 1.5
Cloudflare: by Cloudflare
Inc. – 3.5.0

Contact Form 7: by Takayuki Miyoshi – 5.1.9
Easy Table of Contents: by Steven A. Zahm – 2.0.11
OMGF: by Daan van den Bergh – 3.7.0
LiteSpeed Cache: by LiteSpeed Technology – 3.2.3.2
Nextend Social Login: by Nextendweb – 3.0.24
Rank Math SEO: by Rank Math – 1.0.44.1
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.5.2
WooCommerce Stock Manager: by StoreApps – 2.3.0
WooCommerce: by Automattic – 4.2.2
WooSidebars: by WooCommerce – 1.4.5
WP Content Crawler: by Turgut Sarıçam – 1.10.0
WP SMTP: by Yehuda Hassine – 1.1.11
Google XML Sitemap Generator: by XmlSitemapGenerator.org – 1.3.4
YITH WooCommerce Wishlist: by YITH – 3.0.11

### Inactive Plugins (5) ###

Better Search Replace: by Delicious Brains – 1.3.3
heatmap for WordPress: by HeatMap
Inc – 0.5.2

Rate my Post – WP Rating System: by Blaz K. – 3.3.0
WP Content Copy Protection & No Right Click: by wp-buy – 2.5
WP Insert Code: by AntonAKH – 1.0

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
object-cache.php: object-cache.php

### Settings ###

API Enabled: ✔
Force SSL: –
Currency: VND (₫)
Currency Position: right_space
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 0
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 mặc định: # 19332 – / shop /
Giỏ hàng: # 19331 – / cart /
Thanh toán: # 19330 – / checkout /
Tài khoản: # 19329 – / my-account /
Quy định và Điều kiện: # 866 – / general-operational-policy /

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL:
Child Theme: ✔
Parent Theme Name: Flatsome
Parent Theme Version: 3.11.3
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.php
flatsome / woocommerce / content-product_cat.php
flatsome / woocommerce / content-single-product.php
flatsome / woocommerce / content-widget-product.php
flatsome-child / woocommerce / emails / admin-canceled-order.php
flatsome- child / woocommerce / emails / admin-failed-order.php,flatsome-child / woocommerce / emails / admin-new-order.php
flatsome-child / woocommerce / emails / customer-completed-order.php
flatsome-child / woocommerce / emails / customer-invoice.php
flatsome-child / woocommerce / emails / customer-new-account.php
flatsome-child / woocommerce / emails / customer-note.php
flatsome-child / woocommerce / emails / customer-on-hold-order.php
flatsome-child / woocommerce / emails / customer-processing-order.php
flatsome-child / woocommerce / emails / customer-refunded-order.php
flatsome-child / woocommerce / emails / customer-reset-password.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

### Action Scheduler ###

Completed: 208
Oldest: 2020-06-16 11:13:14 +0000
Newest: 2020-07-04 07:43:55 +0000

Failure: first
Oldest: 2020-05-04 08:11:31 +0000
Newest: 2020-05-04 08:11:31 +0000

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

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

Thread Starter goldenfish125
(@goldenfish125)

4 years, 11 months ago
after a few hour go aroud with database, i found sonething

this is the result when i try to cat all file name contain in my database store on my server
this result show the normal contain 2 files
.ibd file and .frm file
```
wp_pmxi_history.ibd
wp_pmxi_images.frm
wp_pmxi_images.ibd
wp_pmxi_imports.frm
wp_pmxi_imports.ibd
wp_pmxi_posts.frm
wp_pmxi_posts.ibd
wp_pmxi_templates.frm
wp_pmxi_templates.ibd
wp_popularpostsdata.frm
wp_popularpostsdata.ibd
wp_popularpostssummary.frm
wp_popularpostssummary.ibd
wp_postmeta.frm
wp_postmeta.ibd
```
and this part
just contain .ibd file, not contain .frm file
```
wp_wc_admin_note_actions.ibd
wp_wc_admin_notes.ibd
wp_wc_category_lookup.ibd
wp_wc_customer_lookup.ibd
wp_wc_download_log.ibd
wp_wc_order_coupon_lookup.ibd
wp_wc_order_product_lookup.ibd
wp_wc_order_stats.ibd
wp_wc_order_tax_lookup.ibd
wp_wcpdf_invoice_number.frm
wp_wcpdf_invoice_number.ibd
wp_wc_product_meta_lookup.frm
wp_wc_product_meta_lookup.ibd
wp_wc_tax_rate_classes.ibd
wp_wc_webhooks.ibd
wp_woocommerce_api_keys.ibd
wp_woocommerce_attribute_taxonomies.ibd
wp_woocommerce_downloadable_product_permissions.ibd
wp_woocommerce_log.ibd
wp_woocommerce_order_itemmeta.ibd
wp_woocommerce_order_items.ibd
wp_woocommerce_payment_tokenmeta.ibd
wp_woocommerce_payment_tokens.ibd
wp_woocommerce_sessions.ibd
wp_woocommerce_shipping_zone_locations.ibd
wp_woocommerce_shipping_zone_methods.ibd
wp_woocommerce_shipping_zones.ibd
wp_woocommerce_tax_rate_locations.ibd
wp_woocommerce_tax_rates.ibd
```
- This reply was modified 4 years, 11 months ago by goldenfish125.
Rynald0s
(@rynald0s)

Automattic Happiness Engineer

4 years, 11 months ago

Hi @goldenfish125!

Please disable and then re-enable the core WooCommerce plugin. Doing so should rebuild these tables.

Please let me know if that helps.

Cheers!

Thread Starter goldenfish125
(@goldenfish125)

4 years, 11 months ago

That’s not work. I delete woo, re setup again, run wizard again but still not fix.
I fix this problem by copy frm files from backup into database folder and chown to mysql user then restart mysql, problem fixed but variation gone, so i create a new variation, then all of my variaton come back. Luckily frm files doesnot contain my data, so when i copy those files, all data come back (they already store in ibd files). I dont know which reason lead to this problem but it’s fixed by copy raw database to fix that.

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

The topic ‘Table does not exist all WC table’ is closed to new replies.