Fix WooCommerce DB table structure

  • Resolved php-supadev

    (@lbdeveloper)


    2 years, 4 months ago

    Hello,
    for some reason, when i exported my db and imported elsewhere, many WC tables with AUTO_INCREMENT primary key, did not have AUTO_INCREMENT anymore after importing the backup.
    For example wp_woocommerce_attribute_taxonomies

    So i am asking if there is some ready-to-use script which will fix the structure , by adding also the auto_increment starting at highest primary key value plus 1.

    Thanks

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

  • Hello,

    To get a better idea of the context, can you provide more information about the backup process of the database?

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.?

    WE’ll keep an eye on our inbox for your response, thanks.

    Thread Starter php-supadev

    (@lbdeveloper)

    Backup process of whole DB done from phpMyAdmin => Export, then advanced, and i am almost sure i left the default settings.
    The AUTOINCREMENT checkbox is activated by default, but i don’t remember 100% if i deactivated it, i doubt so.

    This is the System Status

    
### WordPress Environment ###

WordPress address (URL): https://test.brandly.co.za
Site address (URL): https://test.brandly.co.za
WC Version: 6.6.1
REST API Version: ? 6.6.1
WC Blocks Version: ? 7.6.2
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.51 (codeit) OpenSSL/1.1.1l PHP/7.4.29
PHP Version: 7.4.29
PHP Post Max Size: 332 MB
PHP Time Limit: 500
PHP Max Input Vars: 1000
cURL Version: 7.29.0
NSS/3.53.1

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

### Database ###

