• Resolved jasali

    (@jasali)


    I was trying to do create a new package in Duplicator. During the scan process, I get a Table Details warning with the below information.

    Tables:
    kr_commentmeta
    Case:0
    Rows:0
    Size:48KB
    kr_comments
    Case:0
    Rows:1
    Size:96KB
    kr_datalist
    Case:0
    Rows:0
    Size:4KB
    kr_duplicator_packages
    Case:0
    Rows:2
    Size:32KB
    kr_layerslider
    Case:0
    Rows:2
    Size:160KB
    kr_links
    Case:0
    Rows:0
    Size:32KB
    kr_options
    Case:0
    Rows:416
    Size:1.53MB
    kr_postmeta
    Case:0
    Rows:85,933
    Size:14.55MB
    kr_posts
    Case:0
    Rows:1,329
    Size:4.88MB
    kr_term_relationships
    Case:0
    Rows:12,723
    Size:1.98MB
    kr_term_taxonomy
    Case:0
    Rows:1,151
    Size:240KB
    kr_termmeta
    Case:0
    Rows:1,351
    Size:272KB
    kr_terms
    Case:0
    Rows:1,151
    Size:224KB
    kr_usermeta
    Case:0
    Rows:31
    Size:48KB
    kr_users
    Case:0
    Rows:1
    Size:64KB
    kr_woocommerce_api_keys
    Case:0
    Rows:0
    Size:48KB
    kr_woocommerce_attribute_taxonomies
    Case:0
    Rows:0
    Size:32KB
    kr_woocommerce_downloadable_product_permissions
    Case:0
    Rows:0
    Size:48KB
    kr_woocommerce_order_itemmeta
    Case:0
    Rows:0
    Size:48KB
    kr_woocommerce_order_items
    Case:0
    Rows:0
    Size:32KB
    kr_woocommerce_payment_tokenmeta
    Case:0
    Rows:0
    Size:48KB
    kr_woocommerce_payment_tokens
    Case:0
    Rows:0
    Size:32KB
    kr_woocommerce_sessions
    Case:0
    Rows:1
    Size:32KB
    kr_woocommerce_shipping_zone_locations
    Case:0
    Rows:0
    Size:64KB
    kr_woocommerce_shipping_zone_methods
    Case:0
    Rows:0
    Size:16KB
    kr_woocommerce_shipping_zones
    Case:0
    Rows:1
    Size:16KB
    kr_woocommerce_tax_rate_locations
    Case:0
    Rows:0
    Size:64KB
    kr_woocommerce_tax_rates
    Case:0
    Rows:1
    Size:80KB

    How i fix it ?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Cory Lamle

    (@corylamleorg)

    Hey @jasali,

    Thanks for the feedback! There are a few items on the FAQ that may provide a solution with this issue, this one may get you going.

    ? ? – What if I see warnings or errors during the ‘Scan Process’?
    ? ? – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-package-020-q

    Let me know if any of them help~

    Thread Starter jasali

    (@jasali)

    Thank you so much error details:

    Overview:
    The thresholds that trigger warnings for individual tables are 10MB OR 100,000 records OR tables names with upper-case characters. The larger the table the more time it takes to process and execute. This can cause issues with budget hosts that have cpu/memory limits, and timeout constraints.

    Options:
    1. Run a Repair and Optimization on the table to improve the overall size and performance.

    2. Remove stale date from tables such as logging, statistical or other non-critical data.

    3. For table name case sensitivity issues either rename the table with lower case characters or be prepared to work with the lower_case_table_names system variable setting.

    Tables:
    kr_commentmeta
    Case:0
    Rows:0
    Size:48KB
    kr_comments
    Case:0
    Rows:1
    Size:96KB
    kr_datalist
    Case:0
    Rows:0
    Size:4KB
    kr_duplicator_packages
    Case:0
    Rows:1
    Size:32KB
    kr_layerslider
    Case:0
    Rows:2
    Size:160KB
    kr_links
    Case:0
    Rows:0
    Size:32KB
    kr_options
    Case:0
    Rows:422
    Size:1.31MB
    kr_postmeta
    Case:0
    Rows:87,398
    Size:15.55MB
    kr_posts
    Case:0
    Rows:1,313
    Size:4.88MB
    kr_term_relationships
    Case:0
    Rows:12,563
    Size:1.98MB
    kr_term_taxonomy
    Case:0
    Rows:1,166
    Size:240KB
    kr_termmeta
    Case:0
    Rows:1,366
    Size:272KB
    kr_terms
    Case:0
    Rows:1,071
    Size:224KB
    kr_usermeta
    Case:0
    Rows:31
    Size:48KB
    kr_users
    Case:0
    Rows:1
    Size:64KB
    kr_woocommerce_api_keys
    Case:0
    Rows:0
    Size:48KB
    kr_woocommerce_attribute_taxonomies
    Case:0
    Rows:0
    Size:32KB
    kr_woocommerce_downloadable_product_permissions
    Case:0
    Rows:0
    Size:48KB
    kr_woocommerce_order_itemmeta
    Case:0
    Rows:0
    Size:48KB
    kr_woocommerce_order_items
    Case:0
    Rows:0
    Size:32KB
    kr_woocommerce_payment_tokenmeta
    Case:0
    Rows:0
    Size:48KB
    kr_woocommerce_payment_tokens
    Case:0
    Rows:0
    Size:32KB
    kr_woocommerce_sessions
    Case:0
    Rows:1
    Size:32KB
    kr_woocommerce_shipping_zone_locations
    Case:0
    Rows:0
    Size:64KB
    kr_woocommerce_shipping_zone_methods
    Case:0
    Rows:0
    Size:16KB
    kr_woocommerce_shipping_zones
    Case:0
    Rows:1
    Size:16KB
    kr_woocommerce_tax_rate_locations
    Case:0
    Rows:0
    Size:64KB
    kr_woocommerce_tax_rates
    Case:0
    Rows:1
    Size:80KB

    Cory Lamle

    (@corylamleorg)

    You can try and fix with these options:

    Options:
    1. Run a Repair and Optimization on the table to improve the overall size and performance. 2. Remove stale date from tables such as logging, statistical or other non-critical data. 3. For table name case sensitivity issues either rename the table with lower case characters or be prepared to work with the lower_case_table_names system variable setting.

    Remember these are just warnings and you can still try and see if the build works….

    Hope that helps~

    Thread Starter jasali

    (@jasali)

    Thank you so much for answer im thinking its important thinks i try run and repair but its not work give a error in there too

    Cory Lamle

    (@corylamleorg)

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Duplicator Package Table Details Warn’ is closed to new replies.