• Resolved goldenfish125

    (@goldenfish125)


    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)

    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

    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)

    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.