WC Database Version: 6.6.1
WC Database Prefix: wp_
Total Database Size: 1513.25MB
Database Data Size: 951.97MB
Database Index Size: 561.28MB
wp_woocommerce_sessions: Data: 3.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.11MB + Index: 0.11MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
amrod_category: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
amrod_product: Data: 4.52MB + Index: 0.55MB + Engine InnoDB
amrod_product_branding_options: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
amrod_product_cartons: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
amrod_product_images: Data: 8.55MB + Index: 7.55MB + Engine InnoDB
amrod_product_size_attribute: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
amrod_product_variation: Data: 9.52MB + Index: 9.06MB + Engine InnoDB
barron_category: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
barron_product: Data: 1.52MB + Index: 0.66MB + Engine InnoDB
barron_product_branding_options: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
barron_product_images: Data: 4.52MB + Index: 8.03MB + Engine InnoDB
barron_product_variation: Data: 6.52MB + Index: 10.52MB + Engine InnoDB
brandly_application_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_business_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_cache_combined_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
brandly_cache_images: Data: 3.52MB + Index: 1.83MB + Engine InnoDB
brandly_communications_settings: Data: 0.02MB + Index: 0.28MB + Engine InnoDB
brandly_enterprise_royalty_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_fundraisers: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
brandly_fundraiser_wallets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_fundraiser_wallet_topup_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_influencers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_lumise_imported: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
brandly_packaging_products: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
brandly_placeholder_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_resellers_shipping_addresses: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
brandly_resellers_with_packages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
brandly_reseller_branded_packaging: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_reseller_branded_packaging_sizes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
brandly_reseller_gift_wrapping_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_reseller_labels: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_reseller_monthly_visitors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
brandly_reseller_orders: Data: 0.02MB + Index: 0.16MB + Engine InnoDB
brandly_reseller_order_items: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
brandly_reseller_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_reseller_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_saved_designs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_saved_design_images: Data: 0.05MB + Index: 0.08MB + Engine InnoDB
brandly_saved_design_images_back: Data: 0.05MB + Index: 0.08MB + Engine InnoDB
brandly_saved_design_imported_products: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
brandly_saved_design_imported_product_variations: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
brandly_stores_blog_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
brandly_stores_pages: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
brandly_stores_page_component_values: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_page_titles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_predefined_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_predefined_page_components: Data: 0.06MB + Index: 0.14MB + Engine InnoDB
brandly_stores_scheduled_site_deletions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_scheduled_updates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_themes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_themes_selected: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
brandly_stores_woocommerce_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_woocommerce_category_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_woocommerce_images: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
brandly_stores_woocommerce_images_back: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
brandly_stores_woocommerce_imported_products: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
brandly_stores_woocommerce_imported_product_variations: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_branded_image_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_category_deletions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_category_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_category_product_deletions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_category_product_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_category_updates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_order_imports: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_product_deletions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_product_imports: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_product_info_updates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_stores_woocommerce_scheduled_product_search_imports: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_woocommerce_shipping_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_woocommerce_shipping_rates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_woocommerce_shipping_rates_sa: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
brandly_stores_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_woocommerce_shipping_zones_sa: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_stores_woocommerce_shipping_zone_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_students: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_tiers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_tiers_bp_balances: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_tiers_bp_topup_prices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_tiers_bp_topup_transactions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_tiers_store_auto_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_tiers_subscription_payments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
brandly_wallets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_wallet_coupons: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
brandly_wallet_reseller_order_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_wallet_topup_transactions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
brandly_wallet_withdrawal_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
brandly_wallet_withdrawal_transactions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
brandly_wallet_woocommerce_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
earning_margins: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
evolcorr_logs: Data: 121.48MB + Index: 0.31MB + Engine InnoDB
lumise_bugs: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
lumise_categories: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
lumise_categories_reference: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
lumise_cliparts: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
lumise_designs: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
lumise_fonts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
lumise_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
lumise_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
lumise_languages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
lumise_orders: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
lumise_order_products: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
lumise_printings: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
lumise_products: Data: 0.09MB + Index: 0.08MB + Engine InnoDB
lumise_sessions: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
lumise_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
lumise_shapes: Data: 0.22MB + Index: 0.03MB + Engine InnoDB
lumise_shares: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
lumise_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
lumise_tags_reference: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
lumise_templates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
shipping_dimensions_updates: Data: 0.23MB + Index: 0.14MB + Engine InnoDB
shopify_images: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
shopify_images_back: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
shopify_imported_collections: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
shopify_imported_products: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
shopify_imported_product_variations: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
shopify_scheduled_branded_image_imports: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
shopify_scheduled_product_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
shopify_scheduled_product_info_updates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
shopify_shipping_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
shopify_shipping_rates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
shopify_shipping_rates_sa: Data: 1.06MB + Index: 0.05MB + Engine InnoDB
shopify_shipping_zones: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
shopify_shipping_zones_sa: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
shopify_shipping_zone_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
shopify_stores: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
shopify_webhook_requests: Data: 31.47MB + Index: 0.00MB + Engine InnoDB
wix_images: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wix_images_back: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wix_imported_collections: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wix_imported_products: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wix_imported_products_from_api: Data: 0.25MB + Index: 0.02MB + Engine InnoDB
wix_imported_product_variations: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
wix_scheduled_branded_image_imports: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wix_scheduled_product_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wix_scheduled_product_info_updates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wix_scheduled_product_search_imports: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wix_shipping_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wix_shipping_rates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wix_shipping_rates_sa: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
wix_shipping_zones: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wix_shipping_zones_sa: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wix_shipping_zone_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wix_stores: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_actionscheduler_actions: Data: 223.30MB + Index: 202.50MB + 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: 160.22MB + Index: 128.27MB + Engine InnoDB
wp_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ce4wp_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wp_import_detail_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_log_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_postID: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_litespeed_url_file: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_loginizer_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_masterslider_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_masterslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 20.50MB + Index: 2.75MB + Engine InnoDB
wp_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_pmpro_membership_ordermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_pmpro_membership_orders: Data: 0.02MB + Index: 0.20MB + Engine InnoDB
wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 0.02MB + 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_hash: 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_postmeta: Data: 266.83MB + Index: 119.28MB + Engine InnoDB
wp_posts: Data: 37.56MB + Index: 29.63MB + Engine InnoDB
wp_smackcsv_file_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smackuci_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
wp_terms: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
wp_term_relationships: Data: 4.23MB + Index: 2.38MB + Engine InnoDB
wp_term_taxonomy: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
wp_ultimate_csv_importer_acf_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_mappingtemplate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_csv_importer_shortcode_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ultimate_post_entries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wccs_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wccs_condition_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 8.50MB + Index: 9.27MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 15.55MB + Index: 21.05MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpie_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 57902
custom_css: 2
elementor_library: 1
nav_menu_item: 6
page: 29
post: 2
product: 5764
product_variation: 58822
revision: 99
sa_slider: 2
shop_order: 31
wp_global_styles: 1

### Security ###

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

### Active Plugins (15) ###

Brandly International Shipping: by Evolcorr – 1.0.0
Brandly Wallet: by EvolCorr – 1.0
Checkout Files Upload for WooCommerce: by WP Wham – 2.1.2
Ezusy - Image Swatches for Variable Product: by Ezusy – 1.0.5
JWT Authentication for WP-API: by Enrique Chavez – 1.2.6
Kirki Customizer Framework: by David Vongries – 4.0.24
Klaviyo: by Klaviyo
Inc. – 3.0.2

