Ultimate Member

@smutha25

Did you try to Enable “Enable custom table for usermeta” in UM Settings -> Misc when this happened?

@smutha25

Yes the installation should create this table.

If you have access to phpMyAdmin you can try to SQL create the um-metadata table after you have replaced all xxxxxxxx with your site’s prefix.

You will find the prefix in wp-config.php and the variable $table_prefix.
Note only one underscore character between the prefix and the tabla name.

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
--
-- Table structure for table <code>xxxxxxxx_um_metadata</code>
--
CREATE TABLE <code>xxxxxxxx_um_metadata</code> (
  <code>umeta_id</code> bigint(20) UNSIGNED NOT NULL,
  <code>user_id</code> bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  <code>um_key</code> varchar(255) DEFAULT NULL,
  <code>um_value</code> longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Indexes for table <code>xxxxxxxx_um_metadata</code>
--
ALTER TABLE <code>xxxxxxxx_um_metadata</code>
  ADD PRIMARY KEY (<code>umeta_id</code>),
  ADD KEY <code>user_id_indx</code> (<code>user_id</code>),
  ADD KEY <code>meta_key_indx</code> (<code>um_key</code>(250)),
  ADD KEY <code>meta_value_indx</code> (<code>um_value</code>(191));
--
-- AUTO_INCREMENT for table <code>xxxxxxxx_um_metadata</code>
--
ALTER TABLE <code>xxxxxxxx_um_metadata</code>
  MODIFY <code>umeta_id</code> bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;