Title: Missing WooCommerce SQL Tables
Last modified: November 20, 2018

---

# Missing WooCommerce SQL Tables

 *  Resolved [dan382](https://wordpress.org/support/users/dan382/)
 * (@dan382)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/missing-woocommerce-sql-tables/)
 * 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 7 years, 6 months ago by [dan382](https://wordpress.org/support/users/dan382/).
    -  This topic was modified 7 years, 6 months ago by [dan382](https://wordpress.org/support/users/dan382/).
      Reason: Edit added to end
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fmissing-woocommerce-sql-tables%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [dinamiko](https://wordpress.org/support/users/dinamiko/)
 * (@dinamiko)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/missing-woocommerce-sql-tables/#post-10902407)
 * Hi dan382,
 * How is WooCommerce activated? is Network activated or activated in each site 
   individually?
 * Thanks,
    Emili
 *  Thread Starter [dan382](https://wordpress.org/support/users/dan382/)
 * (@dan382)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/missing-woocommerce-sql-tables/#post-10904263)
 * 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](https://wordpress.org/support/users/dinamiko/)
 * (@dinamiko)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/missing-woocommerce-sql-tables/#post-10921747)
 * 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](https://wordpress.org/support/users/dan382/)
 * (@dan382)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/missing-woocommerce-sql-tables/#post-10924665)
 * 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.

 * ![](https://ps.w.org/multilingual-press/assets/icon-256x256.png?rev=2188271)
 * [MultilingualPress](https://wordpress.org/plugins/multilingual-press/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/multilingual-press/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/multilingual-press/)
 * [Active Topics](https://wordpress.org/support/plugin/multilingual-press/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/multilingual-press/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/multilingual-press/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [dan382](https://wordpress.org/support/users/dan382/)
 * Last activity: [7 years, 6 months ago](https://wordpress.org/support/topic/missing-woocommerce-sql-tables/#post-10924665)
 * Status: resolved