Title: Woocom using wrong usermeta table
Last modified: December 27, 2016

---

# Woocom using wrong usermeta table

 *  [crazybeardedman](https://wordpress.org/support/users/crazybeardedman/)
 * (@crazybeardedman)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/woocom-using-wrong-usermeta-table/)
 * We have a multi site installation. The update is looking for the wp_[site_id]
   _usermeta table:
 *  WordPress database error Table ‘mysiet_wp_aws_stage.wp_3_usermeta’ doesn’t exist
   for query
    SELECT umeta_id as meta_id, meta_key, meta_value FROM wp_3_usermeta
   WHERE user_id=13 AND meta_key NOT LIKE ‘wp\_%’ ORDER BY umeta_id
 * The code doing this is in: wp-content/plugins/woocommerce/includes/data-stores/
   class-wc-data-store-wp.php in the get_db_info() function.
 *     ```
        $table          .= $this->meta_type . 'meta';
                       $object_id_field = $this->meta_type . '_id';
   
                       // Figure out our field names.
                       if ( 'user' === $this->meta_type ) {
                               $meta_id_field = 'umeta_id';
                       }
       ```
   
 * Probably need to at least add the following for meta_type == user:
 * `$table = "wp_";`

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

 *  Thread Starter [crazybeardedman](https://wordpress.org/support/users/crazybeardedman/)
 * (@crazybeardedman)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/woocom-using-wrong-usermeta-table/#post-8594767)
 * Sorry, I forgot to mention that I’m using WP4.7 and woocom 2.6.9.
 *  Thread Starter [crazybeardedman](https://wordpress.org/support/users/crazybeardedman/)
 * (@crazybeardedman)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/woocom-using-wrong-usermeta-table/#post-8614966)
 * Downloaded 2.6.11, but change log doesn’t show this problem as fixed. Should 
   I be reporting this somewhere else?

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

The topic ‘Woocom using wrong usermeta table’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [usermeta](https://wordpress.org/support/topic-tag/usermeta/)
 * [woocomerce](https://wordpress.org/support/topic-tag/woocomerce/)

 * 2 replies
 * 1 participant
 * Last reply from: [crazybeardedman](https://wordpress.org/support/users/crazybeardedman/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/woocom-using-wrong-usermeta-table/#post-8614966)
 * Status: not resolved