Loginizer: by Softaculous – 1.7.1
Lumise - Product Designer Tool: by King-Theme – 9999991.9.8
Search By SKU - for Woocommerce: by Unroll Digital – 0.8.0
WooCommerce: by Automattic – 6.6.1
WooCommerce PayFast Gateway: by WooCommerce – 1.4.22
The Courier Guy Shipping for WooCommerce: by The Courier Guy – 5.0.8
WP Change Email Sender: by Aminur Islam – 1.0
WordPress REST API Authentication: by miniOrange – 1.6.5

### Inactive Plugins (2) ###

LiteSpeed Cache: by LiteSpeed Technologies – 4.6
Lumise - Product Designer Tool: by King-Theme – 1.9.8

### Settings ###

API Enabled: ?
Force SSL: –
Currency: ZAR (R)
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: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #6 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Brandly Theme
Version: 1.0
Author URL: https://evolcorr.com
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: brandly-theme/woocommerce/cart/cart.php
brandly-theme/woocommerce/cart/mini-cart.php
brandly-theme/woocommerce/cart/proceed-to-checkout-button.php
brandly-theme/woocommerce/content-product.php
brandly-theme/woocommerce/myaccount/dashboard.php
brandly-theme/woocommerce/myaccount/form-edit-account.php
brandly-theme/woocommerce/myaccount/form-edit-address.php
brandly-theme/woocommerce/myaccount/my-account.php
brandly-theme/woocommerce/myaccount/navigation.php
brandly-theme/woocommerce/myaccount/orders.php
brandly-theme/woocommerce/single-product/related.php

### Checkout Files Upload Settings ###

WooCommerce Checkout Files Upload: yes
Total file uploaders: 1
Form extras: yes
Enable alert on successful file upload: yes
Enable alert on successful file remove: yes
Max file size: 15
alg_checkout_files_upload_max_file_size_exceeded_message: Allowed file size exceeded (maximum %max_file_size% MB).
Attach files to admin's new order emails: yes
Attach files to customer's processing order emails: yes
Send additional email to admin on user actions: Array
(
)
Attach file on upload action: yes
Recipient(s): (set)
Subject: [{site_title}] Checkout files upload action in customer order ({order_number}) - {order_date}
Email heading: {action}: File #{file_num}
Email content: File name: {file_name}
Action: File removed: File removed
Action: File uploaded: File uploaded
Before: Label:
					?
					%field_label%%required_html%
				
												
					Field Container:
					?
					%button_html% %field_html%
				
												
					Uploaded File:
					?
					%image% %file_name% %remove_button%
				
												
					After:
Label: 
%field_label%%required_html%: 
Field Container: 
%button_html% %field_html%: 
Uploaded File: %image% %file_name% %remove_button%
After: 
"Delete" button style: color:red;
Image style: width:64px;
Enable/disable: yes
Required: no
Accepted file types: .jpg,.jpeg,.png
Validate image dimensions: 
Width: 1
Height: 1
Checkout page: woocommerce_before_checkout_form
Position order (i.e. priority): 20
"Thank You" page: no
"My Account" page: no
Label: Please select file to upload
Upload button (single): Choose File
Wrong file type: Wrong file type: "%s"!
Wrong image dimensions: Wrong image dimensions: "%s"! Current: %current_width% x %current_height%. Required: %required_width% x %required_height%.
Couldn't get image dimensions: Couldn't get image dimensions: "%s"!
File is required: File is required!
File was successfully uploaded: File "%s" was successfully uploaded.
File was successfully removed: File "%s" was successfully removed.
Require products: 
Require product categories: 
Require product tags: 
Label: 
%field_label%%required_html%: 
Field Container: 
%button_html% %field_html%: 
Uploaded File: %image% %file_name% %remove_button%
After: 

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-07-05 15:22:25 +00:00
Options: ?
Notes: 53
Onboarding: completed

### Action Scheduler ###

Complete: 744,724
Oldest: 2022-06-03 08:24:33 +0000
Newest: 2022-07-05 00:30:48 +0000

Failed: 38
Oldest: 2021-12-25 22:10:06 +0000
Newest: 2022-06-18 11:59:30 +0000

Pending: 4
Oldest: 2022-07-05 00:30:24 +0000
Newest: 2022-07-11 14:11:35 +0000

### Status report information ###

Generated at: 2022-07-05 00:30:54 +00:00
    Plugin Support Kaushik S. a11n

    (@kaushiksomaiya)

    Hi there @lbdeveloper!

    Thanks for getting back.

    To set every WooCommerce table’s first column as the primary key using a script is a tricky task.

    On top of that, there are tables that may have multiple primary keys set with no auto-increment.

    The best way to clone a site is using a migration plugin.

    This also ensures that the server path and domain name changes are taken care of.

    I hope this helps! ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Fix WooCommerce DB table structure’ is closed to new replies.

Tags