Missing WooCommerce SQL Tables

  • Resolved dan382

    (@dan382)


    6 years, 4 months ago

    Hi,

    I’m using MultilingualPress Version 2.11.1, the latest version of WordPress, the latest version of all plugins alongside a custom theme.

    When I’m duplicating sites I’m encountering an issue where WooCommerce is not fully functional on the new subdomains I’ve created (eg. en. OR au.).

    After investigating the issue I found that there were lot’s of missing SQL tables. I’ve recreated these tables now in PHPMyAdmin e.g.

    
CREATE TABLE <code>loicko2_3_woocommerce_attribute_taxonomies</code> (
  <code>attribute_id</code> bigint(20) UNSIGNED NOT NULL,
  <code>attribute_name</code> varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  <code>attribute_label</code> varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  <code>attribute_type</code> varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  <code>attribute_orderby</code> varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  <code>attribute_public</code> int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

    Which resolves the issues I’m encountering, however, I’d like to avoid the job of manually recreating tables each time I add a site.

    Any ideas what could create a bug along these lines?

    Thanks

    EDIT – By the way, in your ‘read this before posting’ comment there is a bit of a typo. “please don’t post any sensible data publicly!”

    …should read “please don’t post any sensitive data publicly!”

    • This topic was modified 6 years, 4 months ago by dan382.
    • This topic was modified 6 years, 4 months ago by dan382. Reason: Edit added to end

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support dinamiko

    (@dinamiko)

    Hi dan382,

    How is WooCommerce activated? is Network activated or activated in each site individually?

    Thanks,
    Emili

    Thread Starter dan382

    (@dan382)

    Hi Emili,

    A single site existed before the multisite was created. As such it was originally configured for use on the original single site.

    I’ve used your plugin to duplicate WooCommerce (alongside all other plugins) but I haven’t made any additional configuration changes to how WooCommerce functions.

    Are there some settings I’m overlooking here?

    Regards,

    Dan

    Plugin Support dinamiko

    (@dinamiko)

    Hi dan382,

    In that case looks like WooCommerce is activated in your main site, I was asking because in order to use MLP create site based on existing one functionality is better to have WooCommerce activated per site and not Network activated, here is how create site based on existing one process works in MLP:

    1 – First we copy WordPress default tables (wp_posts…) from source site to remote site
    2 – Then we go through all active plugins in source site and active them in remote site, one by one, if the plugin creates tables then new tables will be created in remote site.

    In your case could be that there is some problem activating the plugins in the remote site during the copy site process, you can take a look at the server error log to see if there is some information related to the problem printed there.

    Thanks,
    Emili

    Thread Starter dan382

    (@dan382)

    I’m going to assume it was actually a problem with the theme as there is a fair chunk of old PHP in there.

    Thanks for the information on how the process works. It’s appreciated.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Missing WooCommerce SQL Tables’ is closed to new replies.