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_idThe 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)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Woocom using wrong usermeta table’ is closed to new replies.