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