• Resolved smutha25

    (@smutha25)


    I have installed Ultimate member plugin for admin roles and getting below error.Could you please help us to resolve the issue.

    Fatal error: Uncaught mysqli_sql_exception: Table 'xcvhv54d.wp_rmwzhcer_um_metadata' doesn't exist in D:\inetpub\wwwroot\wp-includes\wp-db.php:2024
    
    Stack trace:
    
    0 D:\inetpub\wwwroot\wp-includes\wp-db.php(2024): mysqli_query()
    
    1 D:\inetpub\wwwroot\wp-includes\wp-db.php(1912): wpdb->_do_query()
    
    2 D:\inetpub\wwwroot\wp-includes\wp-db.php(2641): wpdb->query()
    
    #3 D:\inetpub\wwwroot\wp-admin\includes\upgrade.php(2645): wpdb->get_results()
    
    4 D:\inetpub\wwwroot\wp-content\plugins\ultimate-member\includes\core\class-setup.php(59): dbDelta()
    
    5 D:\inetpub\wwwroot\wp-content\plugins\ultimate-member\includes\core\class-setup.php(30): um\core\Setup->create_db()
    
    6 D:\inetpub\wwwroot\wp-content\plugins\ultimate-member\includes\class-init.php(522): um\core\Setup->run_setup()
    
    7 D:\inetpub\wwwroot\wp-content\plugins\ultimate-member\includes\class-init.php(452): UM->single_site_activation()
    
    8 D:\inetpub\wwwroot\wp-includes\class-wp-hook.php(287): UM->activation()
    
    9 D:\inetpub\wwwroot\wp-includes\class-wp-hook.php(311): WP_Hook->apply_filters()
    
    10 D:\inetpub\wwwroot\wp-includes\plugin.php(478): WP_Hook->do_action()
    
    11 D:\inetpub\wwwroot\wp-admin\plugins.php(179): do_action()
    
    12 {main} thrown in D:\inetpub\wwwroot\wp-includes\wp-db.php on line 2024
Viewing 5 replies - 1 through 5 (of 5 total)
  • @smutha25

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

    Thread Starter smutha25

    (@smutha25)

    Apologies, I have downloaded and installed but when trying to activate the plugin in my website then I am getting this fatal error.

    To enable the custom table it should first activate the plugin?

    @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;
    Plugin Support andrewshu

    (@andrewshu)

    Hi @smutha25

    This thread has been inactive for a while so we’re going to go ahead and mark it Resolved.

    Please feel free to re-open this thread if any other questions come up and we’d be happy to help. 🙂

    Regards

    Thread Starter smutha25

    (@smutha25)

    Apologies for delay.

    It is resolved by your help.Thank you for the answer

    I have one more question but unable to create a topic so I just want to continue here :

    I have a created new role and my requirement is if any user added into that role they should not be able to edit their own profile(Cannot change their role to another role. Eg : Admin, Editor or Author).

    Through ultimate member plugin the users who added into this custom role cannot change their role to another role(Editor,Author,subscriber) but able to change their role to Adminstrator.

    Could you please help me to resolve this issue. How the users cannot change their role to admin when added to this new role(Support).

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

The topic ‘Ultimate Member’ is closed to new replies.